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