public static List <Requisition> GetPendingRequisitions(int employeeCode) { List <Requisition> list_result = new List <Requisition>(); LussisEntities context = new LussisEntities(); try { Employee e = context.Employees.Where(x => x.EmpNo.Equals(employeeCode)).FirstOrDefault(); Department d = e.Department; string departmentCode = d.DeptCode; list_result = context.Requisitions.Where( req => req.Status.Equals("Pending") && req.EmployeeWhoIssued.DeptCode.Equals(departmentCode) ).ToList(); } catch (Exception e) { // TODO : Put a decent handler here list_result.Add(new Requisition() { Remarks = e.Message }); } return(list_result); }
public static bool UpdateRequisition(Requisition requisition) { bool result = false; try { LussisEntities context = new LussisEntities(); Requisition req = context.Requisitions.Where(x => x.ReqNo.Equals(requisition.ReqNo)).First(); if (req != null) { req.IssuedBy = requisition.IssuedBy; req.DateIssued = requisition.DateIssued; req.ApprovedBy = requisition.ApprovedBy; req.DateReviewed = requisition.DateReviewed; req.Status = requisition.Status; req.Remarks = requisition.Remarks; } context.SaveChanges(); result = true; } catch (Exception) { result = false; } return(result); }
public static bool AddRequisitionDetail(RequisitionDetail addRequisitionDetail) { bool result = false; try { LussisEntities context = new LussisEntities(); RequisitionDetail requisitionDetail = new RequisitionDetail(); requisitionDetail.ReqNo = addRequisitionDetail.ReqNo; requisitionDetail.ItemNo = addRequisitionDetail.ItemNo; requisitionDetail.Qty = addRequisitionDetail.Qty; context.RequisitionDetails.Add(requisitionDetail); context.SaveChanges(); result = true; } catch (Exception) { result = false; } return(result); }
public static bool UpdateRequisitionDetail(RequisitionDetail updateRequisitionDetail) { bool result = false; try { LussisEntities context = new LussisEntities(); RequisitionDetail requisitionDetail = context.RequisitionDetails .Where(req => req.ReqNo.Equals(updateRequisitionDetail.ReqNo) && req.ItemNo.Equals(updateRequisitionDetail.ItemNo)).FirstOrDefault(); if (requisitionDetail != null) { requisitionDetail.ReqNo = updateRequisitionDetail.ReqNo; requisitionDetail.ItemNo = updateRequisitionDetail.ItemNo; requisitionDetail.Qty = updateRequisitionDetail.Qty; context.SaveChanges(); result = true; } } catch (Exception) { result = false; } return(result); }
public static bool IsRetrievalFormEditable(int RetrievalNo) { LussisEntities context = new LussisEntities(); bool result = false; Retrieval selectedRetrieval = context.Retrievals.Where(ret => ret.RetrievalNo == RetrievalNo).FirstOrDefault(); List <RetrievalDetail> details = null; if (selectedRetrieval != null) { details = context.RetrievalDetails.Where(retDetail => retDetail.RetrievalNo == selectedRetrieval.RetrievalNo).ToList(); if (details != null) { foreach (RetrievalDetail detail in details) { if (detail.Actual == 0) { result = true; } else { result = false; break; } } } } return(result); }
public static bool UpdateDisbursement(DisbursementDetail updatedDisbursementDetail) { bool result = false; try { LussisEntities context = new LussisEntities(); DisbursementDetail disbursementDetail = context.DisbursementDetails .Where(dis => dis.DisbursementNo.Equals(updatedDisbursementDetail.DisbursementNo) && dis.ItemNo.Equals(updatedDisbursementDetail.ItemNo)) .FirstOrDefault(); if (disbursementDetail != null) { disbursementDetail.Needed = updatedDisbursementDetail.Needed; disbursementDetail.Promised = updatedDisbursementDetail.Promised; disbursementDetail.Received = updatedDisbursementDetail.Received; context.SaveChanges(); result = true; } } catch (Exception) { result = false; } return(result); }
//ApprovePODetails functions public static List <PURCHASEORDERVIEW> getPurchaseOrderDetails(int poNO, string supplierSelected) { LussisEntities context = new LussisEntities(); var result = context.PURCHASEORDERVIEWs.Where(x => x.PONo == poNO && x.SupplierCode == supplierSelected).ToList(); return(result); }
//===========================End of Category================================================== //============================Start of Item================================================== //===========================get Item Report=================================================== public static List <ReorderTrendView> getReport(List <string> itemList, String supplierSelect, DateTime startDate, DateTime endDate) { LussisEntities context = new LussisEntities(); var reportListItem = new List <ReorderTrendView>(); //filter items to get list for (int i = 0; i < itemList.Count; i++) { var itemName = itemList[i]; var item = context.ReorderTrendViews .Where(x => x.DateReviewed >= startDate && x.DateReviewed <= endDate) .Where(x => x.SupplierName == supplierSelect) .Where(x => x.Description == itemName) .ToList(); //add items in list[i] into a bigger list to bind to gridview for (int x = 0; x < item.Count; x++) { reportListItem.Add(item[x]); } } //remove null items for (int y = 0; y < reportListItem.Count; y++) { if (reportListItem[y] == null) { reportListItem.Remove(reportListItem[y]); } } reportListItem.OrderBy(x => x.DateReviewed); return(reportListItem); }
//View Requisition Detail public static List <RequisitionDetail> ViewRequisitionDetail(int reqNo) { LussisEntities entity = new LussisEntities(); List <RequisitionDetail> rd = entity.RequisitionDetails.Where(p => p.ReqNo == reqNo).ToList(); return(rd); }
//ApprovePOList functions public static List <PurchaseOrder> getPendingOrdersList() { LussisEntities context = new LussisEntities(); var result = context.PurchaseOrders.Where(x => x.Status == "Pending").ToList(); return(result); }
public static List <RequisitionDetail> SearchReqNo(string value) { using (LussisEntities entities = new LussisEntities()) { return(entities.RequisitionDetails.Where(p => p.ReqNo.ToString().Contains(value.Trim())).ToList()); } }
public static List <StationeryCatalogue> SearchDes(string value) { using (LussisEntities entities = new LussisEntities()) { return(entities.StationeryCatalogues.Where(p => p.Description.Contains(value.Trim())).ToList()); } }
public static string GetDept(int empNo) { LussisEntities entity = new LussisEntities(); Employee currentEmp = entity.Employees.Where(emp => emp.EmpNo == empNo).First(); return(currentEmp.DeptCode); }
public static void UpdatePoint(int empNo, int collectionNewPoint) { string dayofweek = DateTime.Today.DayOfWeek.ToString(); if (dayofweek != "Saturday" || dayofweek != "Sunday") { using (LussisEntities entities = new LussisEntities()) { Employee currEmploy = entities.Employees.Where(emp => emp.EmpNo == empNo).FirstOrDefault(); Department currDept = currEmploy.Department; currDept.CollectionPointNo = collectionNewPoint; entities.SaveChanges(); } LussisEntities entity = new LussisEntities(); Employee currEmployee = entity.Employees.Where(emp => emp.EmpNo == empNo).First(); Department currDepartment = entity.Departments.Where(dep => dep.DeptCode.Equals(currEmployee.DeptCode)).First(); // Send Email EmailBackend.sendEmailStep( currDepartment.EmployeeHead.Email, EmailTemplate.GenerateUpdateCollectionPointEmailSubject(), EmailTemplate.GenerateCollectionPointStatusChangedEmail( currDepartment.EmployeeHead.EmpName.ToString(), currDepartment.CollectionPoint.CollectionPointDetails.ToString()) ); } }
protected void Button1_Click(object sender, EventArgs e) { string code = TextBox1.Text; string name = TextBox2.Text; string gst = TextBox3.Text; string contactName = TextBox4.Text; int phoneNo = Convert.ToInt32(TextBox5.Text); int faxNo = Convert.ToInt32(TextBox6.Text); string address = TextBox7.Text; Supplier supplierObj = new Supplier(); supplierObj.SupplierCode = code; supplierObj.SupplierName = name; supplierObj.GstNo = gst; supplierObj.ContactName = contactName; supplierObj.PhoneNo = phoneNo; supplierObj.FaxNo = faxNo; supplierObj.Address = address; LUSSIS_Backend.LussisEntities databaseObject = new LUSSIS_Backend.LussisEntities(); databaseObject.Suppliers.Add(supplierObj); databaseObject.SaveChanges(); Session["SupplierProcessed"] = code; Response.Redirect("StoreManagerUpdate.aspx"); }
//===============================For Requisition Trend =============================================== //================================Get Report ====================================================== public static List <RequisitionTrendView> getReportRequisitionTrend(List <String> deptList, String itemSelect, DateTime startDate, DateTime endDate) { LussisEntities context = new LussisEntities(); var reportListItemDept = new List <RequisitionTrendView>(); for (var i = 0; i < deptList.Count(); i++) { var deptName = deptList[i]; var dept = context.RequisitionTrendViews .Where(x => x.DateReviewed >= startDate && x.DateReviewed <= endDate) .Where(x => x.Description == itemSelect) .Where(x => x.DeptName == deptName) .OrderBy(x => x.DateReviewed) .ToList(); //add items in list[i] into a bigger list to bind to gridview for (int x = 0; x < dept.Count; x++) { reportListItemDept.Add(dept[x]); } } //remove null items for (int y = 0; y < reportListItemDept.Count; y++) { if (reportListItemDept[y] == null) { reportListItemDept.Remove(reportListItemDept[y]); } } return(reportListItemDept); }
public static Disbursement GetCurrentDisbursementForDepartment(String deptCode) { // TODO : IS IT ASCENDING OR DESCENDING ORDER LussisEntities context = new LussisEntities(); return(context.Disbursements.Where(dis => dis.DeptCode.Equals(deptCode) && dis.Status.Equals("Pending")).OrderByDescending(dis => dis.DisbursementDate).FirstOrDefault()); }
public static bool updateRolesOfEmployeeNo(LussisEntities context, int empNo) { bool result = false; try { String[] assignedRoles = getRolesOfEmployee(context, empNo); String[] expectedRoles = identifyRolesOfEmployee(context, empNo); // Remove Existing Roles foreach (LUSSISRoles role in Enum.GetValues(typeof(LUSSISRoles))) { removeRoleFromEmployee(context, empNo, role); } // Add New Roles foreach (LUSSISRoles role in Enum.GetValues(typeof(LUSSISRoles))) { if (expectedRoles.Contains(Enum.GetName(typeof(LUSSISRoles), role))) { addRoleToEmployee(context, empNo, role); } } result = true; } catch (Exception) { result = false; } return(result); }
//functions for ApproveInventoryAdjustmentList public static List <AdjustmentVoucher> getInvAdjList() { LussisEntities context = new LussisEntities(); var result = context.AdjustmentVouchers.Where(x => x.Status == "Pending").ToList(); return(result); }
//insert new stock transaction details into stocktxndetails public static void updateStockTransactioninDB(StockTxnDetail stkdetails) { LussisEntities context = new LussisEntities(); context.StockTxnDetails.Add(stkdetails); context.SaveChanges(); }
public static void removeAuthority(int profileEmpNo, string deptCode, int outgoingEmpNo) { string recipientEmail; string recipientName; string deptName; string newDeputyName; using (LussisEntities context = new LussisEntities()) { Deputy dep = context.Deputies.Where(x => x.DeptCode.Equals(deptCode)).First(); context.Deputies.Remove(dep); Department dept = context.Departments.Where(x => x.DeptCode.Equals(deptCode)).First(); dept.DeputyEmpNo = profileEmpNo; //setting back to HOD deptName = dept.DeptName; context.SaveChanges(); RoleController.removeRoleFromEmployee(context, outgoingEmpNo, RoleController.LUSSISRoles.DepartmentDeputy); Employee newDeputy = context.Employees.Where(x => x.EmpNo.Equals(dept.EmployeeDeputy.EmpNo)).First(); newDeputyName = newDeputy.EmpName; } using (LussisEntities context = new LussisEntities()) { recipientEmail = context.Employees.Where(x => x.EmpNo.Equals(outgoingEmpNo)).First().Email; recipientName = context.Employees.Where(x => x.EmpNo.Equals(outgoingEmpNo)).First().EmpName; } EmailBackend.sendEmailStep(recipientEmail, EmailTemplate.GenerateOldDeputyAuthorityRemovedSubject(), EmailTemplate.GenerateOldDeputyAuthorityRemovedEmail(recipientName, deptName)); }
public static List <Employee> GetAlternativeRepresentativesFor(int employeeNo) { LussisEntities context = new LussisEntities(); List <Employee> result = new List <Employee>(); Employee currEmployee = context.Employees .Where(emp => emp.EmpNo == employeeNo) .FirstOrDefault(); Department currDepartment = null; if (currEmployee != null) { currDepartment = context.Departments .Where(dep => dep.DeptCode.Equals(currEmployee.DeptCode)) .FirstOrDefault(); if (currDepartment != null) { result = currDepartment.Employees .Where(emp => emp.EmpNo != currDepartment.EmployeeRepresentative.EmpNo) .ToList(); } } return(result); }
public static List <Deputy> getDeputyDetailsForDept(string deptCode) { LussisEntities context = new LussisEntities(); return(context.Deputies.Where(x => x.DeptCode.Equals(deptCode)).OrderBy(x => x.FromDate).ToList()); }
public static string getDepartmentNoFromProfile(int profileEmpNo) { using (LussisEntities context = new LussisEntities()) { return(context.Employees.Where(x => x.EmpNo.Equals(profileEmpNo)).First().DeptCode); } }
//Update ApproveEmpNo in Adjustment Voucher public static void setApprovedBy(int iAV, int empNo) { LussisEntities context = new LussisEntities(); var avd = context.AdjustmentVouchers.Where(x => x.AvNo == iAV).FirstOrDefault(); avd.ApproveEmpNo = empNo; context.SaveChanges(); }
//Button(Reject) function public static void setStatusReject(int iAV) { LussisEntities context = new LussisEntities(); var result = context.AdjustmentVouchers.Where(x => x.AvNo == iAV).FirstOrDefault(); result.Status = "Rejected"; context.SaveChanges(); }
public static List <AdjustmentVoucherDetail> getInvAdjDetails(int iAV) { LussisEntities context = new LussisEntities(); var result = context.AdjustmentVoucherDetails.Where(x => x.AvNo == iAV).ToList(); return(result); }
public static int getEmpNoFromEmpName(string empName) { using (LussisEntities context = new LussisEntities()) { Employee dep = context.Employees.Where(x => x.EmpName.Equals(empName)).First(); return(dep.EmpNo); } }
public static void removeDeputy(string depCode, int depEmpNo) { LussisEntities context = new LussisEntities(); Deputy removeDep = context.Deputies.Where(x => x.DeptCode.Equals(depCode)).First(); context.Deputies.Remove(removeDep); context.SaveChanges(); }
public static List <RequisitionDetail> GetRequisitionDetailsOf(int requisitionNumber) { List <RequisitionDetail> result = new List <RequisitionDetail>(); LussisEntities context = new LussisEntities(); result = context.RequisitionDetails.Where(req => req.ReqNo == requisitionNumber).ToList(); return(result); }