hi sir/mam, i have an gridview from that i'm storing gridview data into database, but here i'm using the for loop for counting the each row and storing the data in database, but this process taking too much time to insert and give success result.
how i can do that , help me to fix this
ButtonSession();
LoadCompany();
int _total = 0;
int _curstock = 0;
int _soldstock = 0;
int _dumpstock = 0;
double _ms = 0.0;
string UpTotal = string.Empty;
string Upcurstock = string.Empty;
string Upsold = string.Empty;
string Updump = string.Empty;
string status = "1".ToString();
string x = string.Empty;
string _cftotal=string.Empty;
string _obtotal = string.Empty;
int _dcqty = 0;
_delcno = _dccode.ToString() + ddlsp.SelectedItem.Value.ToString() + _delcdate.ToString();
_delcno = _delcno.Replace("-", String.Empty);
MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["Panel"].ConnectionString);
con.Open();
for (int i = 0; i < GrvProduct.Rows.Count; i++)
{
int totalQty = 0;
int cfQty = 0;
int obQty = 0;
Label lblpcode = (Label)GrvProduct.Rows[i].Cells[1].FindControl("lblpcode");
Label lblpack = (Label)GrvProduct.Rows[i].Cells[3].FindControl("lblpack");
Label lblprice = (Label)GrvProduct.Rows[i].Cells[4].FindControl("lblprice");
TextBox Crrtxtqty = (TextBox)GrvProduct.Rows[i].Cells[5].FindControl("txtcrqty");
TextBox txtqty = (TextBox)GrvProduct.Rows[i].Cells[6].FindControl("txtqty");
Label lblobstock = (Label)GrvProduct.Rows[i].Cells[1].FindControl("lblobstock");
Label lblcfstock = (Label)GrvProduct.Rows[i].Cells[1].FindControl("lblcfstock");
_dcqty = Convert.ToInt32(txtqty.Text.Trim());
if (lblobstock.Text.Trim() == null)
{
obQty = 0;
// totalQty = Convert.ToInt32(txtqty.Text.Trim());
}
else if (lblobstock.Text.Trim() == "")
{
obQty = 0;
//totalQty = Convert.ToInt32(txtqty.Text.Trim());
}
else
{
obQty = Convert.ToInt32(lblobstock.Text.Trim());
//totalQty = Convert.ToInt32(lblsqty.Text.Trim()) + Convert.ToInt32(txtqty.Text.Trim());
}
if (lblcfstock.Text.Trim() == null)
{
cfQty = 0;
}
else if (lblcfstock.Text.Trim() == "")
{
cfQty = 0;
}
else
{
cfQty = Convert.ToInt32(lblcfstock.Text.Trim());
}
totalQty = Convert.ToInt32(obQty.ToString()) + Convert.ToInt32(cfQty.ToString()) + Convert.ToInt32(txtqty.Text.Trim());
using (MySqlCommand cmd = new MySqlCommand("GenerateEsudum",con))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
try
{
InventoryObject objio = new InventoryObject();
objio.BranchCode = _CompId.ToString();
objio.ProdcutCode = lblpcode.Text.Trim();
InventoryLayer objil = new InventoryLayer();
MySqlDataReader dr = null;
dr = objil.LoadProductStock(objio);
while (dr.Read())
{
_total = Convert.ToInt32(dr["TotalStock"].ToString());
_curstock = Convert.ToInt32(dr["CurrentStock"].ToString());
_soldstock = Convert.ToInt32(dr["SoldStock"].ToString());
_dumpstock = Convert.ToInt32(dr["DumpStock"].ToString());
_ms = Convert.ToDouble(dr["MsPack"].ToString());
}
Upcurstock = Convert.ToString(_curstock - (Convert.ToInt32(txtqty.Text.Trim()) + _dumpstock));
Upsold = Convert.ToString(Convert.ToInt32(txtqty.Text.Trim()) + _soldstock);
}
catch
{
throw;
}
cmd.Parameters.AddWithValue("@bcode", _CompId.ToString());
cmd.Parameters.AddWithValue("@spcode", ddlsp.SelectedItem.Value);
cmd.Parameters.AddWithValue("@sarea", txtarea.Text.Trim());
cmd.Parameters.AddWithValue("@tno", _tinno.ToString());
cmd.Parameters.AddWithValue("@gno", _gstno.ToString());
cmd.Parameters.AddWithValue("@dno", _delcno.ToString());
cmd.Parameters.AddWithValue("@esgno", txtesno.Text.Trim());
cmd.Parameters.AddWithValue("@prcode", lblpcode.Text.Trim());
cmd.Parameters.AddWithValue("@pack", lblpack.Text.Trim());
cmd.Parameters.AddWithValue("@pqty", txtqty.Text.Trim());
cmd.Parameters.AddWithValue("@tsqty", totalQty.ToString());
cmd.Parameters.AddWithValue("@cfqty", cfQty.ToString());
cmd.Parameters.AddWithValue("@obqty", obQty.ToString());
cmd.Parameters.AddWithValue("@prprice", lblprice.Text.Trim());
cmd.Parameters.AddWithValue("@dcdate", _uploaddate);
cmd.Parameters.AddWithValue("@mcadate", _datetime);
cmd.Parameters.AddWithValue("@dcstatus", status.ToString());
//con.Open();
cmd.Connection = con;
x = Convert.ToString(cmd.ExecuteScalar());
//con.Close();
if (x == "1")
{
try
{
InventoryObject objupcfo = new InventoryObject();
objupcfo.ProdcutCode = lblpcode.Text.Trim();
objupcfo.BranchCode = _CompId.ToString();
objupcfo.SalesCode = ddlsp.SelectedItem.Value;
objupcfo.TotalStock = "0".ToString();
objupcfo.UpdateDate = _uploaddate.ToString();
InventoryLayer objupcfl = new InventoryLayer();
int result = objupcfl.UpdateCarryForwardStockGrid(objupcfo);
}
catch
{
throw;
}
try
{
OrderBookingObject objupcfo = new OrderBookingObject();
objupcfo.Product = lblpcode.Text.Trim();
objupcfo.BranchCode = _CompId.ToString();
objupcfo.saleCode = ddlsp.SelectedItem.Value;
objupcfo.Qty = "0".ToString();
objupcfo.CurrentDate = _uploaddate.ToString();
OrderBookingLayer objupcfl = new OrderBookingLayer();
int result = objupcfl.UpdateOrderCarryForwardStockGrid(objupcfo);
}
catch
{
throw;
}
try
{
InventoryObject objupo = new InventoryObject();
objupo.ProdcutCode = lblpcode.Text.Trim();
objupo.BranchCode = _CompId.ToString();
objupo.TotalStock = _total.ToString();
objupo.CurrentStock = Upcurstock.ToString();
objupo.DumpStock = _dumpstock.ToString();
objupo.SoldQty = Upsold.ToString();
objupo.UpdateDate = _uploaddate.ToString();
InventoryLayer objupl = new InventoryLayer();
int result = objupl.NewUpdateProductStock(objupo);
}
catch
{
throw;
}
}
}
}
}
con.Close();
if (x == "1")
{
GeneratePdf();
//GenerateMsDc();
}
else if (x == "2")
{
lbldcmsg.Visible = false;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Message", "alert('DC Already Generated for the Sales Person : " + ddlsp.SelectedItem.Text + " ');", true);
}
else
{
lbldcmsg.Visible = false;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Message", "alert('Old DC No : " + x + " is not yet Closed, Close the DC and try again');", true);
}