protected void btnReject_Click(object sender, EventArgs e)
{
purchaseOrderBL = new PurchaseOrderBL();
poId = Request.QueryString["poId"];
string status = "Rejected";
string supervisorComment = tbSupervisorComments.Text;
EmployeeBO ebo = (EmployeeBO)Session["employee"];
string approverId = ebo.EmployeeId;
Boolean flag = purchaseOrderBL.updateStatusByPoId(poId, status, supervisorComment, approverId);
int value = 2;
if (flag)
{
SendEmailApproveReject(poId, value);
}
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");
gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderListAll();
gvPurchaseOrderList.DataBind();
footableSettings();
}
protected void btnResubmit_Click(object sender, EventArgs e)
{
purchaseOrderBL = new PurchaseOrderBL();
poId = Request.QueryString["poId"];
string clerkComment = tbClerkComments.Text;
EmployeeBO ebo = (EmployeeBO)Session["employee"];
string empId = ebo.EmployeeId;
Boolean flag = purchaseOrderBL.resubmitPO(poId, clerkComment);
if (flag)
{
SendEmailResubmit(poId);
}
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");
gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderList(empId);
gvPurchaseOrderList.DataBind();
footableSettings();
}
int IPurchaseOrderRepository.AddUpdateOrder(PurchaseOrderForm quotationData)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
int i = poBL.AddUpdateOrder(quotationData);
return(i);
}
protected void gvPurchaseOrderList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
GridViewRow row = gvPurchaseOrderList.Rows[e.RowIndex];
poId = Request.QueryString["poId"];
string supplier = (row.FindControl("lblSupplier") as Label).Text;
purchaseOrderBL = new PurchaseOrderBL();
if (confirmValue == "Yes")
{
int id = purchaseOrderBL.deletePurchaseOrderDetails(poId, supplier);
if (id == 1)
{
Response.Redirect("~/Store/POList.aspx");
}
else
{
gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderDetailsList(poId);
gvPurchaseOrderList.EditIndex = -1;
gvPurchaseOrderList.DataBind();
footableSettings();
}
}
else
{
gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderDetailsList(poId);
gvPurchaseOrderList.EditIndex = -1;
gvPurchaseOrderList.DataBind();
footableSettings();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Session["count"] = 1;
AddNewRecordRowToGrid();
string supplierName = (String)Session["ddlValue"];
purchaseOrderBL = new PurchaseOrderBL();
List <InventoryStockBO> list = purchaseOrderBL.getCategoryBySupplier(supplierName);
List <String> l1 = purchaseOrderBL.getCategoryList(list);
HashSet <String> hs = new HashSet <string>(l1);
ddlCategory.DataSource = hs;
ddlCategory.DataBind();
ListItem liCategory = new ListItem("Select Category", "-1");
ddlCategory.Items.Insert(0, liCategory);
ddlCategory.SelectedIndex = 0;
ddlItemName.Enabled = false;
ddlItemName.SelectedIndex = 0;
ddlSupplier.Enabled = false;
ddlSupplier.SelectedItem.Text = (String)Session["ddlValue"];
tbUOM.Text = "";
tbPrice.Text = "";
tbQuantity.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
int count = Convert.ToInt32(Session["count"]);
if (!IsPostBack)
{
Page.DataBind();
purchaseOrderBL = new PurchaseOrderBL();
ddlCategory.DataSource = purchaseOrderBL.getCategoryList();
ddlCategory.DataBind();
ListItem liCategory = new ListItem("Select Category", "-1");
ddlCategory.Items.Insert(0, liCategory);
ListItem liItemName = new ListItem("Select Item Name", "-1");
ddlItemName.Items.Insert(0, liItemName);
ListItem liSupplier = new ListItem("Select Supplier", "-1");
ddlSupplier.Items.Insert(0, liSupplier);
ddlItemName.Enabled = false;
ddlSupplier.Enabled = false;
AddDefaultFirstRecord();
}
}
public void doProcess()
{
if (Session["employee"] != null)
{
EmployeeBO ebo = (EmployeeBO)Session["employee"];
string title = ebo.EmployeeTitle;
int delegateValue = ebo.Delegate;
poId = Request.QueryString["poId"];
lblPOID.Text = poId;
lblName.Text = ebo.EmployeeName;
purchaseOrderBL = new PurchaseOrderBL();
PurchaseOrderBO pbo = purchaseOrderBL.getStatusAndOrderDateDetails(poId);
lblOrderDate.Text = String.Format("{0:dd/MMM/yyyy}", pbo.DateOfOrder);
lblStatus.Text = pbo.Status;
tbClerkComments.Text = pbo.CommentByClerk;
tbSupervisorComments.Text = pbo.CommentBySupervisor;
if (title.Equals("Supervisor") && (lblStatus.Text.Equals("Pending")))
{
btnResubmit.Visible = false;
this.gvPurchaseOrderList.Columns[7].Visible = false;
tbClerkComments.Enabled = false;
}
else if (title.Equals("Manager") && (lblStatus.Text.Equals("Pending")) && delegateValue == 1)
{
btnResubmit.Visible = false;
this.gvPurchaseOrderList.Columns[7].Visible = false;
tbClerkComments.Enabled = false;
}
else if (title.Equals("Clerk") && lblStatus.Text.Equals("Pending"))
{
btnResubmit.Enabled = true;
tbSupervisorComments.Enabled = false;
this.gvPurchaseOrderList.Columns[7].Visible = true;
btnApprove.Visible = false;
btnReject.Visible = false;
}
else
{
this.gvPurchaseOrderList.Columns[7].Visible = false;
tbClerkComments.Enabled = false;
tbSupervisorComments.Enabled = false;
btnResubmit.Visible = false;
btnApprove.Visible = false;
btnReject.Visible = false;
}
List <PurchaseOrderDetailsJoinBO> poDetailList = purchaseOrderBL.getPurchaseOrderDetailsList(poId);
if (poDetailList.Count != 0)
{
gvPurchaseOrderList.DataSource = poDetailList;
gvPurchaseOrderList.DataBind();
footableSettings();
}
}
else
{
Console.WriteLine("Something is wrong!!!!!!");
}
}
public void SendEmailApproveReject(string poId, int value)
{
purchaseOrderBL = new PurchaseOrderBL();
PurchaseOrderBO po = purchaseOrderBL.getStatusAndOrderDateDetails(poId);
string requestorId = po.RequestorId;
EmployeeBO emp = purchaseOrderBL.getRequestorName(requestorId);
SendEmail se = new SendEmail();
string subject = "";
string body = "";
if (value == 1)
{
subject = "Purchase Order Approved";
body = "Dear " + emp.EmployeeName + ", \n"
+ "\n" + "The Purchase Order with ID: " + poId + " requested by you has been approved."
+ "\n" + "(This is an auto-generated email, please do not reply.)"
+ "\n\n\n" + "Regards,"
+ "\n" + "Admin";
}
else
{
subject = "Purchase Order Rejected";
body = "Dear " + emp.EmployeeName + ", \n"
+ "\n" + "The Purchase Order with ID: " + poId + " requested by you has been rejected. Please contact your supervisor for further information"
+ "\n" + "(This is an auto-generated email, please do not reply.)"
+ "\n\n\n" + "Regards,"
+ "\n" + "Admin";
}
se.sendCPEmail(subject, body, emp.EmployeeEmail);
}
protected void ddlItemName_SelectedIndexChanged(object sender, EventArgs e)
{
int count = Convert.ToInt32(Session["count"]);
if (ddlItemName.SelectedIndex == 0 && count == 0)
{
ddlSupplier.Enabled = false;
ddlSupplier.SelectedIndex = 0;
tbUOM.Text = "";
tbPrice.Text = "";
tbQuantity.Text = "";
}
else if (ddlItemName.SelectedIndex != 0 && count > 0)
{
purchaseOrderBL = new PurchaseOrderBL();
string itemName = ddlItemName.SelectedItem.Text;
InventoryStockBO ins = new InventoryStockBO();
ins = purchaseOrderBL.getUOMByItem(itemName);
tbUOM.Text = ins.ItemUOM.ToString();
ddlSupplier.Enabled = false;
string supplier = (String)Session["ddlValue"];
ddlSupplier.SelectedItem.Text = supplier;
PurchaseOrderDetailsJoinBO pod = new PurchaseOrderDetailsJoinBO();
pod = purchaseOrderBL.getPriceBySupplier(itemName, supplier);
tbPrice.Text = pod.Price.ToString();
tbQuantity.Text = "";
}
else
{
purchaseOrderBL = new PurchaseOrderBL();
string itemName = ddlItemName.SelectedItem.Text;
InventoryStockBO ins = new InventoryStockBO();
ins = purchaseOrderBL.getUOMByItem(itemName);
tbUOM.Text = ins.ItemUOM.ToString();
ddlSupplier.Enabled = true;
List <String> supplierList = new List <string>();
InventoryStockBO bo = new InventoryStockBO();
bo = purchaseOrderBL.getSupplierByItem(itemName);
supplierList.Add(bo.Supplier1);
supplierList.Add(bo.Supplier2);
supplierList.Add(bo.Supplier3);
ddlSupplier.DataSource = supplierList;
ddlSupplier.DataBind();
ListItem liSupplier = new ListItem("Select Supplier", "-1");
ddlSupplier.Items.Insert(0, liSupplier);
tbPrice.Text = "";
tbQuantity.Text = "";
}
}
protected void ddlSupplier_SelectedIndexChanged(object sender, EventArgs e)
{
int count = Convert.ToInt32(Session["count"]);
purchaseOrderBL = new PurchaseOrderBL();
PurchaseOrderDetailsJoinBO ins = new PurchaseOrderDetailsJoinBO();
string itemName = ddlItemName.SelectedItem.Text;
string supplier = ddlSupplier.SelectedItem.Text;
ins = purchaseOrderBL.getPriceBySupplier(itemName, supplier);
tbPrice.Text = ins.Price.ToString();
Session["ddlValue"] = ddlSupplier.SelectedItem.Text;
}
protected void gvPurchaseOrderList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = gvPurchaseOrderList.Rows[e.RowIndex];
poId = Request.QueryString["poId"];
string itemNumber = (row.FindControl("lblItemNumber") as Label).Text;
string quantity = (row.FindControl("txtQuantity") as TextBox).Text;
int quan = Convert.ToInt32(quantity);
purchaseOrderBL = new PurchaseOrderBL();
purchaseOrderBL.updateQuantity(poId, quan, itemNumber);
gvPurchaseOrderList.DataSource = purchaseOrderBL.getPurchaseOrderDetailsList(poId);
gvPurchaseOrderList.EditIndex = -1;
gvPurchaseOrderList.DataBind();
footableSettings();
}
public void doProcess()
{
if (Session["employee"] != null)
{
EmployeeBO ebo = (EmployeeBO)Session["employee"];
string empId = ebo.EmployeeId;
string title = ebo.EmployeeTitle;
purchaseOrderBL = new PurchaseOrderBL();
if (title.Equals("Manager") || title.Equals("Supervisor"))
{
List <PurchaseOrderBO> polst = purchaseOrderBL.getPurchaseOrderListAll();
if (polst.Count != 0)
{
gvPurchaseOrderList.DataSource = polst;
gvPurchaseOrderList.DataBind();
footableSettings();
}
else
{
lblNoPOList.Text = "No Purchase Order List";
}
}
else
{
List <PurchaseOrderBO> polst = purchaseOrderBL.getPurchaseOrderList(empId);
gvPurchaseOrderList.DataSource = polst;
gvPurchaseOrderList.DataBind();
if (polst.Count != 0)
{
gvPurchaseOrderList.DataSource = polst;
gvPurchaseOrderList.DataBind();
footableSettings();
}
else
{
lblNoPOList.Text = "No Purchase Order List";
}
}
}
else
{
Console.WriteLine("Something is wrong!!!!!!");
}
}
/// <summary>
/// Gets all purchase orders.
/// </summary>
/// <returns>Get All Purchase Orders</returns>
public IEnumerable <PurchaseOrderEntity> GetAllPurchaseOrders()
{
IList <PurchaseOrderEntity> result = new List <PurchaseOrderEntity>();
IPurchaseOrderBL purchaseOrderBL = new PurchaseOrderBL();
List <PurchaseOrder> purchaseOrderList = purchaseOrderBL.GetAllPurchaseOrder();
foreach (PurchaseOrder source in purchaseOrderList)
{
PurchaseOrderEntity target = new PurchaseOrderEntity();
target.PurchaseOrderID = source.PurchaseOrderID;
target.Vendor = source.Vendor;
target.TotalPurchase = source.Total_Purchase;
target.AveragePurchase = source.Average_Purchase;
target.MinimumPurchase = source.Minimum_Purchase;
target.MaximumPurchase = source.Maximum_Purchase;
result.Add(target);
}
return(result);
}
public PurchaseOrderForm GetPrintPurchaseOrder(string piNo)
{
IPurchaseOrderBL piBL = new PurchaseOrderBL();
return(piBL.GetPrintPurchaseOrder(piNo));
}
public string GetCategoryContent(string catType)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.GetCategoryContent(catType));
}
//public int ConvertToPurchaseOrder(PurchaseOrderForm poForm)
//{
// IPurchaseOrderBL poBL = new PurchaseOrderBL();
// return poBL.ConvertToPurchaseOrder(poForm);
//}
public int ConvertToPurchaseInvoice(PurchaseOrderForm quotationData)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.ConvertToPurchaseInvoice(quotationData));
}
public int UpdationOrder(PurchaseOrderForm quotationData)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.UpdationOrder(quotationData));
}
public PurchaseOrderForm GetPurchaseOrder(string poNo)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.GetPurchaseOrder(poNo));
}
public bool CanDeleteOrder(int poID)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.CanDeleteOrder(poID));
}
public bool DeleteOrder(int purchaseQuotID)
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.DeleteOrder(purchaseQuotID));
}
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");
}
}
public int GetLatestOrderNo()
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.GetLatestOrderNo());
}
public List <PurchaseOrderEntity> GetAllPurchaseOrders()
{
IPurchaseOrderBL poBL = new PurchaseOrderBL();
return(poBL.GetAllPurchaseOrders());
}
protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
{
int count = Convert.ToInt32(Session["count"]);
if (ddlCategory.SelectedIndex == 0 && count == 0)
{
ddlItemName.Enabled = false;
ddlItemName.SelectedIndex = 0;
ddlSupplier.Enabled = false;
ddlSupplier.SelectedIndex = 0;
tbUOM.Text = "";
tbPrice.Text = "";
tbQuantity.Text = "";
}
else if (ddlCategory.SelectedIndex == 0 && count > 0)
{
ddlItemName.Enabled = false;
ddlItemName.SelectedIndex = 0;
ddlSupplier.Enabled = false;
ddlSupplier.SelectedItem.Text = (String)Session["ddlValue"];
tbUOM.Text = "";
tbPrice.Text = "";
tbQuantity.Text = "";
}
else if (ddlCategory.SelectedIndex != 0 && count > 0)
{
ddlItemName.Enabled = true;
purchaseOrderBL = new PurchaseOrderBL();
string category = ddlCategory.SelectedItem.Text;
string supplier = (String)Session["ddlValue"];
List <InventoryStockBO> list = purchaseOrderBL.getItemListByCategoryAndSupplier(category, supplier);
List <String> l1 = purchaseOrderBL.getItemNameList(list);
ddlItemName.DataSource = l1;
ddlItemName.DataBind();
ListItem liItemName = new ListItem("Select Item Name", "-1");
ddlItemName.Items.Insert(0, liItemName);
ddlSupplier.Enabled = false;
ddlSupplier.SelectedItem.Text = (String)Session["ddlValue"];
tbUOM.Text = "";
tbPrice.Text = "";
tbQuantity.Text = "";
}
else
{
ddlItemName.Enabled = true;
purchaseOrderBL = new PurchaseOrderBL();
string category = ddlCategory.SelectedItem.Text;
List <InventoryStockBO> list = purchaseOrderBL.getItemListByCategory(category);
List <String> l1 = purchaseOrderBL.getItemNameList(list);
ddlItemName.DataSource = l1;
ddlItemName.DataBind();
ListItem liItemName = new ListItem("Select Item Name", "-1");
ddlItemName.Items.Insert(0, liItemName);
ddlSupplier.SelectedIndex = 0;
ddlSupplier.Enabled = false;
tbUOM.Text = "";
tbPrice.Text = "";
tbQuantity.Text = "";
}
}
