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);
}
