public static int Add_Voucher_Request(Voucher_Request voucher_request)
{
ssisEntities.Voucher_Request.Add(voucher_request);
int result = ssisEntities.SaveChanges();
return(result);
}
protected void Voucher_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Approve")
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
HiddenField itemNumerHdden = (HiddenField)GridVoucherRequest.Rows[rowIndex].FindControl("LblVoucherId");
int voucherId = Convert.ToInt32(itemNumerHdden.Value);
Voucher_Request voucher_request = ssisEntities.Voucher_Request.Where(x => x.Voucher_ID == voucherId).First();
voucher_request.Status = SSISConstants.APPROVED;
int qty = Convert.ToInt32(voucher_request.Quantity);
voucher_request.Stationery_Catalogue.Total_Quantity = voucher_request.Stationery_Catalogue.Total_Quantity + qty;
ssisEntities.SaveChanges();
populateVoucherRequests();
}
else if (e.CommandName == "Reject")
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
HiddenField itemNumerHdden = (HiddenField)GridVoucherRequest.Rows[rowIndex].FindControl("LblVoucherId");
int voucherId = Convert.ToInt32(itemNumerHdden.Value);
Voucher_Request voucher_request = ssisEntities.Voucher_Request.Where(x => x.Voucher_ID == voucherId).First();
voucher_request.Status = SSISConstants.REJECTED;
ssisEntities.SaveChanges();
populateVoucherRequests();
}
}
public static Voucher_Request GetVoucherRequest_ByID(int voucher_ID)
{
Voucher_Request voucher_request = ssisEntities.Voucher_Request.Where(x => x.Voucher_ID == voucher_ID).First();
return(voucher_request);
}
