private string Validate_Lot(CuttingOutStock _CuttingOutStock)
{
string message = "";
bool flag = false;
// for Lot
flag = CuttingOutStock_DA.IsLotBeforeOutStock(_CuttingOutStock);
if (!flag)
{
message = "-1";
}
return message;
}
private void SendNotification(CuttingOutStock _CuttingOutStock, DataTable dt)
{
string MessageBody = "Edited By : <b>" + Session["User"].ToString().ToUpper() + "</b><br><br>" + DateTime.UtcNow.AddHours(5) + "<br><h3>Before Edit</h3>";
string tableStart = "<table style=\" width:100%;border-collapse: collapse;\">";//border: 1px solid #ddd;
string tableEnd = "</table>";
string MessageHeader = "<tr>";
string MessageDataOld = "<tr>";
string MessageDataNew = "<tr>";
#region Old Header New
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + Convert.ToDateTime(dt.Rows[0]["Date"].ToString()).ToString("MM/dd/yyyy") + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Date" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _CuttingOutStock.Date.ToString("MM/dd/yyyy") + "</td>";
if (dt.Rows[0]["Company"].ToString() == "")
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Company_DA.Get_Company_By_Id(int.Parse(dt.Rows[0]["Company"].ToString()))).Rows[0]["Name"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Company" + "</th>";
if (_CuttingOutStock.Company == null)
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Company_DA.Get_Company_By_Id(int.Parse(_CuttingOutStock.Company.ToString()))).Rows[0]["Name"] + "</td>";
if (dt.Rows[0]["Lot_1"].ToString() == "")
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Lot_DA.Get_Lot_By_Id(int.Parse(dt.Rows[0]["Lot_1"].ToString()))).Rows[0]["Name"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Lot" + "</th>";
if (_CuttingOutStock.Lot_1 == null)
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Lot_DA.Get_Lot_By_Id(int.Parse(_CuttingOutStock.Lot_1.ToString()))).Rows[0]["Name"] + "</td>";
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0]["Pcs"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Pcs" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _CuttingOutStock.Pcs + "</td>";
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0]["Sqft"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Sqft" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _CuttingOutStock.Sqft + "</td>";
if (dt.Rows[0]["Lot_2"].ToString() == "")
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Lot_DA.Get_Lot_By_Id(int.Parse(dt.Rows[0]["Lot_2"].ToString()))).Rows[0]["Name"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Lot" + "</th>";
if (_CuttingOutStock.Lot_2 == null)
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + "" + "</td>";
else
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + ((DataTable)Lot_DA.Get_Lot_By_Id(int.Parse(_CuttingOutStock.Lot_2.ToString()))).Rows[0]["Name"] + "</td>";
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0]["Pcs2"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Pcs" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _CuttingOutStock.Pcs2 + "</td>";
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0]["Sqft2"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Sqft" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _CuttingOutStock.Sqft2 + "</td>";
MessageDataOld += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + dt.Rows[0]["Description"] + "</td>";
MessageHeader += "<th align=\"left\" style=\"border: 1px solid #ddd;height: 30px;\">" + "Description" + "</th>";
MessageDataNew += "<td style=\"border: 1px solid #ddd;font-family:Courier New;height: 50px;\">" + _CuttingOutStock.Description + "</td>";
#endregion
MessageDataOld += "</tr>";
MessageHeader += "</tr>";
MessageDataNew += "</tr>";
MessageBody += tableStart + MessageDataOld + MessageHeader + MessageDataNew + tableEnd + "<h3>After Edit</h3>";
sendMail.sendEmailMessage(ConfigurationManager.AppSettings["From"], ConfigurationManager.AppSettings["To"], ConfigurationManager.AppSettings["Password"], "Cutting OutSource Edit", MessageBody);
}
public string Update(int Id, int Company, int Lot1, int Pcs, float Sqft, int Lot2, int Pcs2, float Sqft2, string Description, string Date)
{
CuttingOutStock _CuttingOutStock = new CuttingOutStock();
_CuttingOutStock.Id = Id;
_CuttingOutStock.Lot_1 = Lot1;
_CuttingOutStock.Company = Company;
if (Lot2 != -1)
{
_CuttingOutStock.Lot_2 = Lot2;
_CuttingOutStock.Pcs2 = Pcs2;
_CuttingOutStock.Sqft2 = Sqft2;
}
_CuttingOutStock.Pcs = Pcs;
_CuttingOutStock.Sqft = Sqft;
_CuttingOutStock.Date = Convert.ToDateTime(Date);
_CuttingOutStock.Description = Description;
#region Cutting
Cutting _Cutting = new Cutting();
_Cutting.Lot_1 = Lot1;
if (Lot2 != -1)
{
_Cutting.Lot_2 = Lot2;
_Cutting.Pcs2 = Pcs2;
_Cutting.Sqft2 = Sqft2;
}
_Cutting.Pcs = Pcs;
_Cutting.Sqft = Sqft;
#endregion
string msg = Validate_Lot(_CuttingOutStock);
if (msg == "")
{
DataTable dt = CuttingOutStock_DA.Get_CuttingOutstock_By_ID(Id);
msg = validating_Pcs_Sqft_For_Cutter(ref _Cutting, dt.Rows[0]["Lot_1"].ToString(), dt.Rows[0]["Pcs"].ToString(), dt.Rows[0]["Sqft"].ToString(), dt.Rows[0]["Lot_2"].ToString(), dt.Rows[0]["Pcs2"].ToString(), dt.Rows[0]["Sqft2"].ToString());
msg += CuttingOutStock_DA.UpdateCuttingOutstock(_CuttingOutStock);
OldPcsSqftEntry(dt.Rows[0]["Lot_1"].ToString(), dt.Rows[0]["Pcs"].ToString(), dt.Rows[0]["Sqft"].ToString());
if (dt.Rows[0]["Lot_2"].ToString() != "")
OldPcsSqftEntry(dt.Rows[0]["Lot_2"].ToString(), dt.Rows[0]["Pcs2"].ToString(), dt.Rows[0]["Sqft2"].ToString());
UpdateDeliveryForCuttingOutStock(Lot1, Pcs, Sqft, Lot2, Pcs2, Sqft2);
if (Session["User"].ToString().ToUpper() != ("Mustafa Piracha").ToUpper())
{
SendNotification(_CuttingOutStock, dt);
}
}
return msg;
}
public CuttingOutStock Get(int Id)
{
CuttingOutStock _CuttingOutStock = new CuttingOutStock();
DataTable dt = CuttingOutStock_DA.Get_CuttingOutstock_By_ID(Id);
foreach (DataRow row in dt.Rows)
{
_CuttingOutStock.Company = int.Parse(row["Company"].ToString());
_CuttingOutStock.Lot_1 = int.Parse(row["Lot_1"].ToString());
_CuttingOutStock.Pcs = int.Parse(row["Pcs"].ToString());
_CuttingOutStock.Sqft = float.Parse(row["Sqft"].ToString());
if (row["Lot_2"].ToString() != "")
_CuttingOutStock.Lot_2 = int.Parse(row["Lot_2"].ToString());
if (row["Pcs2"].ToString() != "")
_CuttingOutStock.Pcs2 = int.Parse(row["Pcs2"].ToString());
if (row["Sqft2"].ToString() != "")
_CuttingOutStock.Sqft2 = float.Parse(row["Sqft2"].ToString());
_CuttingOutStock.Date2 = Convert.ToDateTime(row["Date"].ToString()).ToString("MM/dd/yyyy");
_CuttingOutStock.Description = row["Description"].ToString();
}
return _CuttingOutStock;
}
private bool Validate_Lot()
{
lblMessage.Text = "";
lblMessage.ForeColor = System.Drawing.Color.Red;
bool flag = false;
#region CuttingOutStock
CuttingOutStock _CuttingOutStock = new CuttingOutStock();
_CuttingOutStock.Lot_1 = int.Parse(ddlLot1.SelectedValue);
if (divLot2.Visible == true)
{
_CuttingOutStock.Lot_2 = int.Parse(ddlLot2.SelectedValue);
}
_CuttingOutStock.Date = Convert.ToDateTime(txtDate.Text);
#endregion
// for Lot
flag = CuttingOutStock_DA.IsLotBeforeOutStock(_CuttingOutStock);
if (!flag)
{
lblMessage.Text = "Your Out Sourcing Date is earlier than Lot";
}
return flag;
}
protected void InsertCuttingOutStock()
{
#region CuttingOutStock
CuttingOutStock _CuttingOutStock = new CuttingOutStock();
_CuttingOutStock.Company = int.Parse(ddlCompany.SelectedValue);
_CuttingOutStock.Lot_1 = int.Parse(ddlLot1.SelectedValue);
if (ddlLot2.SelectedValue != "")
{
_CuttingOutStock.Lot_2 = int.Parse(ddlLot2.SelectedValue);
_CuttingOutStock.Pcs2 = int.Parse(txtPcs2.Text);
_CuttingOutStock.Sqft2 = float.Parse(txtSqFt2.Text);
}
_CuttingOutStock.Pcs = int.Parse(txtPcs.Text);
_CuttingOutStock.Sqft = float.Parse(txtSqFt.Text);
_CuttingOutStock.Date = Convert.ToDateTime(txtDate.Text);
_CuttingOutStock.Description = txtDescription.Text;
_CuttingOutStock.IsDeleted = false;
#endregion
lblMessage.Text += CuttingOutStock_DA.InsertCuttingOutStock(_CuttingOutStock);
if (!lblMessage.Text.Contains(Constants.ALREADY_EXIST))
{
UpdateDeliveryForCuttingOutStock();
lblMessage.ForeColor = System.Drawing.Color.Green;
Response.Write("<script>alert('Inserted Successfully'); document.location='/forms/formCuttingOutStock';</script>");
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}