public RequisitionDetail convertRequisitionDetailsBO(RequisitionDetailsBO rdbo)
        {
            RequisitionDetail rd = new RequisitionDetail();

            rd.RequisitionID        = rdbo.RequisitionId;
            rd.RequisitionDetailsID = rdbo.RequisitionDetailsId;
            rd.ItemNumber           = rdbo.ItemNumber;
            rd.ItemQuantity         = rdbo.ItemQuantity;
            return(rd);
        }
Example #2
0
        protected void BtbSubmit_Click(object sender, EventArgs e)
        {
            dt = (DataTable)Session["AddRequisitionTable"];
            if (dt.Rows.Count == 0)
            {
                LabelSubmit.Text = "Please add item first.";
            }
            else
            {
                LabelSubmit.Text = "";
                RequisitionBO rbo = new RequisitionBO();
                EmployeeBO    ebo = (EmployeeBO)Session["employee"];
                dt = (DataTable)Session["AddRequisitionTable"];

                string requisitionId = crbl.createRequisitionId();
                rbo.RequisitionId      = requisitionId;
                rbo.EmpId              = ebo.EmployeeId;
                rbo.CommentsByEmp      = Request.Form["tbEmployeeComments"];
                rbo.Status             = "Pending";
                rbo.EmpRequisitionDate = DateTime.Today;
                crbl.submitRequisition(rbo);

                string sub  = "New Requisition";
                string name = crbl.getHeadNameByDepId(ebo.Department.DeptId);
                string body = "Dear " + name + ", \n"
                              + "\n" + "I have made a new requisition for those items below: " + "\n";

                string bodyForOutOfStock = "Dear clerk, \n\n";

                foreach (DataRow dr in dt.Rows)
                {
                    RequisitionDetailsBO rdbo = new RequisitionDetailsBO();
                    rdbo.RequisitionId        = requisitionId;
                    rdbo.RequisitionDetailsId = crbl.createRequisitionDetailsId();

                    string itemNumber = crbl.getItemNumberByItemName(dr["updateItemName"].ToString());
                    rdbo.ItemNumber = itemNumber;

                    int itemQuantity = Convert.ToInt32(dr["updateQuantity"].ToString());
                    rdbo.ItemQuantity = itemQuantity;

                    if (checkReorderLevel(itemNumber, itemQuantity) == false)
                    {
                        bodyForOutOfStock += "The item: " + dr["updateItemName"].ToString() + " is reaching the reorder level, Please place orders.\n";

                        Label1.Text += bodyForOutOfStock + "  " + itemNumber + " " + itemQuantity + "  " + checkReorderLevel(itemNumber, itemQuantity).ToString();
                    }

                    crbl.submitRequisitionDetails(rdbo);
                    body += "Item Name: " + dr["updateItemName"].ToString() + ":\t Quantity: " + dr["updateQuantity"].ToString() + "\n";
                }

                body += "\n\n" + "Regards," + "\n" + ebo.EmployeeName;

                SendEmail sendEmail = new SendEmail();
                sendEmail.sendCPEmail(sub, body, crbl.getHeadEmailByDepId(ebo.Department.DeptId));

                if (bodyForOutOfStock != "Dear clerk, \n\n")
                {
                    string subject = "items out of stock";
                    foreach (string email in crbl.getAllClerksEmail())
                    {
                        sendEmail.sendCPEmail(subject, bodyForOutOfStock, email);
                    }
                }
                Response.Redirect("~/Department/RequisitionList.aspx");
            }
        }
 public void submitRequisitionDetails(RequisitionDetailsBO rdbo)
 {
     crda.submitRequisitionDetails(convertRequisitionDetailsBO(rdbo));
 }