public PurchaseOrderDetailsBO countTotalPodId()
{
var query = (from pod in context.PurchaseOrderDetails
orderby pod.PODetailsID descending
select new { pod.PODetailsID }).First();
PurchaseOrderDetailsBO pbo = new PurchaseOrderDetailsBO();
pbo.PoDetailsId = query.PODetailsID;
return(pbo);
}
public PurchaseOrderDetail convertPurchaseOrderDetails(PurchaseOrderDetailsBO pobo)
{
PurchaseOrderDetail pod = new PurchaseOrderDetail();
pod.PODetailsID = pobo.PoDetailsId;
pod.POID = pobo.PoId;
pod.SupplierID = pobo.SupplierId;
pod.ItemNumber = pobo.ItemNumber;
pod.Quantity = pobo.Quantity;
return(pod);
}
public Boolean createPurchaseOrderDetails(PurchaseOrderDetailsBO pod)
{
poda = new PurchaseOrderDA();
return(poda.createPODetails(convertPurchaseOrderDetails(pod)));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataTable datatbl = new DataTable();
if (Session["createPO"] != null && Convert.ToInt32(Session["gvCount"]) == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(),
"alert",
"alert('Please select item's criteria first');window.location ='CreatePO.aspx';",
true);
Session["count"] = 0;
}
else
{
EmployeeBO ebo = (EmployeeBO)Session["employee"];
datatbl = (DataTable)Session["createPO"];
purchaseOrderBL = new PurchaseOrderBL();
PurchaseOrderBO poLastValue = new PurchaseOrderBO();
PurchaseOrderBO pobo = new PurchaseOrderBO();
poLastValue = purchaseOrderBL.countTotalPO();
string idSeperator = poLastValue.PoId.ToString().Substring(2);//gets the last PurchaseOrder ID from database
int valuePod = Convert.ToInt32(idSeperator);
if (valuePod < 100)
{
valuePod = valuePod + 1;
poCountStr = "PO0" + valuePod;
}
else
{
valuePod = valuePod + 1;
poCountStr = "PO" + valuePod;
}
pobo.PoId = poCountStr;
string date = tbDeliveryDate.Text;
DateTime dt = DateTime.Parse(tbDeliveryDate.Text);
pobo.DeliveryDate = dt;
pobo.DateOfOrder = DateTime.Today;
string eId = ebo.EmployeeId;
pobo.RequestorId = eId;
pobo.CommentByClerk = Request.Form["tbClerkComments"];
EmployeeBO empBo = purchaseOrderBL.getSupervisorId();//get supervisor ID of the logged in employee
pobo.ApproverId = empBo.EmployeeId;
pobo.Status = "Pending";
Boolean flagPO = purchaseOrderBL.createPurchaseOrder(pobo);
Boolean flagPOD = false;
foreach (DataRow dr in datatbl.Rows)
{
PurchaseOrderDetailsBO pod = new PurchaseOrderDetailsBO();
pod.PoId = poCountStr;
PurchaseOrderDetailsBO podLastValue = new PurchaseOrderDetailsBO();
podLastValue = purchaseOrderBL.countTotalPODId();
string idSeperate = podLastValue.PoDetailsId.ToString().Substring(2);//gets the last PurchaseOrderDetails ID from database
int valuePoId = Convert.ToInt32(idSeperate);
if (valuePoId < 100)
{
valuePoId = valuePoId + 1;
podIdCountStr = "PD0" + valuePoId;
}
else
{
valuePoId = valuePoId + 1;
podIdCountStr = "PD" + valuePoId;
}
pod.PoDetailsId = podIdCountStr;
pod.SupplierId = ddlSupplier.SelectedItem.Text;
string itemName = purchaseOrderBL.getItemNumberByName(dr["ItemName"].ToString());
pod.ItemNumber = itemName;
pod.Quantity = Convert.ToInt32(dr["Quantity"]);
flagPOD = purchaseOrderBL.createPurchaseOrderDetails(pod);
}
if (flagPO && flagPOD)//checks if both PurchaseOrder and PurchaseOrderDetails are updated to database. if so, send an email to the supervisor
{
SendEmailSubmit(poCountStr);
}
else
{
string script = "alert('There is some issue in sending email. We apologize for this!');";
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
}
Response.Redirect("~/Store/POList.aspx");
}
}
