public void DeleteRequisitionDetail(StaffRequisition requisition)
{
StaffRequisition oldRequisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId == requisition.StaffRequisitionId).FirstOrDefault();
context.StaffRequisitions.Remove(oldRequisition);
context.SaveChanges();
}
public List <RequisitionDetail> GetRequisitionDetails(string requisitionId)
{
StaffRequisition requisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId == requisitionId && x.Status == "Pending" || x.Status == "Reject").FirstOrDefault();
List <RequisitionDetail> requisitionDetailList = requisition.RequisitionDetails.ToList <RequisitionDetail>();
return(requisitionDetailList);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
StaffRequisition requisition = new StaffRequisition();
List <RequisitionDetail> requisitiondetails = new List <RequisitionDetail>();
requisition.StaffRequisitionId = lblRequisition.Text;
requisition.DepartmentId = user.DepartmentId;
requisition.StaffId = user.StaffId;
requisition.CreateDate = Convert.ToDateTime(lblDate.Text);
requisition.Status = "Pending";
foreach (GridViewRow row in gv_Items.Rows)
{
RequisitionDetail details = new RequisitionDetail();
details.StaffReqisitionId = lblRequisition.Text;
details.ItemId = gv_Items.DataKeys[row.RowIndex].Value.ToString();
details.Quantity = Convert.ToInt32(row.Cells[3].Text);
requisitiondetails.Add(details);
}
viewStationeryRequisitionController.saveDataToRequisition(requisition, requisitiondetails);
dt = null;
gv_Items.DataSource = dt;
gv_Items.DataBind();
btnSubmit.CssClass = "btn btn-success disabled";
btnSubmit.Attributes.Add("disabled", "disabled");
btnSubmit.Text = "Sent";
txtQuantity.Text = "";
lblUOM.Text = "";
BindDropDownList();
SendMailToDepartmentHead();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage",
"alert('Submit successfully') ;window.location = '" + "ViewStationaryRequisitionList.aspx';", true);
}
public void RejectRequisitionList(string staffReqId, string remark)
{
StaffRequisition staffRequisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId.Equals(staffReqId)).FirstOrDefault();
staffRequisition.Status = StatusType.Reject.ToString();
staffRequisition.Remark = remark;
context.SaveChanges();
}
public void ApproveRequisitionList(string staffReqId, List <RequisitionDetail> requisitionDetailList, string remark, string staffId)
{
StaffRequisition staffRequisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId.Equals(staffReqId)).FirstOrDefault();
string depReqId = GenerateDepartmentRequisitionId(staffRequisition.DepartmentId);
if (staffRequisition != null)
{
staffRequisition.DepartmentRequisitionId = depReqId;
staffRequisition.Status = StatusType.Approved.ToString();
staffRequisition.ApproveBy = staffId;
staffRequisition.ApproveDate = Convert.ToDateTime(DateTime.Now.ToString());
staffRequisition.Remark = remark;
context.SaveChanges();
}
foreach (RequisitionDetail req in requisitionDetailList)
{
DepartmentRequisition depRequisition = context.DepartmentRequisitions.Where(x => x.DepartmentId.Equals(staffRequisition.DepartmentId) && x.ItemId.Equals(req.ItemId) && x.Status.Equals(StatusType.Pending.ToString())).FirstOrDefault();
if (depRequisition != null)
{
depRequisition.Needed += req.Quantity;
context.SaveChanges();
}
else
{
DepartmentRequisition departmentReq = new DepartmentRequisition();
departmentReq.DepartmentRequisitionId = depReqId;
departmentReq.DepartmentId = staffRequisition.DepartmentId;
departmentReq.ItemId = req.ItemId;
departmentReq.Needed = req.Quantity;
departmentReq.Actual = 0;
departmentReq.Status = StatusType.Approved.ToString();
departmentReq.Remark = remark;
departmentReq.CreateDate = DateTime.Now;
context.DepartmentRequisitions.Add(departmentReq);
context.SaveChanges();
}
}
}
public void saveDataToRequisition(StaffRequisition requisition, List <RequisitionDetail> requisitiondetails)
{
context.StaffRequisitions.Add(requisition);
context.SaveChanges();
foreach (RequisitionDetail req in requisitiondetails)
{
RequisitionDetail reqDetail = context.RequisitionDetails.Where(x => x.StaffReqisitionId.Equals(req.StaffReqisitionId) && x.ItemId.Equals(req.ItemId)).FirstOrDefault();
if (reqDetail != null)
{
reqDetail.Quantity += req.Quantity;
context.SaveChanges();
}
else
{
RequisitionDetail d = new RequisitionDetail();
d.StaffReqisitionId = req.StaffReqisitionId;
d.ItemId = req.ItemId;
d.Quantity = req.Quantity;
context.RequisitionDetails.Add(d);
context.SaveChanges();
}
}
}
public void RemoveRequisitionDetail(StaffRequisition requisition)
{
viewStationaryRequisitionDAOImpl.DeleteRequisitionDetail(requisition);
}
public void saveDataToRequisition(StaffRequisition requisition, List <RequisitionDetail> requisitiondetails)
{
viewStationaryRequisitionDAOImpl.saveDataToRequisition(requisition, requisitiondetails);
}
