protected void btnnext_Click(object sender, EventArgs e) { DataSet ds1 = new DataSet(); DataTable dt1 = new DataTable(); iProductMasterClient productClient = new iProductMasterClient(); iPartRequestClient objService = new iPartRequestClient(); CustomProfile profile = CustomProfile.GetProfile(); decimal TotalProdQty = 0m, totalPrice = 0m; string Title = "Direct Order Import"; string OrderNumber = ""; DateTime orderdate = DateTime.Now; try { ds = productClient.GetDistinctPLCodes(profile.DBConnection._constr); //ds = productClient.GetDirectOrderData(profile.DBConnection._constr); dt = ds.Tables[0]; for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { DataSet ds2 = new DataSet(); DataTable dt2 = new DataTable(); long disDeptid = long.Parse(ds.Tables[0].Rows[i]["deptId"].ToString()); long DisLocId = long.Parse(ds.Tables[0].Rows[i]["LocID"].ToString()); long CompanyID = long.Parse(ds.Tables[0].Rows[i]["ParentID"].ToString()); long Orderheadid = 0; ds2 = productClient.GetTotalForOrderHead(disDeptid, DisLocId, profile.DBConnection._constr); dt2 = ds2.Tables[0]; if (dt2.Rows.Count > 0) { TotalProdQty = decimal.Parse(dt2.Rows[0]["TotalOrderQty"].ToString()); totalPrice = decimal.Parse(dt2.Rows[0]["GrandTotalPrice"].ToString()); } OrderNumber = productClient.getOrderFormatNumber(disDeptid, profile.DBConnection._constr); ds1 = productClient.GetImportDatabyDisDeptLocId(disDeptid, DisLocId, profile.DBConnection._constr); dt1 = ds1.Tables[0]; long sequence = 0; for (int j = 0; j <= ds1.Tables[0].Rows.Count - 1; j++) { long UOMID = 16; string skucode = ds1.Tables[0].Rows[j]["SKUCode"].ToString(); string SkuName = ds1.Tables[0].Rows[j]["Name"].ToString(); string Description = ds1.Tables[0].Rows[j]["Description"].ToString(); decimal AvailableBalance = decimal.Parse(ds1.Tables[0].Rows[j]["AvailableBalance"].ToString()); decimal RequestQty = decimal.Parse(ds1.Tables[0].Rows[j]["asRequestQty"].ToString()); decimal OrderQty = decimal.Parse(ds1.Tables[0].Rows[j]["OrderQty"].ToString()); decimal Price = decimal.Parse(ds1.Tables[0].Rows[j]["Price"].ToString()); decimal Total = decimal.Parse(ds1.Tables[0].Rows[j]["Total"].ToString()); long locationid = long.Parse(ds1.Tables[0].Rows[j]["locationid"].ToString()); long prodID = long.Parse(ds1.Tables[0].Rows[j]["prodID"].ToString()); long storeID = long.Parse(ds1.Tables[0].Rows[j]["ID"].ToString()); decimal Dispatch = decimal.Parse(ds1.Tables[0].Rows[j]["TotalDispatchQty"].ToString()); //TotalProdQty = TotalProdQty + OrderQty; //totalPrice = totalPrice + Total; long maxdeldays = productClient.GetmaxDeliverydays(storeID, profile.DBConnection._constr); DateTime Deliveryday = DateTime.Now.AddDays(maxdeldays); decimal CurrentAvailBalance = AvailableBalance - OrderQty; decimal CurrentDispatchQty = Dispatch + OrderQty; sequence = sequence + 1; if (j == 0) { Orderheadid = productClient.SaveOrderHeaderImport(storeID, orderdate, Deliveryday, 0, 3, profile.Personal.UserID, DateTime.Now, Title, DateTime.Now, TotalProdQty, totalPrice, OrderNumber, locationid, profile.DBConnection._constr); } productClient.SaveOrderDetailImport(Orderheadid, prodID, OrderQty, UOMID, sequence, SkuName, Description, skucode, Price, Total, profile.DBConnection._constr); productClient.updateproductstockdetailimport(storeID, prodID, CurrentAvailBalance, CurrentDispatchQty, profile.DBConnection._constr); } productClient.ImportMsgTransHeader(Orderheadid, profile.DBConnection._constr); int x = objService.EmailSendWhenRequestSubmit(Orderheadid, profile.DBConnection._constr); DataSet dss = new DataSet(); dss = objService.GetApproverDepartmentWise(disDeptid, profile.DBConnection._constr); for (int t = 0; t <= dss.Tables[0].Rows.Count - 1; t++) { long approverid = Convert.ToInt64(dss.Tables[0].Rows[t]["UserId"].ToString()); objService.EmailSendofApproved(approverid, Orderheadid, profile.DBConnection._constr); } } productClient.DeleteOrderImport(profile.DBConnection._constr); Response.Redirect("ImportOrderF.aspx"); } catch { productClient.DeleteSKUPricetemp(profile.DBConnection._constr); } finally { productClient.Close(); } }