public DataTable InsertBulkRevisedSmv(BulkSmv bulk) { DataTable dt = null; try { OpenConnection(); ArrayList arlSqlParameter = new ArrayList(); arlSqlParameter.Add(new SqlParameter("@BuyerId", bulk.BuyerId)); arlSqlParameter.Add(new SqlParameter("@SampleStageId", bulk.SampleStageId)); //arlSqlParameter.Add(new SqlParameter("@StyleId", bulk.StyleId)); arlSqlParameter.Add(new SqlParameter("@StyleNumber", bulk.StyleNumber)); arlSqlParameter.Add(new SqlParameter("@StyleDescription", bulk.StyleDescription)); arlSqlParameter.Add(new SqlParameter("@FabricId", bulk.FabricId)); arlSqlParameter.Add(new SqlParameter("@SewingSmv", bulk.SewingSmv)); arlSqlParameter.Add(new SqlParameter("@OverlayFilm", bulk.OverlaySmv)); arlSqlParameter.Add(new SqlParameter("@Fits", bulk.FitsSmv)); arlSqlParameter.Add(new SqlParameter("@PLKQuiltingSmv", bulk.PlkQuilting)); arlSqlParameter.Add(new SqlParameter("@AutoQuiltingSmv", bulk.AutoQuilting)); arlSqlParameter.Add(new SqlParameter("@ManualQuiltingSmv", bulk.ManualQuilting)); arlSqlParameter.Add(new SqlParameter("@ManualDownFill", bulk.ManualDownFill)); arlSqlParameter.Add(new SqlParameter("@MachineDownFill", bulk.MachineDownFill)); arlSqlParameter.Add(new SqlParameter("@FinishingSmv", bulk.FinishingSmv)); arlSqlParameter.Add(new SqlParameter("@CostingSmvId", bulk.CostingSmvId)); //arlSqlParameter.Add(new SqlParameter("@OptionData", data)); arlSqlParameter.Add(new SqlParameter("@ReviewBy", bulk.ReviewBy)); arlSqlParameter.Add(new SqlParameter("@ApprovedBy", bulk.ApprovedBy)); arlSqlParameter.Add(new SqlParameter("@PostedBy", bulk.PostedBy)); arlSqlParameter.Add(new SqlParameter("@UpdatedBy", bulk.UpdatedBy)); arlSqlParameter.Add(new SqlParameter("@ProductCategory", bulk.ProductCategory)); arlSqlParameter.Add(new SqlParameter("@SampleDate", bulk.SampleDate)); //arlSqlParameter.Add(new SqlParameter("@WorkUpdate", bulk.WorkUpdate)); arlSqlParameter.Add(new SqlParameter("@MachineWork", bulk.MachineWork)); arlSqlParameter.Add(new SqlParameter("@Description", bulk.Description)); arlSqlParameter.Add(new SqlParameter("@SeasonId", bulk.SeasonId)); dt = this.ExecuteQuery("[KP].[USP_InsertBulkRevisedSmvInfo]", arlSqlParameter); } catch (Exception ex) { } finally { CloseConnection(); } return(dt); }
public int UpdateBulkInfo(BulkSmv bulk) { int actionResult = 0; try { OpenConnection(); ArrayList arlSqlParameter = new ArrayList(); arlSqlParameter.Add(new SqlParameter("@BuklSmvId", bulk.BulkSmvId)); arlSqlParameter.Add(new SqlParameter("@BuyerId", bulk.BuyerId)); arlSqlParameter.Add(new SqlParameter("@SampleStageId", bulk.SampleStageId)); //arlSqlParameter.Add(new SqlParameter("@StyleId", bulk.StyleId)); arlSqlParameter.Add(new SqlParameter("@StyleNumber", bulk.StyleNumber)); arlSqlParameter.Add(new SqlParameter("@StyleDescription", bulk.StyleDescription)); arlSqlParameter.Add(new SqlParameter("@FabricId", bulk.FabricId)); arlSqlParameter.Add(new SqlParameter("@SewingSmv", bulk.SewingSmv)); arlSqlParameter.Add(new SqlParameter("@OverlayFilm", bulk.OverlaySmv)); arlSqlParameter.Add(new SqlParameter("@Fits", bulk.FitsSmv)); arlSqlParameter.Add(new SqlParameter("@PLKQuiltingSmv", bulk.PlkQuilting)); arlSqlParameter.Add(new SqlParameter("@AutoQuiltingSmv", bulk.AutoQuilting)); arlSqlParameter.Add(new SqlParameter("@ManualQuiltingSmv", bulk.ManualQuilting)); arlSqlParameter.Add(new SqlParameter("@ManualDownFill", bulk.ManualDownFill)); arlSqlParameter.Add(new SqlParameter("@MachineDownFill", bulk.MachineDownFill)); arlSqlParameter.Add(new SqlParameter("@FinishingSmv", bulk.FinishingSmv)); arlSqlParameter.Add(new SqlParameter("@ReviewBy", bulk.ReviewBy)); arlSqlParameter.Add(new SqlParameter("@ApprovedBy", bulk.ApprovedBy)); arlSqlParameter.Add(new SqlParameter("@UpdatedBy", bulk.UpdatedBy)); arlSqlParameter.Add(new SqlParameter("@ProductCategory", bulk.ProductCategory)); arlSqlParameter.Add(new SqlParameter("@SampleDate", bulk.SampleDate)); //arlSqlParameter.Add(new SqlParameter("@WorkUpdate", bulk.WorkUpdate)); arlSqlParameter.Add(new SqlParameter("@MachineWork", bulk.MachineWork)); arlSqlParameter.Add(new SqlParameter("@Description", bulk.Description)); arlSqlParameter.Add(new SqlParameter("@SeasonId", bulk.SeasonId)); actionResult = this.ExecuteActionQuery("[kp].[USP_UpdateBulkSmvInfo]", arlSqlParameter); } catch (Exception ex) { } finally { CloseConnection(); } return(actionResult); }
protected void updateButton_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); try { int value = 0; BulkSmv bulk = new BulkSmv(); BulkSmvBLL bulkSmvBLL = new BulkSmvBLL(); MailClass mailClass = new MailClass(); bulk.BuyerId = Convert.ToInt32(buyerNameDropDownList.SelectedValue); value = Convert.ToInt32(sampleStageHiddenField.Value); bulk.SampleStageId = value; bulk.FabricId = Convert.ToInt32(fabricDropDownList.SelectedValue); //bulk.StyleId= Convert.ToInt32(styleDropDownList.SelectedValue); bulk.StyleNumber = styleNumberTextBox.Text.Trim(); bulk.StyleDescription = styleDescriptionTextBox.Text; bulk.ProductCategory = Convert.ToInt32(ProductDropDownList.SelectedValue); //bulk.WorkUpdate = remarksTextArea.InnerText; //bulk.SampleDate = sampleDateTextBox.Text; //bulk.SeasonId= SeasonDropDownList.SelectedValue; bulk.SeasonId = seasonTextBox.Text.Trim(); if (sampleDateTextBox.Text == "1900-01-01") { bulk.SampleDate = Convert.ToString(""); } else { bulk.SampleDate = Convert.ToString(sampleDateTextBox.Text); } bulk.MachineWork = machineDetailsTextarea.InnerText; bulk.Description = descriptionTextarea.InnerText; if (sewingTextBox.Text == "" || sewingTextBox.Text == null) { bulk.SewingSmv = Convert.ToDecimal("0.00"); } else { bulk.SewingSmv = Convert.ToDecimal(sewingTextBox.Text); } if (fitsTextBox.Text == "" || fitsTextBox.Text == null) { bulk.FitsSmv = Convert.ToDecimal("0.00"); } else { bulk.FitsSmv = Convert.ToDecimal(fitsTextBox.Text); } if (overlayTextBox.Text == "" || overlayTextBox == null) { bulk.OverlaySmv = Convert.ToDecimal("0.00"); } else { bulk.OverlaySmv = Convert.ToDecimal(overlayTextBox.Text); } if (plkTextBox.Text == "" || plkTextBox.Text == null) { bulk.PlkQuilting = Convert.ToDecimal("0.00"); } else { bulk.PlkQuilting = Convert.ToDecimal(plkTextBox.Text); } if (autoTextBox.Text == "" || autoTextBox.Text == null) { bulk.AutoQuilting = Convert.ToDecimal("0.00"); } else { bulk.AutoQuilting = Convert.ToDecimal(autoTextBox.Text); } if (quiltingManualTextBox.Text == "" || quiltingManualTextBox.Text == null) { bulk.ManualQuilting = Convert.ToDecimal("0.00"); } else { bulk.ManualQuilting = Convert.ToDecimal(quiltingManualTextBox.Text); } if (downManualTextBox.Text == "" || downManualTextBox.Text == null) { bulk.ManualDownFill = Convert.ToDecimal("0.00"); } else { bulk.ManualDownFill = Convert.ToDecimal(downManualTextBox.Text); } if (downMachineTextBox.Text == "" || downMachineTextBox.Text == null) { bulk.MachineDownFill = Convert.ToDecimal("0.00"); } else { bulk.MachineDownFill = Convert.ToDecimal(downMachineTextBox.Text); } if (finishingTextBox.Text == "" || finishingTextBox.Text == null) { bulk.FinishingSmv = Convert.ToDecimal("0.00"); } else { bulk.FinishingSmv = Convert.ToDecimal(finishingTextBox.Text); } bulk.ReviewBy = Convert.ToInt32(reviewDropDownList.SelectedValue); bulk.ApprovedBy = Convert.ToInt32(approvedDropDownList.SelectedValue); if (bulkSmvId != 0) { bulk.BulkSmvId = bulkSmvId; bulk.UpdatedBy = Convert.ToInt32(userId); actionResult = bulkSmvBLL.UpdateBulkSmv(bulk); if (actionResult >= 1) { if (bulk.ApprovedBy == 0) { mailClass.SendMailForApprovedByNotSetOfBulk(bulk); } messageLabel.Text = "<p Style ='font-size:20px;color:Green; margin-top:20px;'> Information Successfully Updated</p>"; ClearAllData(); Page.Response.Redirect(url.ToString(), true); } else { messageLabel.Text = "<p Style ='font-size:20px;color:Red; margin-top:20px;'>Already Exists...</p>"; } } } catch (Exception ex) { } table = LoadRevisedBulkSmvinformation(buyerId, styleNumber); mainBody.Visible = false; }
public void SendMailForApprovedByNotSetOfBulk(BulkSmv bulk) { string buyerName = String.Empty; string sampleStage = String.Empty; string postedByName = String.Empty; string zoneName = String.Empty; BuyerGateway buyerGateway = new BuyerGateway(); DataTable dt = new DataTable(); dt = buyerGateway.GetSendingMailInfo(bulk.BuyerId, bulk.SampleStageId, bulk.PostedBy); if (dt.Rows.Count > 0) { buyerName = dt.Rows[0]["BuyerName"].ToString(); sampleStage = dt.Rows[0]["SampleStage"].ToString(); postedByName = dt.Rows[0]["PostedByName"].ToString(); zoneName = dt.Rows[0]["ZoneName"].ToString(); } StringBuilder mailBody = new StringBuilder(); mailBody.Append("Dear Concern," + " The bulk smv of Buyer Name : " + buyerName + ", Style number: " + bulk.StyleNumber + " Sample Stage : " + sampleStage + ", Season : " + bulk.SeasonId + "Sewing Smv:" + bulk.SewingSmv + " was stored by : " + postedByName + " Without Approved From: " + zoneName + "Thank You" + "**NB:- Please do not reply this Email" ); System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); //mail.To.Add("*****@*****.**"); //mail.To.Add("*****@*****.**"); //if (zoneName == "CEPZ") //{ // mail.To.Add("*****@*****.**"); //} //else if (zoneName == "KEPZ") //{ // mail.To.Add("*****@*****.**"); //} //mail.To.Add("*****@*****.**"); //mail.To.Add("*****@*****.**"); mail.To.Add("*****@*****.**"); // mail.From = new MailAddress("*****@*****.**", "Smv System", System.Text.Encoding.UTF8); mail.From = new MailAddress("*****@*****.**", "No-Reply", System.Text.Encoding.UTF8); mail.Subject = "Approval Missing For - Style:" + bulk.StyleNumber; mail.SubjectEncoding = System.Text.Encoding.UTF8; mail.Body = mailBody.ToString(); mail.BodyEncoding = System.Text.Encoding.UTF8; mail.IsBodyHtml = true; mail.Priority = MailPriority.High; SmtpClient client = new SmtpClient(); //client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "@2018Smv"); //client.Port = 587; //client.Host = "smtp.gmail.com"; //client.EnableSsl = true; client.Port = 25; client.Host = "mail.hirdaramani.com"; try { //if(zoneName == "KEPZ" || zoneName == "CEPZ") //{ client.Send(mail); //} } catch (Exception ex) { Exception ex2 = ex; string errorMessage = string.Empty; while (ex2 != null) { errorMessage += ex2.ToString(); ex2 = ex2.InnerException; throw ex2; } } }