protected void Btncancel_Click(object sender, EventArgs e) { iProductMasterClient productClient = new iProductMasterClient(); CustomProfile profile = CustomProfile.GetProfile(); productClient.DeleteOrderImport(profile.DBConnection._constr); productClient.Close(); }
protected void btnback_Click(object sender, EventArgs e) { iProductMasterClient productClient = new iProductMasterClient(); CustomProfile profile = CustomProfile.GetProfile(); productClient.DeleteOrderImport(profile.DBConnection._constr); productClient.Close(); Response.Redirect("DirectImportD.aspx"); }
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(); } }
protected void btnUploadPo_Click(object sender, EventArgs e) { con1.ConnectionString = ConfigurationManager.ConnectionStrings["elegantcrm7ConnectionString"].ConnectionString; DataSet ds = new DataSet(); DataTable dt = new DataTable(); iProductMasterClient productClient = new iProductMasterClient(); CustomProfile profile = CustomProfile.GetProfile(); try { productClient.DeleteOrderImport(profile.DBConnection._constr); string connString = ""; string path = FileuploadPO.PostedFile.FileName; string strFileType = System.IO.Path.GetExtension(path).ToString().ToLower(); string Fullpath = Server.MapPath("../PowerOnRent/OrderImport/" + path); // string Fullpath = "https://testoms.gwclogistics.com/GWCTestVersion2/PowerOnRent/OrderImport/1DirectOrderImportTest.xlsx"; FileuploadPO.PostedFile.SaveAs(Server.MapPath("../PowerOnRent/OrderImport/" + path)); if (strFileType.Trim() == ".xls") { connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Fullpath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (strFileType.Trim() == ".xlsx") { connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Fullpath + ";Extended Properties='Excel 8.0;HDR=Yes'"; } OleDbConnection excelConnection = new OleDbConnection(connString); OleDbCommand cmd1 = new OleDbCommand("Select * from [Template$]", excelConnection); excelConnection.Open(); OleDbDataReader dReader; dReader = cmd1.ExecuteReader(); SqlBulkCopy sqlBulk = new SqlBulkCopy(con1); con1.Open(); sqlBulk.DestinationTableName = "TempOrderImport"; sqlBulk.WriteToServer(dReader); excelConnection.Close(); ds = productClient.GetTempDirectOrder(profile.DBConnection._constr); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { //System.Threading.Thread.Sleep(8000); // Label1.Text = "Upload Successful !!!"; lblmessagesuccess.Visible = true; Button12.Enabled = true; Button12.CssClass = "class2"; // adm.UpdateStudenttrim(); } else { WebMsgBox.MsgBox.Show("Upload Not Successful, Please Upload Right Template"); } //adm.UpdateStudenttrim(); //} //getDepartment(long.Parse(hdncompanyid.Value)); // ddldepartment.SelectedIndex = ddldepartment.Items.IndexOf(ddldepartment.Items.FindByValue(hdndeptid.Value.ToString())); // GetLocation(long.Parse(hdncompanyid.Value)); // ddllocation.SelectedIndex = ddllocation.Items.IndexOf(ddllocation.Items.FindByValue(hdnlocation.Value.ToString())); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "showAlert", "showAlert('" + ex.ToString() + "','Error','#');", true); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Exception in Catch!');", true); } finally { con1.Close(); productClient.Close(); } }