public static bool CreateAdjustmentVoucher(int sessionID, string itemNo, int qty, string reason) { bool result = false; try { LussisEntities context = new LussisEntities(); Employee employee = AndroidAuthenticationController.GetDetailsOfEmployee(sessionID); StationeryCatalogue itemToChange = context.StationeryCatalogues.Where(item => item.ItemNo.Equals(itemNo)).FirstOrDefault(); // Create new Adjustment Voucher AdjustmentVoucher newVoucher = new AdjustmentVoucher() { DateIssued = DateTime.Today, IssueEmpNo = employee.EmpNo, Status = "Pending" }; context.AdjustmentVouchers.Add(newVoucher); context.SaveChanges(); result = true; if (result == true) { try { // Add Voucher Detail AdjustmentVoucherDetail newAdjustment = new AdjustmentVoucherDetail() { AvNo = newVoucher.AvNo, ItemNo = itemNo, Qty = qty - itemToChange.CurrentQty, Reason = reason }; context.AdjustmentVoucherDetails.Add(newAdjustment); context.SaveChanges(); result = true; } catch (Exception) { result = false; } } } catch (Exception) { result = false; } 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); }
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)); }
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"); }
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 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()) ); } }
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); }
//insert new stock transaction details into stocktxndetails public static void updateStockTransactioninDB(StockTxnDetail stkdetails) { LussisEntities context = new LussisEntities(); context.StockTxnDetails.Add(stkdetails); context.SaveChanges(); }
//set Remarks public static void updateRemarks(int poNO, string remarks) { LussisEntities context = new LussisEntities(); var query = context.PurchaseOrders.Where(x => x.PONo == poNO).SingleOrDefault(); query.Remarks = remarks; context.SaveChanges(); }
//set dateReviewed public static void updateDateReviewed(int poNO) { LussisEntities context = new LussisEntities(); var query = context.PurchaseOrders.Where(x => x.PONo == poNO).SingleOrDefault(); query.DateReviewed = DateTime.Now.Date; context.SaveChanges(); }
//Button(Rejected) function public static void setStatusReject(int poNO) { LussisEntities context = new LussisEntities(); var approvePurchaseOrderview = context.PurchaseOrders.Where(x => x.PONo == poNO).FirstOrDefault(); approvePurchaseOrderview.Status = "Rejected"; context.SaveChanges(); }
//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(); }
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(); }
//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(); }
//set ApproveBy public static void updateApproveBy(int poNO, int empNo) { LussisEntities context = new LussisEntities(); var query = context.PurchaseOrders.Where(x => x.PONo == poNO).SingleOrDefault(); query.ApprovedBy = empNo; context.SaveChanges(); }
public static void UpdateDeputy(Deputy d) { LussisEntities context = new LussisEntities(); Deputy updateDep = context.Deputies.Where(x => x.DeptCode.Equals(d.DeptCode)) .Where(x => x.DeputyEmpNo.Equals(d.DeputyEmpNo)).First(); updateDep.FromDate = d.FromDate; updateDep.ToDate = d.ToDate; context.SaveChanges(); }
public static void DeleteForDetail(int requisitionNo, string item) { LussisEntities entity = new LussisEntities(); RequisitionDetail rr = entity.RequisitionDetails .Where(u => u.ReqNo == requisitionNo && u.ItemNo.Equals(item)) .FirstOrDefault(); entity.RequisitionDetails.Remove(rr); entity.SaveChanges(); }
//Update data for detail page public static void UpdateItem(int requisitionNo, string itemNo, int qty) { LussisEntities entity = new LussisEntities(); RequisitionDetail rrdd = entity.RequisitionDetails .Where(u => u.ReqNo == requisitionNo && u.ItemNo.Equals(itemNo)) .FirstOrDefault(); rrdd.Qty = qty; entity.SaveChanges(); }
//update currentqty in stationery catalogue after adjustments public static void updateStationeryCatalogue(string itemNoText, int qtyAmt) { LussisEntities context = new LussisEntities(); var stockRequireUpdating = context.StationeryCatalogues.SingleOrDefault (x => x.ItemNo == itemNoText); if (stockRequireUpdating != null) { stockRequireUpdating.CurrentQty = qtyAmt; context.SaveChanges(); } }
public static void removeRoleFromEmployee(LussisEntities context, int employeeNo, LUSSISRoles roleToRemove) { if (context == null) { return; } String roleSelected = LUSSISRolesString[(int)roleToRemove]; Employee employee = context.Employees .Where(emp => emp.EmpNo == employeeNo) .FirstOrDefault(); aspnet_Roles selectedRole = context .aspnet_Roles .Where(role => role .RoleName .Equals(roleSelected)) .FirstOrDefault(); if (employee != null) { String empNoToFind = employee.EmpNo.ToString(); aspnet_Profile userProfile = null; foreach (aspnet_Profile profile in context.aspnet_Profile) { if (profile.PropertyValuesString.Equals(empNoToFind)) { userProfile = profile; break; } } if (userProfile != null && selectedRole != null) { Guid userId = userProfile.UserId; aspnet_Users userDetail = context.aspnet_Users.Where(user => user.UserId.Equals(userId)).FirstOrDefault(); userDetail.aspnet_Roles.Remove(selectedRole); context.SaveChanges(); } } }
public static bool RemoveRequisition(Requisition requisition) { bool result = false; try { using (LussisEntities context = new LussisEntities()) { context.Requisitions.Remove(requisition); context.SaveChanges(); result = true; } } catch (Exception) { result = false; } return(result); }
public static int AddRequisition(Requisition requisition) { int result = -1; try { using (LussisEntities context = new LussisEntities()) { context.Requisitions.Add(requisition); context.SaveChanges(); result = requisition.ReqNo; } } catch (Exception) { result = -1; } return(result); }
//Delete row for Requisition History public static void DeleteReqHistory(int reqId) { using (LussisEntities entities = new LussisEntities()) { Requisition requisition = entities.Requisitions.Where(r => r.ReqNo.Equals(reqId)).FirstOrDefault(); List <RequisitionDetail> rd = entities.RequisitionDetails.Where(u => u.ReqNo == reqId).ToList <RequisitionDetail>(); // Delete only Pending Requisitions! if (requisition.Status.Equals("Pending")) { foreach (RequisitionDetail ff in rd) { //delete from database entities.RequisitionDetails.Remove(ff); } Requisition req = entities.Requisitions.Where(p => p.ReqNo == reqId).FirstOrDefault <Requisition>(); entities.Requisitions.Remove(req); entities.SaveChanges(); } } }
public static void checkIfDeputyStartDateElapsed() { LussisEntities context = new LussisEntities(); List <Deputy> listd = context.Deputies.ToList(); if (listd.Count != 0) { for (int i = 0; i < listd.Count; i++) { Deputy d = listd[i]; Department dept = context.Departments.Where(x => x.DeptCode.Equals(d.DeptCode)).First(); if (d.FromDate.Equals(DateTime.Today)) { dept.DeputyEmpNo = d.DeputyEmpNo; RoleController.addRoleToEmployee(context, (int)d.DeputyEmpNo, RoleController.LUSSISRoles.DepartmentDeputy); } } } context.SaveChanges(); }
public static bool AcceptRequisition(int employeeID, int requisitionID, String remarks) { bool result = false; LussisEntities context = new LussisEntities(); Employee approver = context.Employees.Where(emp => emp.EmpNo == employeeID).FirstOrDefault(); Requisition requisition = context.Requisitions.Where(req => req.ReqNo == requisitionID).FirstOrDefault(); // Process only if all values are present in the database if (approver != null && requisition != null) { requisition.Remarks = remarks; requisition.ApprovedBy = approver.EmpNo; requisition.DateReviewed = DateTime.Now.Date; requisition.Status = "Approved"; context.SaveChanges(); // Send Email EmailBackend.sendEmailStep( requisition.EmployeeWhoIssued.Email, EmailTemplate.GenerateRequisitionStatusChangedEmailSubject( requisition.ReqNo.ToString(), requisition.Status), EmailTemplate.GenerateRequisitonStatusChangedEmail( requisition.EmployeeWhoIssued.EmpName, requisition.ReqNo.ToString(), approver.EmpName, requisition.Status, requisition.Remarks) ); // Mark as sucessful result = true; } // Return operation result return(result); }
public static void checkIfDeputyEndDateElapsed() { using (LussisEntities context = new LussisEntities()) { List <Deputy> listd = context.Deputies.ToList(); if (listd.Count != 0) { for (int i = 0; i < listd.Count; i++) { Deputy d = listd[i]; Department dept = context.Departments.Where(x => x.DeputyEmpNo.Equals(d.DeputyEmpNo)).First(); if (d.ToDate.Equals(DateTime.Today)) { context.Deputies.Remove(d); dept.DeputyEmpNo = dept.HeadEmpNo; RoleController.removeRoleFromEmployee(context, (int)d.DeputyEmpNo, RoleController.LUSSISRoles.DepartmentDeputy); } } context.SaveChanges(); } } }
//Add data into database: requisition public static void RaisedRequisition(int issueBy, DateTime dateIssue, string status, List <RequisitionDetail> r) { using (LussisEntities entities = new LussisEntities()) { Requisition req = new Requisition { IssuedBy = issueBy, DateIssued = dateIssue, Status = status }; foreach (RequisitionDetail l in r) { RequisitionDetail rl = new RequisitionDetail(); rl.ReqNo = req.ReqNo; rl.ItemNo = l.ItemNo; rl.Qty = l.Qty; entities.RequisitionDetails.Add(l); } entities.Requisitions.Add(req); entities.SaveChanges(); LussisEntities entity = new LussisEntities(); Employee currEmployee = entity.Employees.Where(emp => emp.EmpNo == issueBy).First(); Department currDepartment = entity.Departments.Where(dep => dep.DeptCode.Equals(currEmployee.DeptCode)).First(); // Send Email to Head EmailBackend.sendEmailStep( currDepartment.EmployeeHead.Email, EmailTemplate.GeneratePendingRequisitionSubject(currEmployee.EmpName.ToString()), EmailTemplate.GeneratePendingRequisition(currDepartment.EmployeeHead.EmpName.ToString(), currEmployee.EmpName.ToString())); //Send email to Employee EmailBackend.sendEmailStep( currEmployee.Email, EmailTemplate.GenerateRaisedRequisitionSubject(), EmailTemplate.GenerateRaisedRequisition(currEmployee.EmpName.ToString(), req.ReqNo.ToString())); } }
public static string addAuthority(string deptCode, int empNo, DateTime start, DateTime end) { Deputy d = new Deputy(); d.DeptCode = deptCode; d.DeputyEmpNo = empNo; d.FromDate = start; d.ToDate = end; string empName = ""; string deptName; string recipientEmail = ""; using (LussisEntities context = new LussisEntities()) { context.Deputies.Add(d); Department dept = context.Departments.Where(x => x.DeptCode.Equals(deptCode)).First(); deptName = dept.DeptName; //for email if (start.CompareTo(DateTime.Today) == 0) { dept.DeputyEmpNo = empNo; RoleController.addRoleToEmployee(context, empNo, RoleController.LUSSISRoles.DepartmentDeputy); } Employee newDeputy = context.Employees.Where(x => x.EmpNo.Equals(empNo)).First(); empName = newDeputy.EmpName; recipientEmail = newDeputy.Email; context.SaveChanges(); } EmailBackend.sendEmailStep(recipientEmail, EmailTemplate.GenerateNewDeputyAuthoritySubject(), EmailTemplate.GenerateNewDeputyAuthorityEmail(empName, deptName, start.ToString(), end.ToString())); return(empName); //for display in view }
public static int GenerateAndroidSessionNumber(int employeeID) { // If there's a problem, defaults to -1 int result = -1; LussisEntities context = new LussisEntities(); // Retrieve the employee Employee employee = context.Employees.Where(emp => emp.EmpNo == employeeID).FirstOrDefault(); if (employee != null) { // Generate the session number result = new Random().Next(10000, 99999); while (context.Employees.Where(emp => emp.SessionNo == result).FirstOrDefault() != null) { // Keep Generating Another Session number until its a unique one // TODO: Find a better way to do this result += 1; while (result > 99999) { result = 10000; } } // Set the session number and expiry (today) employee.SessionNo = result; employee.SessionExpiry = DateTime.Now.Date; // Update the database context.SaveChanges(); } // Return the session number return(result); }