protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string requisitionid = (string)Session["requisitiondetail"];
int reqid = Convert.ToInt32(requisitionid);
Requisition req = RayBizLogic.GetRequisitionById(requisitionid);
var qry = from r in context.RequisitionDetails where r.RequisitionID == reqid select new { r.ItemCode, r.Catalogue.Description, r.QuantityRequested, r.QuantityRetrieved };
dgvRequisitionDetail.DataSource = qry.ToList();
dgvRequisitionDetail.DataBind();
dgvRequisitionDetail.AllowPaging = true;
Model.Employee emp = context.Employees.Where(x => x.EmployeeID == req.RequestorID).First();
Model.Department dept = context.Departments.Where(x => x.DepartmentCode == emp.DepartmentCode).First();
ReqIDTextBox.Text = req.RequisitionID.ToString();
StatusTextBox.Text = req.Status;
DeptNameTextBox.Text = dept.DepartmentName;
DeptCodeTextBox.Text = dept.DepartmentCode;
NameTextBox.Text = emp.Name;
EmployeePhoneTextBox.Text = emp.Phone.ToString();
EmailTextBox.Text = emp.Email;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string id = (string)Session["AdjustVoucherId"];
int adjId = Convert.ToInt32(id);
int storestaffid = (int)Session["clerkid"];
StoreStaff staff = RayBizLogic.GetStoreStaffById(storestaffid);
dgvVoucherDetail.DataSource = RayBizLogic.AdjustmentVoucherDetailList(adjId);
dgvVoucherDetail.DataBind();
StockAdjustmentVoucher voucher = context.StockAdjustmentVouchers.Where(v => v.VoucherID == adjId).First();
VouchderIdBox.Text = voucher.VoucherID.ToString();
DateTextBox.Text = voucher.DateIssue.ToString();
GenByTextBox.Text = voucher.StoreStaff.Name;
if (staff.Title == "Supervisor" && voucher.Status == "Pending" && RayBizLogic.AdjustmentVoucherCost(adjId) <= 250)
{
AcknowledgeButton.Visible = true;
}
else if (staff.Title == "Manager" && voucher.Status == "Pending" && RayBizLogic.AdjustmentVoucherCost(adjId) > 250)
{
AcknowledgeButton.Visible = true;
}
}
}
protected void CancelButton_Click(object sender, EventArgs e)
{
Team10ADModel context = new Team10ADModel();
string requisitionid = (string)Session["requisitiondetail"];
int reqid = Convert.ToInt32(requisitionid);
RayBizLogic.CancelRequisition(reqid);
Response.Redirect("RequisitionDetailsPage.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dgvRetList.DataSource = RayBizLogic.RetrievalListForGV();
dgvRetList.DataBind();
dgvRetList.AllowPaging = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dgvAdjVoucher.DataSource = RayBizLogic.AdjustmentVoucherList();
dgvAdjVoucher.DataBind();
dgvAdjVoucher.AllowPaging = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dgvCatalogue.DataSource = RayBizLogic.CatalogueList();
dgvCatalogue.DataBind();
dgvCatalogue.AllowPaging = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int needAdjustment = (int)Session["AdjustVoucherId"];
//int needAdjustment = 1000002;
dgvCreateAdj.DataSource = RayBizLogic.AdjustmentVoucherDetailForGV(needAdjustment);
dgvCreateAdj.DataBind();
dgvCreateAdj.AllowPaging = true;
}
}
protected void dgvCatalogue_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
dgvCatalogue.PageIndex = e.NewPageIndex;
if (SearchBox.Text == "")
{
dgvCatalogue.DataSource = RayBizLogic.CatalogueList();
}
else
{
dgvCatalogue.DataSource = RayBizLogic.SearchCatalogue(SearchBox.Text);
}
dgvCatalogue.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string id = (string)Session["retrievaldetail"];
int retrievalid = Convert.ToInt32(id);
Retrieval ret = RayBizLogic.GetRetrievalById(retrievalid);
int currentClerkId = (int)Session["clerkid"];
var qry = from r in context.RetrievalDetails where r.RetrievalID == retrievalid select new { r.ItemCode, r.Catalogue.Description, r.RequestedQuantity, r.RetrievedQuantity };
dgvRetrievalDetail.DataSource = qry.ToList();
dgvRetrievalDetail.DataBind();
RetIDTextBox.Text = ret.RetrievalID.ToString();
StatusTextBox.Text = ret.Status;
}
}
protected void dgvReqStatus_RowCommand(object sender, GridViewCommandEventArgs e)
{
//To be coded.
if (e.CommandName == "Details")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow = dgvReqStatus.Rows[index];
Session["requisitiondetail"] = selectedRow.Cells[0].Text;
Response.Redirect("RequisitionDetailsPage.aspx");
}
if (e.CommandName == "CancelRequisition")
{
GridViewRow selectedRow = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
int reqid = Convert.ToInt32(selectedRow.Cells[0].Text);
RayBizLogic.CancelRequisition(reqid);
Response.Redirect("RequisitionStatus.aspx");
}
}
protected void GenRetListButton_Click(object sender, EventArgs e)
{
//For collecting all requisitiondetails into 1 list
List <RequisitionDetail> rd = new List <RequisitionDetail>();
//For collecting all the requisition into 1 list
ArrayList reqIdList = new ArrayList();
List <Requisition> reqlist = new List <Requisition>();
//For checking that at least 1 record was selected for retrieval list generation
int checkselection = 0;
foreach (GridViewRow row in dgvReqList.Rows)
{
CheckBox chk = (CheckBox)row.FindControl("selectchk");
if (chk != null && chk.Checked)
{
int reqid = Convert.ToInt32(row.Cells[1].Text);
reqIdList.Add(reqid);
reqlist = RayBizLogic.CombineReq(reqIdList);
List <RequisitionDetail> templist = RayBizLogic.CombineReqDetail(reqid);
foreach (RequisitionDetail r in templist)
{
rd.Add(r);
}
checkselection++;
}
}
int clerkid = (int)Session["clerkid"];
if (checkselection > 0)
{
RayBizLogic.GenerateRetrievalList(rd, reqlist, clerkid);
}
//Set selected requisition status to "Processing"
RayBizLogic.ReqStatusProcessing(reqIdList);
Response.Redirect("RetrievalList.aspx");
}
protected void GenDisbursementList_Click(object sender, EventArgs e)
{
Team10ADModel context = new Team10ADModel();
List <RetrievalDetail> suggested = (List <RetrievalDetail>)Session["SuggestedRetrievalDetail"];
int clerkid = (int)Session["clerkid"];
string id = (string)Session["retrievaldetail"];
int retrievalid = Convert.ToInt32(id);
List <RetrievalDetail> userinput = RayBizLogic.GetRetrievalList(retrievalid);
foreach (RetrievalDetail r in userinput)
{
foreach (GridViewRow row in dgvRetrievalDetail.Rows)
{
TextBox retrieveqtybox = (TextBox)row.FindControl("RetrieveQty");
if (r.ItemCode == row.Cells[0].Text)
{
r.RetrievedQuantity = Convert.ToInt32(retrieveqtybox.Text);
}
}
}
//Check for adjustment voucher needs
int adjustmentVoucherId = RayBizLogic.GenerateAdjustmentVoucherDetails(suggested, userinput, clerkid);
//Update retrieval and catalogue
//Generate disbursement lists
//Update requisition qty
//Update requisition status
RayBizLogic.UpdateRetrievalDetailsFull(retrievalid, userinput, clerkid);
if (adjustmentVoucherId > 0)
{
Session["AdjustVoucherId"] = adjustmentVoucherId;
Response.Redirect("CreateAdjustmentVoucher.aspx");
}
else
{
Response.Redirect("DisbursementList.aspx");
}
}
protected void dgvRetList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Details")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow = dgvRetList.Rows[index];
Session["retrievaldetail"] = selectedRow.Cells[0].Text;
int id = Convert.ToInt32(selectedRow.Cells[0].Text);
Retrieval ret = RayBizLogic.GetRetrievalById(id);
if (ret.Status == "Retrieved")
{
Response.Redirect("CompletedRetrievalDetailPage.aspx");
}
else
{
Response.Redirect("RetrievalDetailPage.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string id = (string)Session["retrievaldetail"];
int retrievalid = Convert.ToInt32(id);
Retrieval ret = RayBizLogic.GetRetrievalById(retrievalid);
int currentClerkId = (int)Session["clerkid"];
//Safety catch. Incase user click back and click generate again
if (ret.Status == "Retrieved")
{
GenDisbursementList.Visible = false;
}
var qry = from r in context.RetrievalDetails where r.RetrievalID == retrievalid select new { r.ItemCode, r.Catalogue.Description, r.Catalogue.BalanceQuantity, r.RequestedQuantity };
dgvRetrievalDetail.DataSource = qry.ToList();
dgvRetrievalDetail.DataBind();
RetIDTextBox.Text = ret.RetrievalID.ToString();
StatusTextBox.Text = ret.Status;
//Saving the suggested retrieval details before user make any changes
List <RetrievalDetail> suggested = RayBizLogic.GetRetrievalList(retrievalid);
foreach (RetrievalDetail r in suggested)
{
foreach (GridViewRow row in dgvRetrievalDetail.Rows)
{
TextBox retrieveqtybox = (TextBox)row.FindControl("RetrieveQty");
if (r.ItemCode == row.Cells[0].Text)
{
r.RetrievedQuantity = Convert.ToInt32(retrieveqtybox.Text);
}
}
}
Session["SuggestedRetrievalDetail"] = suggested;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string requisitionid = (string)Session["requisitiondetail"];
reqid = Convert.ToInt32(requisitionid);
Requisition req = RayBizLogic.GetRequisitionById(requisitionid);
int currentEmpId = (int)Session["employeeid"];
//int currentEmpId = 104;
int approverID = (int)Session["ApproverID"];
if (currentEmpId == req.RequestorID && req.Status == "Pending")
{
CancelButton.Visible = true;
}
else if (currentEmpId == approverID && req.Status == "Pending")
{
btnApprove.Visible = true;
btnReject.Visible = true;
lblRemarks.Visible = true;
txtBoxRemarks.Visible = true;
txtBoxRemarks.ReadOnly = false;
}
//if currentEmId = approverId, approve and reject buttons will show
var qry = from r in context.RequisitionDetails where r.RequisitionID == reqid select new { r.Catalogue.ItemCode, r.Catalogue.Description, r.QuantityRequested, r.Catalogue.UnitOfMeasure };
dgvRequisitionDetail.DataSource = qry.ToList();
dgvRequisitionDetail.DataBind();
dgvRequisitionDetail.AllowPaging = true;
Model.Employee emp = context.Employees.Where(x => x.EmployeeID == req.RequestorID).First();
NameTextBox.Text = emp.Name;
StatusTextBox.Text = req.Status;
txtBoxRemarks.Text = req.Remarks;
}
}
protected void dgvRetList_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
dgvRetList.PageIndex = e.NewPageIndex;
dgvRetList.DataSource = RayBizLogic.RetrievalListForGV();
dgvRetList.DataBind();
}
protected void SearchBtn_Click(object sender, EventArgs e)
{
dgvCatalogue.DataSource = RayBizLogic.SearchCatalogue(SearchBox.Text);
dgvCatalogue.DataBind();
dgvCatalogue.AllowPaging = true;
}
protected void dgvAdjVoucher_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
dgvAdjVoucher.PageIndex = e.NewPageIndex;
dgvAdjVoucher.DataSource = RayBizLogic.AdjustmentVoucherList();
dgvAdjVoucher.DataBind();
}
