NO I don't.
My code is
protected void btnGR_Click(object sender, EventArgs e)
{
//open conection
SqlConnection myCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DCDBStr"].ToString());
myCon.Open();
try
{
DataTable dt = this.getInvoice();
if (dt.Rows.Count > 0)
{
//Group PONO for delete from good receive table
DataSetHelper dsHelper = new DataSetHelper();
DataTable dtGroupPO = dsHelper.SelectDistinct("tblGroupPO", dt, "PONO");
//Delete PONO from GoodReceive table and Stocks table
for (int j = 0; j <= dtGroupPO.Rows.Count - 1; j++)
{
string sqlStr = string.Format("DELETE FROM GoodReceives WHERE PONO='{0}'", dtGroupPO.Rows[j]["PONO"].ToString());
SqlCommand cm = myCon.CreateCommand();
cm.CommandText = sqlStr;
cm.ExecuteNonQuery();
string sqlStrDel = string.Format("DELETE FROM Stocks WHERE PONO='{0}'", dtGroupPO.Rows[j]["PONO"].ToString());
SqlCommand cmDel = myCon.CreateCommand();
cmDel.CommandText = sqlStrDel;
cmDel.ExecuteNonQuery();
}
//Loop for insert to table GoodReceive
GoodReceives gr = new GoodReceives();
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
gr.GRDate = txtGRDate.Text;
gr.PONO = dt.Rows[i]["PONO"].ToString();
gr.MaterialCode = dt.Rows[i]["MaterialCode"].ToString();
gr.GRQuantity = Convert.ToInt32(dt.Rows[i]["Quantity"].ToString());
gr.Username = Session["UserName"].ToString();
gr.VenderID = cboVender.SelectedValue.ToString();
gr.License = txtLicense.Text;
string sqlStrInsGR = string.Format("INSERT INTO GoodReceives(GRDate,PONO,MaterialCode,GRQuantity,Username,VenderID,License)VALUES('{0}','{1}','{2}',{3},'{4}','{5}','{6}')", gr.GRDate, gr.PONO, gr.MaterialCode, gr.GRQuantity, gr.Username, gr.VenderID,gr.License);
SqlCommand cm2 = myCon.CreateCommand();
cm2.CommandText = sqlStrInsGR;
cm2.ExecuteNonQuery();
}
RadAjaxManager1.Alert("complete");
RadAjaxManager1.Redirect("Goodreceive.aspx");
}
else
{
RadAjaxManager1.Alert("No Data");
}
}
catch (Exception ex)
{
if (myCon != null)
myCon.Close();
}
}
Vatcharm, if this helps please login to Mark As Answer. | Alert Moderator