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