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;
}
}
}
