// add a transaction
// done
public static TransactionVM AddTran(TransactionVM t)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
Transaction tran = new Transaction();
tran.TranDateTime = t.TranDateTime;
tran.ItemCode = t.ItemCode;
tran.QtyChange = t.QtyChange;
tran.UnitPrice = t.UnitPrice;
tran.Desc = t.Desc;
tran.DeptCode = t.DeptCode;
tran.SuppCode = t.SuppCode;
tran.VoucherNo = t.VoucherNo;
entities.Transactions.Add(tran);
entities.SaveChanges();
List <Transaction> translist = entities.Transactions.ToList();
int transId = translist[translist.Count - 1].TranId;
t.TranId = transId;
return(t);
}
catch (Exception ex)
{
throw ex;
}
}
}
//update RequestDetail with reqId and reqDet
public static RequestDetailVM UpdateReqDet(int reqId, RequestDetailVM reqDet)
{
RequestDetailVM ReqDetailVM = new RequestDetailVM();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetail updateReqDetail = entities.RequestDetails.Where(r => r.ReqId == reqId && r.ItemCode.Equals(reqDet.ItemCode)).First();
updateReqDetail.ReqId = reqId;
updateReqDetail.ItemCode = reqDet.ItemCode;
updateReqDetail.ReqQty = reqDet.ReqQty;
updateReqDetail.AwaitQty = reqDet.AwaitQty;
updateReqDetail.FulfilledQty = reqDet.FulfilledQty;
entities.SaveChanges();
List <RequestDetail> lst = entities.RequestDetails.ToList();
RequestDetail rd = lst[lst.Count - 1];
ReqDetailVM.ReqId = rd.ReqId;
ReqDetailVM.ItemCode = rd.ItemCode;
ReqDetailVM.ReqQty = rd.ReqQty;
ReqDetailVM.AwaitQty = rd.AwaitQty;
ReqDetailVM.FulfilledQty = rd.FulfilledQty;
}
return(ReqDetailVM);
}
//set Delegate by DepartmentCode , fromDate , toDate and empId
public static bool setDelegate(string deptCode, DateTime fromDate, DateTime toDate, int empId)
{
//DepartmentVM deptVM = new DepartmentVM();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First();
department.DeptCode = deptCode;
department.DelegateFromDate = fromDate;
department.DelegateToDate = toDate;
department.DelegateApproverId = empId;
int rowinserted = entities.SaveChanges();
if (rowinserted > 0)
{
string startDate = (department.DelegateFromDate ?? default(DateTime)).ToString("dd MMMM yyyy");
string endDate = (department.DelegateToDate ?? default(DateTime)).ToString("dd MMMM yyyy");
EmailBL.AddNewEmailToEmp(empId, "Assign Delegate", "You have been assigned as delegate from " + startDate + " to " + endDate);
return(true);
}
else
{
return(false);
}
}
}
//add RequestDetail with reqId and reqDet
public static RequestDetailVM AddReqDet(int reqId, RequestDetailVM reqDet)
{
RequestDetailVM request = new RequestDetailVM();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetail req = new RequestDetail();
req.ReqId = reqId;
request.ReqId = req.ReqId;
List <RequestDetail> rd = entities.RequestDetails.Where(x => x.ReqId == reqId).ToList();
if (rd.Count == 0)
{
req.ReqLineNo = 1;
}
else
{
req.ReqLineNo = rd[rd.Count - 1].ReqLineNo + 1;
}
request.ReqLineNo = req.ReqLineNo;
req.ItemCode = reqDet.ItemCode;
request.ItemCode = req.ItemCode;
req.ReqQty = reqDet.ReqQty;
request.ReqQty = req.ReqQty;
req.AwaitQty = reqDet.AwaitQty;
request.AwaitQty = req.AwaitQty;
req.FulfilledQty = reqDet.FulfilledQty;
request.FulfilledQty = req.FulfilledQty;
entities.RequestDetails.Add(req);
entities.SaveChanges();
}
return(request);
}
// update request
// done
public static RequestVM UpdateReq(RequestVM req)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
int reqId = req.ReqId;
Request request = entities.Requests.Where(r => r.ReqId == reqId).FirstOrDefault();
request.ApproverComment = req.ApproverComment;
if (req.ReqDateTime != null && DateTime.Compare(req.ReqDateTime, new DateTime(1800, 01, 01)) > 0)
{
request.ReqDateTime = req.ReqDateTime;
}
if (req.ApprovedDateTime != null && DateTime.Compare(req.ApprovedDateTime, new DateTime(1800, 01, 01)) > 0)
{
request.ApprovedDateTime = req.ApprovedDateTime;
}
if (req.CancelledDateTime != null && DateTime.Compare(req.CancelledDateTime, new DateTime(1800, 01, 01)) > 0)
{
request.CancelledDateTime = req.CancelledDateTime;
}
if (req.FulfilledDateTime != null && DateTime.Compare(req.FulfilledDateTime, new DateTime(1800, 01, 01)) > 0)
{
request.FulfilledDateTime = req.FulfilledDateTime;
}
request.Status = req.Status;
entities.SaveChanges();
}
return(req);
}
// remove request by reqId
// done
public static bool RemoveReq(int reqId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
Request request = entities.Requests.Where(r => r.ReqId == reqId).FirstOrDefault();
if (request != null)
{
if (request.Status.Equals("Unsubmitted") || request.Status.Equals("Bookmarked"))
{
RequestDetailBL.removeAllReqDet(reqId);
}
else
{
request.Status = "Cancelled";
request.CancelledDateTime = DateTime.Now;
entities.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
// submit request
// done
public static RequestVM SubmitReq(int reqId, List <RequestDetailVM> reqDetList)
{
// make requestId in reqDetList is the same as reqId
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
RequestVM req = GetReq(reqId);
for (int i = 0; i < reqDetList.Count; i++)
{
if (reqDetList[i].ReqId == reqId)
{
List <RequestDetail> rdlist = entities.RequestDetails.ToList();
for (int j = 0; j < rdlist.Count; j++)
{
if (reqDetList[i].ReqId == rdlist[j].ReqId && reqDetList[i].ReqLineNo == rdlist[j].ReqLineNo)
{
rdlist[j].ReqQty = reqDetList[i].ReqQty;
rdlist[j].AwaitQty = reqDetList[i].AwaitQty;
rdlist[j].FulfilledQty = reqDetList[i].FulfilledQty;
entities.SaveChanges();
}
}
}
}
req.ReqDateTime = DateTime.Now;
req.Status = "Submitted";
req = UpdateReq(req);
int empId = req.EmpId;
Employee emp = entities.Employees.Where(x => x.EmpId == empId).FirstOrDefault();
string deptCode = emp.DeptCode;
Department dept = entities.Departments.Where(x => x.DeptCode == deptCode).FirstOrDefault();
int fromEmpId = req.EmpId;
int toEmpId;
if (dept.DelegateApproverId != null && DateTime.Compare(DateTime.Now, (DateTime)dept.DelegateFromDate) >= 0 &&
DateTime.Compare(DateTime.Now, (DateTime)dept.DelegateToDate) >= 0)
{
toEmpId = (int)dept.DelegateApproverId;
}
else
{
toEmpId = (int)dept.DeptHeadId;
}
string type = "Stationery Request";
string content = "A new stationery request has been submitted";
NotificationBL.AddNewNotification(fromEmpId, toEmpId, type, content);
// for email
EmailBL.SendNewReqEmail(empId, req);
return(req);
}
catch (Exception ex)
{
throw ex;
}
}
}
// add an adjustment
// done
public static List <AdjustmentVM> AddAdj(List <AdjustmentVM> adjList)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
string voucherNo = GenerateVoucherNo();
for (int i = 0; i < adjList.Count; i++)
{
Adjustment adj = new Adjustment();
adj.VoucherNo = voucherNo;
adjList[i].VoucherNo = voucherNo;
adj.EmpId = adjList[i].EmpId;
adj.DateTimeIssued = adjList[i].DateTimeIssued;
adj.ItemCode = adjList[i].ItemCode;
adj.Reason = adjList[i].Reason;
adj.QtyChange = adjList[i].QtyChange;
adj.Status = adjList[i].Status;
adj.ApproverId = adjList[i].ApproverId;
adj.ApproverComment = adjList[i].ApproverComment;
entities.Adjustments.Add(adj);
entities.SaveChanges();
}
return(adjList);
}
catch (Exception ex)
{
throw ex;
}
}
}
// remove request by empId and status
// done
public static bool RemoveReq(int empId, string status)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
List <Request> reqlist = entities.Requests.Where(r => r.EmpId == empId && r.Status == status).ToList();
if (reqlist.Count > 0)
{
for (int i = 0; i < reqlist.Count; i++)
{
if (reqlist[i].Status.Equals("Unsubmitted") || reqlist[i].Status.Equals("Bookmarked"))
{
RequestDetailBL.removeAllReqDet(reqlist[i].ReqId);
}
else
{
reqlist[i].Status = "Cancelled";
reqlist[i].CancelledDateTime = DateTime.Now;
entities.SaveChanges();
}
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
//AddFulfillNotification with empId and repId
public static bool AddFulfillNotification(int empId, int repId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
//var emploeeses=entities.Employees.Where(n => n.EmpId == empId).FirstOrDefault();
//if (emploeeses != null)
try
{
Notification noti = new Notification();
noti.FromEmp = empId;
noti.ToEmp = repId;
noti.NotificationDateTime = System.DateTime.Now;
noti.RouteUri = "";
noti.Type = "Request Submitted";
noti.Content = "Request Submitted";
noti.IsRead = true;
entities.Notifications.Add(noti);
int rowinserted = entities.SaveChanges();
if (rowinserted > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
//AddAcptNotification with repId
public static bool AddAcptNotification(int repId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
Notification noti = new Notification();
noti.FromEmp = 104;
noti.ToEmp = repId;
noti.NotificationDateTime = System.DateTime.Now;
noti.RouteUri = "";
noti.Type = "Request Submitted";
noti.Content = "Request Submitted";
noti.IsRead = true;
entities.Notifications.Add(noti);
int rowinserted = entities.SaveChanges();
if (rowinserted > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
//AddFulfillNotification with empId and repId
public static void AddFulfillNotification(int empId, int repId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
var emploeeses = entities.Employees.Where(n => n.EmpId == empId).FirstOrDefault();
if (emploeeses != null)
{
//var request = entities.Notifications.Where(n => n.Employee.Department.DeptRepId == repId).FirstOrDefault();
//if (request != null)
//{
Notification noti = new Notification();
noti.FromEmp = empId;
noti.ToEmp = repId;
noti.NotificationDateTime = System.DateTime.Now;
noti.RouteUri = "";
noti.Type = "Request Submitted";
noti.Content = "Request Submitted";
noti.IsRead = true;
entities.Notifications.Add(noti);
entities.SaveChanges();
//}
}
}
}
//AddLowStkNotification with empId and item
public static void AddLowStkNotification(int empId, Item i)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
Notification noti = new Notification();
noti.FromEmp = empId;
noti.ToEmp = 104;
noti.NotificationDateTime = System.DateTime.Now;
noti.RouteUri = "";
noti.Type = "Low Stock";
noti.Content = "In a recent stationery request disbursement, there are some items with balance below reorder level. ";
noti.IsRead = true;
entities.Notifications.Add(noti);
entities.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
//var lowStkNoti = entities.Notifications.Where(n => n.Employee.EmpId == empId).FirstOrDefault();
//if (lowStkNoti != null)
//{
// lowStkNoti.Employee.EmpId = empId;
// Item item = i;
// entities.Notifications.Add(lowStkNoti);
// entities.SaveChanges();
//}
}
}
//update Await
public static void UpdateAwait(int reqId, int awaitQty)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetail await = entities.RequestDetails.Where(r => r.ReqId == reqId).First <RequestDetail>();
if (await != null)
{
await.AwaitQty = awaitQty;
}
entities.SaveChanges();
}
}
//remove All
public static void removeAllReqDet(int reqId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetail request = entities.RequestDetails.Where(r => r.ReqId == reqId).FirstOrDefault();
if (request != null)
{
entities.RequestDetails.Remove(request);
entities.SaveChanges();
}
}
}
//set CollPt by DepartmentCode , collPt
public static void setCollPt(string deptCode, int collPt)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First <Department>();
{
department.ColPtId = collPt;
entities.SaveChanges();
}
}
return;
}
// add request
// done
public static RequestVM AddReq(int empId, string status)
{
try
{
RequestVM request = new RequestVM();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Request req = new Request();
req.EmpId = empId;
req.Status = status;
req.ApproverComment = "";
entities.Requests.Add(req);
entities.SaveChanges();
List <Request> lst = entities.Requests.ToList();
Request r = lst[lst.Count - 1];
request.ReqId = r.ReqId;
request.EmpId = r.EmpId;
if (r.ApproverId != null)
{
request.ApproverId = (int)r.ApproverId;
}
else
{
request.ApproverId = 0;
}
request.ApproverComment = r.ApproverComment;
if (r.ReqDateTime != null)
{
request.ReqDateTime = (DateTime)r.ReqDateTime;
}
if (r.ApprovedDateTime != null)
{
request.ApprovedDateTime = (DateTime)r.ApprovedDateTime;
}
if (r.CancelledDateTime != null)
{
request.CancelledDateTime = (DateTime)r.CancelledDateTime;
}
if (r.FulfilledDateTime != null)
{
request.FulfilledDateTime = (DateTime)r.FulfilledDateTime;
}
request.Status = r.Status;
}
return(request);
}
catch (Exception ex)
{
throw ex;
}
}
//set Rep by DepartmentCode , fromEmpId and toEmpId
public static void setRep(string deptCode, int empId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First <Department>();
{
department.DeptRepId = empId;
entities.SaveChanges();
EmailBL.AddNewEmailToEmp(empId, "Assign Reprsentative", "You have been assigned as reprsentative for your department.");
}
}
return;
}
//remove Delegate by DepartmentCode
public static void removeDelegate(string deptCode)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First <Department>();
{
department.DelegateApproverId = null;
department.DelegateFromDate = null;
department.DelegateToDate = null;
entities.SaveChanges();
};
}
}
//Update Fulfilled
public static void UpdateFulfilled(int reqId, int fulfilledQty)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetail fulfilled = entities.RequestDetails.Where(r => r.ReqId == reqId).First <RequestDetail>();
//RequestDetail fulfilled = entities.RequestDetails.Where(r => r.ReqId == reqId).First<RequestDetail>();
if (fulfilled != null)
{
fulfilled.FulfilledQty = fulfilledQty;
entities.SaveChanges();
}
}
}
// reject request
// done
public static bool RejectRequest(int reqId, int empId, string cmt)
{
try
{
List <RequestVM> reqlist = GetReq(empId, "Submitted");
// for email
RequestVM reqVM = new RequestVM();
int toId = 0;
for (int i = 0; i < reqlist.Count; i++)
{
if (reqlist[i].ReqId == reqId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Request req = entities.Requests.Where(r => r.ReqId == reqId).FirstOrDefault();
toId = req.EmpId;
req.ApproverId = empId;
req.ApproverComment = cmt;
req.ApprovedDateTime = DateTime.Now;
req.Status = "Rejected";
entities.SaveChanges();
// for email
reqVM.ReqId = req.ReqId;
reqVM.EmpId = req.EmpId;
reqVM.ApproverId = req.ApproverId;
reqVM.ApproverComment = req.ApproverComment;
reqVM.ReqDateTime = (DateTime)req.ReqDateTime;
reqVM.ApprovedDateTime = (DateTime)req.ApprovedDateTime;
//reqVM.CancelledDateTime = (DateTime)req.CancelledDateTime;
reqVM.Status = req.Status;
//reqVM.FulfilledDateTime = (DateTime)req.FulfilledDateTime;
}
}
}
int fromEmpId = empId;
int toEmpId = toId;
string type = "Stationery Request";
string content = "Your stationery request has been rejected : Please review quantities";
NotificationBL.AddNewNotification(fromEmpId, toEmpId, type, content);
// for email
EmailBL.SendReqApprEmail(toId, reqVM);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//remove removeReqDet by empId and reqId
public static void removeReqDet(int empId, string itemCode, string status)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
List <RequestVM> rvmList = RequestBL.GetReq(empId, status);
for (int i = 0; i < rvmList.Count; i++)
{
int reqId = rvmList[i].ReqId;
RequestDetail rd = entities.RequestDetails.Where(x => x.ReqId == reqId && x.ItemCode == itemCode).FirstOrDefault();
entities.RequestDetails.Remove(rd);
entities.SaveChanges();
}
}
}
// add new notification
public static void AddNewNotification(int fromEmpId, int toEmpId, string type, string content)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Notification notif = new Notification();
notif.NotificationDateTime = DateTime.Now;
notif.FromEmp = fromEmpId;
notif.ToEmp = toEmpId;
notif.RouteUri = "";
notif.Type = type;
notif.Content = content;
notif.IsRead = false;
entities.Notifications.Add(notif);
entities.SaveChanges();
}
}
//set Delegate by DepartmentCode , fromDate , toDate and empId
public static void setDelegate(string deptCode, DateTime fromDate, DateTime toDate, int empId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First();
department.DeptCode = deptCode;
department.DelegateFromDate = fromDate;
department.DelegateToDate = toDate;
department.DelegateApproverId = empId;
entities.SaveChanges();
string startDate = (department.DelegateFromDate ?? default(DateTime)).ToString("dd MMMM yyyy");
string endDate = (department.DelegateToDate ?? default(DateTime)).ToString("dd MMMM yyyy");
EmailBL.AddNewEmailToEmp(empId, "Assign Delegate", "You have been assigned as delegate from " + startDate + " to " + endDate);
}
}
// mark one notification as read
public static bool MarkOneAsRead(NotificationVM n)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
Notification n_orig = entities.Notifications.ToList().Find(x => x.NotificationId == n.NotificationId);
n_orig.IsRead = true;
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
public static bool ToggleReadNotification(int n)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
Notification n_orig = entities.Notifications.ToList().Find(x => x.NotificationId == n);
n_orig.IsRead = !n_orig.IsRead;
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
//AddAcptNotification with repId
public static bool AdjApprNotification(int fromEmpId, int toEmpId, NotificationVM n)
{
NotificationVM adjApprNoti = new NotificationVM();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
Notification noti = new Notification();
noti.FromEmp = fromEmpId;
noti.ToEmp = toEmpId;
noti.NotificationDateTime = System.DateTime.Now;
noti.RouteUri = "";
noti.Type = "Adjustment Submitted";
noti.Content = "Missing Stock";
noti.IsRead = true;
entities.Notifications.Add(noti);
int rowinserted = entities.SaveChanges();
if (rowinserted > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
//adjApprNoti = entities.Notifications.Select(r => new NotificationVM()
//{
// FromEmp = fromEmpId,
// ToEmp = toEmpId,
// NotificationId = n.NotificationId,
// NotificationDateTime = n.NotificationDateTime,
// RouteUri = n.RouteUri,
// Type = n.Type,
// Content = n.Content,
// IsRead = n.IsRead
//}).First<NotificationVM>();
}
}
// mark all notification as read
public static bool MarkAllAsRead(int empId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
List <Notification> nList = entities.Notifications.Where(x => x.ToEmp == empId).ToList();
nList.ForEach(x => x.IsRead = true);
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
//set CollPt by DepartmentCode , collPt
public static bool setCollPt(string deptCode, int collPt)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
Department department = entities.Departments.Where(d => d.DeptCode.Equals(deptCode)).First <Department>();
{
department.ColPtId = collPt;
int rowinserted = entities.SaveChanges();
if (rowinserted > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
// mark all notification as read
public static bool MarkAllAsRead(List <NotificationVM> nList)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
foreach (NotificationVM nvm in nList)
{
Notification n_orig = entities.Notifications.ToList().Find(x => x.NotificationId == nvm.NotificationId);
n_orig.IsRead = true;
}
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
