public static void CreateRequisition(List <Cart> carts, long empId)
{
List <long> reqs = RequisitionDAO.GetAllRequisitions();
Employee emp = new Employee();
emp.EmpId = empId;
Requisition req = new Requisition();
long arg = reqs.Count == 0 ? 0 : reqs.Max();
req.ReqCode = string.Format(String.Format("#R{0:0000000000}", arg + 1));
req.DateOfRequest = DateTime.Now;
req.Status = "Pending Approval";
req.Employee = emp;
long reqId = RequisitionDAO.SaveRequisition(req);
req.ReqId = reqId;
List <RequisitionDetails> reqDetailsList = new List <RequisitionDetails>();
Inventory item = null;
foreach (Cart c in carts)
{
item = new Inventory();
item.ItemId = c.Item.ItemId;
RequisitionDetails reqDetail = new RequisitionDetails();
reqDetail.Requisition = req;
reqDetail.Item = item;
reqDetail.Quantity = c.Quantity;
reqDetail.Balance = c.Quantity;
reqDetailsList.Add(reqDetail);
}
RequisitionDetailsDAO.SaveRequisitionDetails(reqDetailsList);
CartDAO.DeleteCarts(empId);
}
protected void reSubmit_Click(object sender, EventArgs e)
{
SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities();
RequisitionDAO rdao = new RequisitionDAO();
Requisition newRequisition = new Requisition();
Requisition oldRequisition = rdao.findRequisitionByrequisitionId(reqID);
if (oldRequisition.status != "pending")
{
newRequisition.staffID = oldRequisition.staffID;
newRequisition.deptID = oldRequisition.deptID;
newRequisition.requisitionDate = DateTime.Now;
newRequisition.status = "pending";
context.Requisitions.Add(newRequisition);
var oldRequisitionItemsList = oldRequisition.RequisitionItems;
foreach (RequisitionItem item in oldRequisitionItemsList)
{
RequisitionItem newItem = new RequisitionItem();
newItem.requisitionID = newRequisition.requisitionID;
newItem.itemID = item.itemID;
newItem.requisitionQty = item.requisitionQty;
context.RequisitionItems.Add(newItem);
}
context.SaveChanges();
Response.Redirect("Emp_MyRequisition.aspx");
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Warning', 'You can not resubmit a pending requisition！');</script>");
}
}
protected void requisitionItemListGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "edit")
{
}
else if (e.CommandName == "delete")
{
int reqItemID = Int32.Parse(e.CommandArgument.ToString());// reqitemID !!! not ItemID!!!!
List <ReqItems_custom> lri = new List <ReqItems_custom>();
lri = this.lr_temp;
for (int i = lri.Count - 1; i >= 0; i--)
{
if (lri[i].ReqItemID == reqItemID)
{
lri.RemoveAt(i);
}
}
this.lr_temp = lri;
if (lri.Count == 0)//IF deleting the last reqItem,DELETE this req
{
RequisitionDAO rdao = new RequisitionDAO();
rdao.removeRequisition(this.reqID);
Response.Redirect("Emp_MyRequisition.aspx");
}
RequisitionItemDAO ridao = new RequisitionItemDAO();
ridao.removeItemByReqItemID(reqItemID);
requisitionItemListGridView.DataSource = lri;
requisitionItemListGridView.DataBind();
}
else if (e.CommandName == "Update")
{
this.reqItemID = Int32.Parse(e.CommandArgument.ToString());
}
}
public EmployeeController()
{
_employeeDAO = new EmployeeDAO();
_requisitionDAO = new RequisitionDAO();
_requisitionItemDAO = new RequisitionItemDAO();
_notificationChannelDAO = new NotificationChannelDAO();
_itemDAO = new ItemDAO();
}
public DepartmentActingHeadController()
{
_employeeDAO = new EmployeeDAO();
_requisitionDAO = new RequisitionDAO();
_requisitionItemDAO = new RequisitionItemDAO();
_itemDAO = new ItemDAO();
_departmentDAO = new DepartmentDAO();
_notificationChannelDAO = new NotificationChannelDAO();
_collectionPointDAO = new CollectionPointDAO();
}
public ActionResult RepairDescription_WithdrawEditPopup(int reqID)
{
Database db = new Database();
RequisitionDAO rqDAO = new RequisitionDAO(db);
RequisitionModel reqModel = rqDAO.FindById(reqID);
db.Close();
ViewBag.REQ = reqModel;
return(View());
}
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 Approbation_popup(int reqID)
{
Database db = new Database();
RequisitionDAO reqDAO = new RequisitionDAO(db);
RequisitionModel reqModel = reqDAO.FindById(reqID);
db.Close();
ViewBag.REQ = reqModel;
return(View());
}
protected void updateGV()
{
/**************send pending list*******************/
RequisitionDAO rdao = new RequisitionDAO();
string name = Session["loginID"].ToString();
lr = new List <Requisition>();//to store the pending
if ((fromDate.Text == "") && (toDate.Text == ""))
{
lr_h = rdao.getRequisitionByStaffID(name);
for (int i = lr_h.Count - 1; i >= 0; i--)
{
if (lr_h[i].status == "pending")
{
lr.Add(lr_h[i]);
lr_h.RemoveAt(i);
}
}
}
else
{
if ((fromDate.Text == "") || (toDate.Text == ""))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage1", "alert('Plz Enter correct date range')", true);
return;
}
DateTime from = Convert.ToDateTime(fromDate.Text);
DateTime to = Convert.ToDateTime(toDate.Text);
if (DateTime.Compare(from, to) > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage2", "alert('Start Date should be greater than end Date')", true);
return;
}
if ((fromDate.Text != "") && (toDate.Text != ""))
{
lr_h = rdao.findRequisitionByDateIndividual(from, to, name);
for (int i = lr_h.Count - 1; i >= 0; i--)
{
if (lr_h[i].status == "pending")
{
lr.Add(lr_h[i]);
lr_h.RemoveAt(i);
}
}
}
}
requisitionListGridView.DataSource = lr;
requisitionListGridView.DataBind();
ShowRequisition(lr_h);
}
public ActionResult WithdrawDeleting(int reqID, int repID)
{
RequisitionModel reqModel = new RequisitionModel();
reqModel.REQ_ID = reqID;
Database db = new Database();
RequisitionDAO reqDAO = new RequisitionDAO(db);
reqDAO.Delete(reqModel);
db.Close();
return(Redirect("/Services/RepairDescription?repid=" + repID));
}
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 ActionResult WithdrawUpdate(int reqID, int repID, int reqUnit)
{
RequisitionModel reqModel = new RequisitionModel();
reqModel.REQ_ID = reqID;
reqModel.REQ_UNIT = reqUnit;
Database db = new Database();
RequisitionDAO reqDAO = new RequisitionDAO(db);
reqDAO.Update(reqModel);
db.Close();
return(Redirect("~/Services/RepairDescription?repid=" + repID));
}
public ActionResult RepairDescription()
{
//รับพารามิเตอร์
int repairID = Int32.Parse(Request.Params["repID"]);
RepairDetailModel rdModel = new RepairDetailModel();
/////////////
RepairModel rModel = new RepairModel();
rModel.REPAIR_NO = repairID;
rModel.ALERT_STATUS = "0"; // หมายถึงดูแล้ว
Database db = new Database();
RepairDAO rDAO = new RepairDAO(db);
rDAO.AlertStatus(rModel);
db.Close();
//////////////////////////
db = new Database();
rDAO = new RepairDAO(db);
rdModel.REPAIR = rDAO.FindById(repairID);
db.Close();
db = new Database();
RequisitionDAO rqDAO = new RequisitionDAO(db);
rdModel.STOCK = rqDAO.FindByRepairID(rdModel.REPAIR.REPAIR_NO);
db.Close();
ViewData["Repair"] = rdModel;
// รายการสถานะ
db = new Database();
RepStatusDAO rtDAO = new RepStatusDAO(db);
List <RepStatusModel> rtModel = rtDAO.FindAll();
ViewData["STATUS"] = rtModel;
db.Close();
db = new Database();
RepairDAO rpDAO = new RepairDAO(db);
RepairModel rpModel = rpDAO.FindById(repairID);
db.Close();
return(View());
}
protected void requisitionListGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "delete")
{
string a = e.CommandArgument.ToString();
int req = Int32.Parse(e.CommandArgument.ToString());
RequisitionDAO rdao = new RequisitionDAO();
string name = Session["loginID"].ToString();
rdao.removeRequisition(req);
this.lr = rdao.getRequisitionByStaffID(name);
requisitionListGridView.DataSource = rdao.getReqByStaffIDandStatus(name, "pending");
requisitionListGridView.DataBind();
}
}
public OutLoanDetail GetLoanDetailList(double folderNumber)
{
OutLoanDetail loanDetail = new OutLoanDetail();
try
{
RequisitionDAO dao = new RequisitionDAO();
loanDetail = dao.GetLoanDetailList(folderNumber);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "MangerRequisition", "GetLoanDetailList", ex, "");
}
return(loanDetail);
}
public OutLoanHeader GetLoanHeader(double folderNumber)
{
OutLoanHeader loanHeader = new OutLoanHeader();
try
{
RequisitionDAO dao = new RequisitionDAO();
loanHeader = dao.GetLoanHeader(folderNumber);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "MangerRequisition", "GetLoanHeader", ex, "");
}
return(loanHeader);
}
public OutLoanInformation GetLoanInformationByCustomer(double customerID)
{
OutLoanInformation loanInformation = new OutLoanInformation();
try
{
RequisitionDAO dao = new RequisitionDAO();
loanInformation = dao.GetLoanInformationByCustomer(customerID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "MangerRequisition", "GetLoanInformationByCustomer", ex, "");
}
return(loanInformation);
}
public OutLoanInformation GetLoanInformationByLoanOfficer(double officerID, DateTime startDate, DateTime endDate)
{
OutLoanInformation loanInformation = new OutLoanInformation();
try
{
RequisitionDAO dao = new RequisitionDAO();
loanInformation = dao.GetLoanInformationByLoanOfficer(officerID, startDate, endDate);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "MangerRequisition", "GetLoanInformationByLoanOfficer", ex, "");
}
return(loanInformation);
}
protected void Page_Load(object sender, EventArgs e)
{
/******************judege the role*************************/
string s_role = Session["loginRole"].ToString();
string s_staffID = Session["loginID"].ToString();
if (s_role != "rep" && s_role != "emp")
{
Response.Redirect("Login.aspx"); //it should alert() or redirect to an error page;
}
/******************Judge if the url query is empty***********************/
int reqID = Int32.Parse(Request.QueryString["reqID"]);
if (reqID.ToString() == null)
{
Response.Redirect("Emp_MyRequisition.aspx");
}
this.reqID = reqID;
/****************judge the staffID************************/
RequisitionDAO rdao = new RequisitionDAO();
string url_staffID = rdao.getStaffIDByReqID(reqID);
if (url_staffID == null)
{
Response.Redirect("Emp_MyRequisition");
}
if (url_staffID != s_staffID)
{
Response.Redirect("Login.aspx"); //it should alert() or redirect to an error page;
}
reSubmit.Enabled = true;
RequisitionItemDAO ridao = new RequisitionItemDAO();
string status = rdao.getStatusByReqID(reqID); //get status
if (status == null) //this requisition doesn't exist
{
Response.Redirect("Emp_MyRequisition.aspx");
}
else if (status == "pending")
{
reSubmit.Enabled = false;
}
this.status = status;
initPendingDataGrid();
}
public ActionResult CustServiceDetail(int repID)
{
RepairDetailModel rdModel = new RepairDetailModel();
/////////////
RepairModel rModel = new RepairModel();
rModel.REPAIR_NO = repID;
rModel.ALERT_STATUS = "1"; // หมายถึงดูแล้ว
Database db = new Database();
RepairDAO rDAO = new RepairDAO(db);
rDAO.AlertStatus(rModel);
db.Close();
//////////////////////////
db = new Database();
rDAO = new RepairDAO(db);
rdModel.REPAIR = rDAO.FindById(repID);
db.Close();
db = new Database();
RequisitionDAO rqDAO = new RequisitionDAO(db);
rdModel.STOCK = rqDAO.FindByRepairID(rdModel.REPAIR.REPAIR_NO);
db.Close();
ViewData["Repair"] = rdModel;
// รายการสถานะ
db = new Database();
RepStatusDAO rtDAO = new RepStatusDAO(db);
List <RepStatusModel> rtModel = rtDAO.FindAll();
ViewData["STATUS"] = rtModel;
db.Close();
db = new Database();
RepairDAO rpDAO = new RepairDAO(db);
RepairModel rpModel = rpDAO.FindById(repID);
db.Close();
return(View());
}
public Dictionary <string, List <Requisition> > GetAllPastOrdersOfDepartment()
{
Dictionary <string, List <Requisition> > reqDict = new Dictionary <string, List <Requisition> >();
Employee user = AuthUtil.GetCurrentLoggedUser();
if (user == null)
{
reqDict.Add("reqList", new List <Requisition>());
}
else
{
List <Requisition> reqs = RequisitionDAO.GetAllPastOrderReqs((int)user.DeptId);
reqDict.Add("reqList", reqs);
}
return(reqDict);
}
//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();
}
public static List <Requisition> DisplayPastRequisitions(long deptId)
{
string[] status = { "Approved", "Assigned to Collection", "Partially Completed", "Partially Completed(assigned)", "Completed" };
List <Requisition> list = RequisitionDAO.GetRequisitionsByStatuses(status);
List <Requisition> filtered = new List <Requisition>();
if (list.Count != 0)
{
list = GetRequisitionsWithObjects(list);
for (int i = 0; i < list.Count; i++)
{
if (list[i].Employee.Department.DeptId == deptId)
{
filtered.Add(list[i]);
}
}
}
return(filtered);
}
public static List <Requisition> ShowAllRequisitionsByStatusByDate(string status)
{
List <Requisition> list;
if (status == "Outstanding" || status == null)
{
list = RequisitionDAO.GetRequisitionsByStatuses("Approved", "Partially Completed");
}
else
{
list = RequisitionDAO.GetRequisitionsByStatuses("Completed");
}
if (list.Count == 0)
{
return(null);
}
list = GetRequisitionsWithObjects(list);
return(list);
}
public static List <Requisition> DisplayPendingRequisitions(long deptId)
{
string[] status = { "Pending Approval" };
List <Requisition> list = RequisitionDAO.GetRequisitionsByStatuses(status);
List <Requisition> filtered = new List <Requisition>();
if (list.Count != 0)
{
list = GetRequisitionsWithObjects(list);
for (int i = 0; i < list.Count; i++)
{
;
if (list[i].Employee.Department.DeptId == deptId)
{
filtered.Add(list[i]);
}
}
}
return(filtered);
}
public ActionResult WithdrawPartsInserting(int wdUnit, int repID, int stockID, int userID)
{
RequisitionModel rqModel = new RequisitionModel();
rqModel.REPAIR_NO = new RepairModel();
rqModel.REPAIR_NO.REPAIR_NO = repID;
rqModel.STOCK_NO = new StockModel();
rqModel.STOCK_NO.STOCK_ID = stockID;
rqModel.REQ_UNIT = wdUnit;
rqModel.APROVE = "wait";
rqModel.STAFF = new UsersModel();
rqModel.STAFF.USER_NO = userID;
Database db = new Database();
RequisitionDAO rqDAO = new RequisitionDAO(db);
rqDAO.Add(rqModel);
db.Close();
return(Redirect("~/Services/RepairDescription?repID=" + repID));
}
protected void Page_Load(object sender, EventArgs e)
{
//for session judgment
string role = Session["loginRole"].ToString();
if (!IsPostBack)
{
if (role != "rep" && role != "emp")
{
HttpContext.Current.Response.Redirect("login.aspx");
return;
}
List <Requisition> lr_h = new List <Requisition>(); //finally store stuffs without pending
List <Requisition> lr = new List <Requisition>(); //to store the pending
RequisitionDAO rdao = new RequisitionDAO();
string name = Session["loginID"].ToString();
/***************send history************************/
updateGV();
tb.Text = strPageNum;
}
}
public ActionResult approbationManagement(string SearchText, int?page)
{
Database db = new Database();
RequisitionDAO rqDAO = new RequisitionDAO(db);
List <RequisitionModel> rqModel = rqDAO.FindAll();
db.Close();
ViewBag.Total = rqModel.Count;
var data = from a in rqModel select a;
if (!String.IsNullOrEmpty(SearchText))
{
if (SearchText.Contains("อนุมัติแล้ว"))
{
SearchText = "allow";
}
else if (SearchText.Contains("รออนุมัติ"))
{
SearchText = "wait";
}
else if (SearchText.Contains("ไม่อนุมัติ"))
{
SearchText = "not";
}
data = data.Where(
a => a.REPAIR_NO.DAMAGE.Contains(SearchText) ||
a.STOCK_NO.PART.BRAND.PART_BRAND_NAME.Contains(SearchText) ||
a.STOCK_NO.PART.TYPE.PART_TYPE_NAME.Contains(SearchText) ||
a.STOCK_NO.STOCK_INFO.Contains(SearchText) ||
a.APROVE.Contains(SearchText)
);
}
var numPage = page ?? 1;
ViewBag.Approbation = data.ToPagedList(numPage, 20);
return(View());
}
public ActionResult RequisitionReportView(int?page)
{
string month = Request.Params["month"];
ConvertClass cv = new ConvertClass();
if (String.IsNullOrEmpty(month))
{
month = "0-0";
}
List <RequisitionModel> rqModel = new List <RequisitionModel>();
Database db = new Database();
RequisitionDAO rqDAO = new RequisitionDAO(db);
rqModel = rqDAO.FindByMonthYear(month);
db.Close();
ViewBag.TOTAL = rqModel.Count;
var pageNum = page ?? 1;
ViewBag.DATA = rqModel.ToPagedList(pageNum, 20);
return(View());
}
public static List <RequisitionDetails> DisplayRequisitionDetailsByReqId(long reqId)
{
List <RequisitionDetails> list = RequisitionDAO.GetRequisitionDetailsByReqId(reqId);
List <long> inventoryIds = new List <long>();
foreach (RequisitionDetails req in list)
{
inventoryIds.Add(req.Item.ItemId);
//req.Employee = EmployeeDAO.GetEmployeeById(req.Employee.EmpId);
}
List <Inventory> items = CatalogueDAO.GetInventoriesByIdList(inventoryIds);
if (items.Count != 0)
{
for (int i = 0; i < list.Count; i++)
{
list[i].Item = items.Find(item => item.ItemId == list[i].Item.ItemId);
}
}
return(list);
}
