public DataTable InsertBuyer(Buyers buyer) { DataTable dt = null; using (BuyerGateway buyerGateway = new BuyerGateway()) { dt = buyerGateway.InsertBuyer(buyer); } return(dt); }
public int UpdateBuyerInfo(Buyers buyer) { int dt = 0; try { using (BuyerGateway buyerGateway = new BuyerGateway()) { dt = buyerGateway.UpdateBuyerInfo(buyer); } } catch (Exception ex) { } return(dt); }
public DataTable LoadBuyerName() { DataTable dt = null; try { using (BuyerGateway buyerGateway = new BuyerGateway()) { dt = buyerGateway.LodaBuyerInfo(); } } catch (Exception ex) { } return(dt); }
public string LoadBuyerInfo() { StringBuilder tableRow = new StringBuilder(); try { using (BuyerGateway buyerGateway = new BuyerGateway()) { int count = 0; DataTable dt = buyerGateway.LodaBuyerInfo(); if (dt.Rows.Count > 0) { tableRow.Append("<table class='table table-bordered;'><thead><tr class='success'>" + "<th style='width: 25 %;text-align:center;padding: 12px; color: #FFFFFF; background-color:#0099FF;border: 2px solid #ffffff'>Sl</th>" + "<th style='width: 25 %;text-align:center;padding: 12px; color: #FFFFFF; background-color:#0099FF;border: 2px solid #ffffff'>Buyer Id</th>" + "<th style='width: 25 %;text-align:center;padding: 12px; color: #FFFFFF; background-color:#0099FF;border: 2px solid #ffffff'>Buyer Name</th>" + "<th style='width: 25 %;text-align:center;padding: 12px; color: #FFFFFF; background-color:#0099FF;border: 2px solid #ffffff'>Is Active</th>" + "<th style='width: 25 %;text-align:center;padding: 12px; color: #FFFFFF; background-color:#0099FF;border: 2px solid #ffffff'>Action</th>" + "</tr></thead >"); for (int i = 0; i < dt.Rows.Count; i++) { count++; tableRow.Append("<tbody><tr style='border:1px solid #ffffff;background-color:lavender;'>"); tableRow.Append("<td style='text-align:center; border: 2px solid #ffffff'>" + count + "</td>"); tableRow.Append("<td style='width: 25 %;text-align:center; border: 2px solid #ffffff;padding: 5px;color: black;'>" + dt.Rows[i]["BuyerId"] + "</td>"); tableRow.Append("<td style='width: 25 %;text-align:center; border: 2px solid #ffffff;padding: 5px;color: black;'>" + dt.Rows[i]["BuyerName"] + "</td>"); tableRow.Append("<td style='width: 25 %;text-align:center; border: 2px solid #ffffff;padding: 5px;color: black;'>" + dt.Rows[i]["IsActive"] + "</td>"); tableRow.Append("<td style='width: 25 %;text-align:center; border: 2px solid #ffffff;padding: 5px;color: black;'><a href='BuyerEntry.aspx?Id=" + dt.Rows[i]["BuyerId"] + "'>Edit</a></td>"); tableRow.Append("</tr></tbody>"); } tableRow.Append("</table>"); } else { tableRow.Append("No Data Found"); } } } catch (Exception ex) { } return(tableRow.ToString()); }
public void LoadFoeUpdate(int buyerId) { DataTable dt = null; try { using (BuyerGateway buyerGateway = new BuyerGateway()) { dt = buyerGateway.LoadForUpdate(buyerId); if (dt.Rows.Count > 0) { buyerTextBox.Text = Convert.ToString(dt.Rows[0]["BuyerName"]); isActiveHiddenField.Value = Convert.ToString(dt.Rows[0]["IsActive"]); //string value = isActiveHiddenField.Value; IsActiveDropDownList.SelectedValue = Convert.ToString(isActiveHiddenField.Value); //IsActiveDropDownList.SelectedValue= Convert.ToString(dt.Rows[0]["IsActive"]); } } } catch (Exception ex) { } }
public void SendMailForApprovedByNotSet(CostingSmv smv) { string buyerName = String.Empty; string sampleStage = String.Empty; string postedByName = String.Empty; string zoneName = String.Empty; BuyerGateway buyerGateway = new BuyerGateway(); DataTable dt = new DataTable(); if (smv.UpdatedBy == 0) { dt = buyerGateway.GetSendingMailInfo(smv.BuyerId, smv.SampleStageId, smv.PostedBy); } else { dt = buyerGateway.GetSendingMailInfo(smv.BuyerId, smv.SampleStageId, smv.UpdatedBy); } 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("<h3>Dear Concern,</h3>" + "<br/>" + " <p>" + " The costing smv of Buyer Name : " + buyerName + ", <br/> Style number: " + smv.StyleNumber + " <br/> Design number: " + smv.DesignNumber + " <br/> Sample Stage : " + sampleStage + ", <br/> Season : " + smv.Season + ", <br/> Sewing Smv:" + smv.SewingSmv + " <br/> was stored by : " + postedByName + " <br/> Without Approved From: " + zoneName + " </p>" + "<br/>" + " Thank You" + "<br/>" + "**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("*****@*****.**", "No-Reply", System.Text.Encoding.UTF8); mail.Subject = "Approval Missing For - Style:" + smv.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 = 25; client.Host = "mail.hirdaramani.com"; //client.EnableSsl = true; 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; } } }
public void SendMailForCostingSmv(CostingSmv smv) { 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(smv.BuyerId, smv.SampleStageId, smv.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 new costing smv on Buyer Name : " + buyerName + ", Style number: " + smv.StyleNumber + " Sample Stage : " + sampleStage + ", Season : " + smv.Season + "Sewing Smv:" + smv.SewingSmv + " was stored by : " + postedByName + "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("*****@*****.**"); mail.To.Add("*****@*****.**"); mail.To.Add("*****@*****.**"); mail.To.Add("*****@*****.**"); mail.To.Add("*****@*****.**"); mail.To.Add("*****@*****.**"); //mail.To.Add("ismatkhanzarin @gmail.com"); mail.From = new MailAddress("*****@*****.**", "Smv System", System.Text.Encoding.UTF8); mail.Subject = "New Smv For - Style:" + smv.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; try { client.Send(mail); } catch (Exception ex) { Exception ex2 = ex; string errorMessage = string.Empty; while (ex2 != null) { errorMessage += ex2.ToString(); ex2 = ex2.InnerException; throw ex2; } } }