public ActionResult ViewDisbursementList()
{
string username = Session["username"].ToString();
EmployeeDAO e = new EmployeeDAO();
int clerk_id = e.GetEmployeeByUsername(username).Id;
DisbursementDAO d = new DisbursementDAO();
List <DisbursementVM> list = d.WebGetDisbursementsByClerk(clerk_id);
CollectionPointDAO c = new CollectionPointDAO();
List <CollectionPoint> c_list = c.GetCollectionPointsByClerk(clerk_id);
if (list != null)
{
foreach (DisbursementVM row in list)
{
foreach (CollectionPoint col in c_list)
{
if (col.Id == row.CollectionPointID)
{
row.CollectionPointName = col.Name;
}
}
}
}
ViewData["c_list"] = c_list;
return(View(list));
}
/***********************this confirm button simulates the scene after scanning QRcode (only for Test)**********************************/
/**********************To confirm specified dept disbursement**************************************************************/
protected void Button3_Click(object sender, EventArgs e)
{
int disburseID = Convert.ToInt32(ViewState["disburseID"]);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('you are generate the Disbursement " + disburseID + " ?')", true);
//here should send message box yes or no
DisbursementDAO disDAO = new DisbursementDAO();
//disburList
ConfirmBtn.Enabled = false;
disDAO.updateDisbursementStatus(Convert.ToInt32(ViewState["disburseID"]), "Completed");
disburseGridView.SelectedIndex = -1;
disburseBindGrid();
disburseUpdatePanel.Update();
disburseItemGridView.DataSource = null;
disburseItemGridView.DataBind();
//send email and notification to rep
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
string repID = context.Departments.Where(x => x.deptID == deptid).Select(x => x.repStaffID).ToList().First();
string repName = context.DeptStaffs.Where(x => x.staffID == repID).Select(x => x.staffName).ToList().First();
string confirmDate = DateTime.Now.ToShortDateString();
NotificationDAO nDAO = new NotificationDAO();
nDAO.addDeptNotification(repID, "Disbursement " + disburseID + " is confirmed on " + confirmDate, DateTime.Now);
Email email = new Email();
email.sendConfirmedDisbursementEmailToRep(repName, confirmDate, disburseID.ToString());
}
public ActionResult Index(List <DisbursementViewModel> model)
{
List <Department> deps = DepartmentDAO.GetDepartmentsToDisburse();
ViewBag.depIdList = new SelectList(deps,
nameof(Department.departmentId),
nameof(Department.departmentName));
if (model != null && model.Count > 0)
{
if (model[0].departmentId != null)
{
ViewBag.depInfo = DepartmentDAO.GetDepartmentInfo(model[0].departmentId);
}
}
if (!ModelState.IsValid)
{
return(View(model));
}
bool bRes = DisbursementDAO.ConfirmDisbursement(model);
//ModelState.Clear();
if (bRes)
{
return(RedirectToAction("Index"));
}
else
{
return(View("~/Views/Shared/Error.cshtml"));
}
}
public MResponse ApproveDisbursement(string deptId)
{
DisbursementDAO dao = new DisbursementDAO();
return(new MResponse()
{
Success = dao.ApproveDisbursement(deptId)
});
}
public MResponse GetDisbursements(int clerkId)
{
List <MDisbursement> retrievals = new DisbursementDAO().GetDisbursementsByClerk(clerkId);
return(new MResponseList <MDisbursement>()
{
ResList = retrievals
});
}
protected void disburseItemBindGrid(int disburseID)
{
DisbursementDAO disDAO = new DisbursementDAO();
List <DisbursementCart> disburseItems = disDAO.getDisbursementItemByDisID(disburseID);
ViewState["list"] = disburseItems;
disburseItemGridView.DataSource = disburseItems;
disburseItemGridView.DataBind();
}
public MResponse UpdateDisbursementInfo(int clerkId, string deptId, List <ItemRequest> items)
{
bool success = new DisbursementDAO().UpdateDisbursement(deptId, clerkId, items);
return(new MResponseListAndObj <ItemRequest, CollectionPoint>()
{
Success = success
});
}
public DepartmentRepresentativeController()
{
_disbursementDAO = new DisbursementDAO();
_employeeDAO = new EmployeeDAO();
_disbursementItemDAO = new DisbursementItemDAO();
_collectionPointDAO = new CollectionPointDAO();
_departmentDAO = new DepartmentDAO();
_notificationChannelDAO = new NotificationChannelDAO();
}
public HomeController()
{
_employeeDAO = new EmployeeDAO();
_collectionPointDAO = new CollectionPointDAO();
_notificationChannelDAO = new NotificationChannelDAO();
_requisitionDAO = new RequisitionDAO();
_delegationDAO = new DelegationDAO();
_departmentDAO = new DepartmentDAO();
_disbursementDAO = new DisbursementDAO();
_disbursementItemDAO = new DisbursementItemDAO();
}
public ActionResult ApproveDisbursement()
{
OutstandingDAO outstandingDAO = new OutstandingDAO();
string deptId = GetDeptId(Session["username"].ToString());
//foreach(var ir in itemRequestDAO.GetDisburseItems(deptId))
//{
// outstandingDAO.AddItemRequest(ir);
// requestDAO.UpdateDisbursedDate(ir);
//}
DisbursementDAO dao = new DisbursementDAO();
dao.ApproveDisbursement(deptId);
return(RedirectToAction("Disbursement"));
}
public StoreManagerController()
{
_itemDAO = new ItemDAO();
_supplieritemDAO = new SupplierItemDAO();
_purchaseOrderDAO = new PurchaseOrderDAO();
_purchaseOrderDetailsDAO = new PurchaseOrderDetailsDAO();
_disbursementDAO = new DisbursementDAO();
_disbursementItemDAO = new DisbursementItemDAO();
_stockRecordDAO = new StockRecordDAO();
_notificationChannelDAO = new NotificationChannelDAO();
_requisitionDAO = new RequisitionDAO();
_requisitionItemDAO = new RequisitionItemDAO();
_categoryDAO = new CategoryDAO();
_departmentDAO = new DepartmentDAO();
}
public List <WCFDisbursementCart> getDisbursementItemByDisID(string disID_s)
{
int disID = Convert.ToInt32(disID_s);
List <WCFDisbursementCart> ldiscart_wcf = new List <WCFDisbursementCart>();
DisbursementDAO disDAO = new DisbursementDAO();
List <DisbursementCart> ldc = new List <DisbursementCart>();
ldc = disDAO.getDisbursementItemByDisID(disID);
foreach (var i in ldc)
{
WCFDisbursementCart wcfdiscart = new WCFDisbursementCart(i.ID, i.Description, i.Expected, i.Actual);
ldiscart_wcf.Add(wcfdiscart);
}
return(ldiscart_wcf);
}
public int confirmDisbursement(confirm_JSON confirm_json, string disID_url)
{
int disID = Int32.Parse(disID_url);
string date_s = confirm_json.Scan_date;//put here in case
string staffID = confirm_json.LoginID;
DisbursementDAO disDAO = new DisbursementDAO();
try
{
disDAO.updateDisbursementStatus(disID, "Completed");
return(1);
}
catch (Exception e)
{
return(0);
}
}
public ActionResult EditDisbursementList()
{
string deptId = "";
List <ItemRequest> new_list = new List <ItemRequest>();
DisbursementDAO disbursementDAO = new DisbursementDAO();
foreach (string key in Request.Form.AllKeys)
{
if (Convert.ToString(key) == "deptId")
{
deptId = Convert.ToString(Request[key]);
}
else
{
ItemRequest item = new ItemRequest();
item.ItemId = Convert.ToString(key);
item.ActualQty = Convert.ToInt32(Request[key]);
new_list.Add(item);
}
}
List <ItemRequest> old_list = disbursementDAO.GetDisburseItemsForRep(deptId);
List <ItemRequest> list = new List <ItemRequest>();
foreach (var item in new_list)
{
foreach (var row in old_list)
{
if (item.ItemId == row.ItemId)
{
if (row.ActualQty - item.ActualQty != 0)
{
item.ActualQty = row.ActualQty - item.ActualQty;
list.Add(item);
}
}
}
}
int clerkId = (int)Session["userid"];
disbursementDAO.UpdateDisbursement(deptId, clerkId, list);
return(RedirectToAction("ViewDisbursementList", "StoreClerk"));
}
public MResponse GetDisbursementInfo(string deptId)
{
CollectionPoint point = new CollectionPointDAO().GetCollectionPointByDeptID(deptId);
List <ItemRequest> list = new DisbursementDAO().GetDisburseItemsForRep(deptId);
//bool showApproveButton = false;
//if (list.Count() > 0)
//{
// showApproveButton = DateTime.Today.DayOfWeek == DayOfWeek.Monday;
//}
return(new MResponseListAndObj <ItemRequest, CollectionPoint>()
{
ResObj = point,
ResList = list,
Success = true
});
}
public ActionResult EditDisbursementList(string dept_id, string dept_name)
{
DisbursementDAO disbursementDAO = new DisbursementDAO();
CollectionPointDAO collectionPointDAO = new CollectionPointDAO();
CollectionPoint collectionPoint = collectionPointDAO.GetCollectionPointByDeptID(dept_id);
List <ItemRequest> itemList = disbursementDAO.GetDisburseItemsForRep(dept_id);
DisbursementVM disbursement = new DisbursementVM();
disbursement.DeptName = dept_name;
disbursement.DeptId = dept_id;
disbursement.CollectionPointName = collectionPoint.Name;
disbursement.ItemList = itemList;
return(View(disbursement));
}
// GET: Disbursement
public ActionResult Index(string depId)
{
List <Department> deps = DepartmentDAO.GetDepartmentsToDisburse();
ViewBag.depIdList = new SelectList(deps,
nameof(Department.departmentId),
nameof(Department.departmentName), depId);
List <DisbursementViewModel> model = new List <DisbursementViewModel>();
if (depId != null)
{
model = DisbursementDAO.GetDisbursement(depId);
ViewBag.depInfo = DepartmentDAO.GetDepartmentInfo(depId);
}
return(View(model));
}
//private readonly NotificationChannelDAO _notificationChannelDAO;
//private readonly EmployeeDAO _employeeDAO;
public StoreClerkController()
{
this._disbursementDAO = new DisbursementDAO();
this._requisitionDAO = new RequisitionDAO();
this._requisitionItemDAO = new RequisitionItemDAO();
this._stockRecordDAO = new StockRecordDAO();
this._disbursementItemDAO = new DisbursementItemDAO();
this._purchaseOrderDAO = new PurchaseOrderDAO();
this._itemDAO = new ItemDAO();
this._statusDAO = new StatusDAO();
this._purchaseOrderDetailsDAO = new PurchaseOrderDetailsDAO();
this._employeeDAO = new EmployeeDAO();
this._collectionpointDAO = new CollectionPointDAO();
this._notificationChannelDAO = new NotificationChannelDAO();
this._notificationDAO = new NotificationDAO();
this._supplierItemDAO = new SupplierItemDAO();
//this._notificationChannelDAO = new NotificationChannelDAO();
//this._employeeDAO = new EmployeeDAO();
}
protected void disburseItemGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = disburseItemGridView.Rows[e.RowIndex];
int actual = Int32.Parse((row.FindControl("Actual") as TextBox).Text);
int expected = Int32.Parse((row.FindControl("Expected") as Label).Text);
string itemID = (row.FindControl("itemIDLabel") as Label).Text;
if (actual > expected)
{
disburseItemGridView.EditIndex = -1;
disburseItemGridView.DataSource = (List <DisbursementCart>)ViewState["list"];
disburseItemGridView.DataBind();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('The quantity you entered cannot larger than needed amount!')", true);
return;
}
if (Convert.ToInt32(ViewState["originQty"]) == actual)
{
disburseItemGridView.EditIndex = -1;
disburseItemGridView.DataSource = (List <DisbursementCart>)ViewState["list"];
disburseItemGridView.DataBind();
}
else
{
DisbursementDAO disDAO = new DisbursementDAO();
disDAO.savingActualQty(Convert.ToInt32(ViewState["disburseID"]), itemID, actual);
disburseItemGridView.EditIndex = -1;
List <DisbursementCart> ldc = (List <DisbursementCart>)ViewState["list"];
foreach (var i in ldc)
{
if (i.ID == itemID)
{
i.Actual = actual;
break;
}
}
disburseItemGridView.DataSource = (List <DisbursementCart>)ViewState["list"];
disburseItemGridView.DataBind();
}
}
public List <WCFDisbursement> getDisbursementByDeptID(string deptID)
{
List <WCFDisbursement> ldis_wcf = new List <WCFDisbursement>();
DisbursementDAO disDAO = new DisbursementDAO();
List <Disbursement> ldis = new List <Disbursement>();
ldis = disDAO.getAwaitingDisbursementListByDeptID(deptID);
foreach (var i in ldis)//add in disbursement list
{
WCFDisbursement wcfdis = new WCFDisbursement
{
DisID = i.disbursementID,
DeptID = i.deptID,
StoreStaffID = i.storeStaffID,
DisDate = i.disburseDate,
Status = i.status
};
ldis_wcf.Add(wcfdis);
}
return(ldis_wcf);
}
public List <DisbursementViewModel> GetDisbursement(string departmentId)
{
List <DisbursementViewModel> myModels = DisbursementDAO.GetDisbursement(departmentId);
return(myModels);
}
public bool ConfirmDisbursement([FromBody] List <DisbursementViewModel> myModels)
{
bool bRes = DisbursementDAO.ConfirmDisbursement(myModels);
return(bRes);
}
