// get an adjustment by voucher number and approverId
// done
public static List <AdjustmentVM> GetAdjList(string voucherNo, int approverId)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
List <AdjustmentVM> avmList = new List <AdjustmentVM>();
if (voucherNo == null || voucherNo.Equals(""))
{
avmList = GetAdjListByApproverId(approverId);
}
else if (approverId.Equals("") || approverId.Equals(null))
{
avmList = GetAdjListByVoucherNo(voucherNo);
}
else
{
List <Adjustment> adjList = entities.Adjustments.Where(a => a.VoucherNo.Equals(voucherNo) && a.ApproverId == approverId).ToList();
avmList = new List <AdjustmentVM>();
for (int i = 0; i < adjList.Count; i++)
{
AdjustmentVM adj = new AdjustmentVM();
adj.VoucherNo = adjList[i].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;
Employee emp = entities.Employees.Where(x => x.Role.Equals("Store Supervisor")).FirstOrDefault();
if (adjList[i].ApproverId != null)
{
adj.ApproverId = (int)adjList[i].ApproverId;
}
else
{
adj.ApproverId = emp.EmpId;
}
adj.ApproverComment = adjList[i].ApproverComment;
avmList.Add(adj);
}
}
return(avmList);
}
catch (Exception ex)
{
throw ex;
}
}
}
//bind request lists
protected void BindGrid()
{
status = ddlStatus.SelectedItem.Text;
adj = Controllers.AdjustmentCtrl.GetAdjListByStatusApproverId(status, empid);
List <AdjustmentVM> adj2 = new List <AdjustmentVM>();
List <string> voucherno = adj.Select(a => a.VoucherNo).Distinct().ToList();
foreach (string vnum in voucherno)
{
AdjustmentVM adjj = adj.Where(a => a.VoucherNo.Equals(vnum)).FirstOrDefault();
adj2.Add(adjj);
}
lstRequests.DataSource = adj2.OrderByDescending(x => x.DateTimeIssued).ToList();
lstRequests.DataBind();
}
// accept adjustment request
// done
public static bool AcceptRequest(string voucherNo, int empId, string cmt)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
// for email
List <AdjustmentVM> adjListEmail = new List <AdjustmentVM>();
int toId = 0;
List <Adjustment> adjList = entities.Adjustments.Where(a => a.VoucherNo.Equals(voucherNo)).ToList();
for (int i = 0; i < adjList.Count; i++)
{
if (adjList[i].ApproverId == empId)
{
adjList[i].ApproverComment = cmt;
adjList[i].Status = "Approved";
int adjRaiseEmpId = adjList[i].EmpId;
Employee adjRaiseEmp = entities.Employees.Where(x => x.EmpId == adjRaiseEmpId).FirstOrDefault();
if (adjRaiseEmp.Role.Equals("Store Clerk"))
{
toId = adjRaiseEmpId;
}
else
{
toId = entities.Employees.Where(x => x.Role.Equals("Store Clerk")).FirstOrDefault().EmpId;
}
// for email
AdjustmentVM adj = new AdjustmentVM();
adj.VoucherNo = adjList[i].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 = (int)adjList[i].ApproverId;
adj.ApproverComment = adjList[i].ApproverComment;
adjListEmail.Add(adj);
string itemCode = adjList[i].ItemCode;
Item item = entities.Items.Where(x => x.ItemCode.Equals(itemCode)).First();
item.Balance += adjList[i].QtyChange;
TransactionVM trans = new TransactionVM();
trans.TranDateTime = DateTime.Now;
trans.ItemCode = itemCode;
trans.QtyChange = adjList[i].QtyChange;
trans.UnitPrice = (double)item.Price1;
trans.Desc = "Adjustment";
trans.DeptCode = "";
trans.SuppCode = "";
trans.VoucherNo = adjList[i].VoucherNo;
TransactionBL.AddTran(trans);
bool status = ItemBL.CheckLowStk(ItemUtility.Convert_ItemObj_To_ItemVMObj(item));
if (status)
{
NotificationBL.AddLowStkNotification(empId, item);
}
}
}
entities.SaveChanges();
int fromEmpId = empId;
int toEmpId = toId;
string type = "Adjustment Request";
string content = voucherNo + " has been approved: No comment";
NotificationBL.AddNewNotification(fromEmpId, toEmpId, type, content);
// for email
EmailBL.SendAdjApprEmail(toId, adjListEmail);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
// reject adjustment request
// done
public static bool RejectRequest(string voucherNo, int empId, string cmt)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
// for email
List <AdjustmentVM> adjListEmail = new List <AdjustmentVM>();
int toId = 0;
List <Adjustment> adjList = entities.Adjustments.Where(a => a.VoucherNo.Equals(voucherNo)).ToList();
for (int i = 0; i < adjList.Count; i++)
{
if (adjList[i].ApproverId == empId)
{
adjList[i].ApproverComment = cmt;
adjList[i].Status = "Rejected";
int adjRaiseEmpId = adjList[i].EmpId;
Employee adjRaiseEmp = entities.Employees.Where(x => x.EmpId == adjRaiseEmpId).FirstOrDefault();
if (adjRaiseEmp.Role.Equals("Store Clerk"))
{
toId = adjRaiseEmpId;
}
else
{
toId = entities.Employees.Where(x => x.Role.Equals("Store Clerk")).FirstOrDefault().EmpId;
}
// for email
AdjustmentVM adj = new AdjustmentVM();
adj.VoucherNo = adjList[i].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 = (int)adjList[i].ApproverId;
adj.ApproverComment = adjList[i].ApproverComment;
adjListEmail.Add(adj);
}
}
entities.SaveChanges();
int fromEmpId = empId;
int toEmpId = toId;
string type = "Adjustment Request";
string content = voucherNo + " has been rejected: Please review quantities";
NotificationBL.AddNewNotification(fromEmpId, toEmpId, type, content);
// for email
EmailBL.SendAdjApprEmail(toId, adjListEmail);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
// raise adjustment
// done
public static bool RaiseAdjustments(int empId, List <ItemVM> iList)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
try
{
// for email
List <AdjustmentVM> adjList = new List <AdjustmentVM>();
string vNum = GenerateVoucherNo();
for (int i = 0; i < iList.Count; i++)
{
if ((iList[i].TempQtyCheck - iList[i].Balance) != 0)
{
Adjustment a = new Adjustment();
a.VoucherNo = vNum;
a.EmpId = empId;
a.DateTimeIssued = DateTime.Now;
a.ItemCode = iList[i].ItemCode;
a.Reason = iList[i].TempReason;
a.QtyChange = (int)iList[i].TempQtyCheck - iList[i].Balance;
a.Status = "Submitted";
Employee emp = new Employee();
emp = entities.Employees.Where(x => x.Role.Equals("Store Supervisor")).FirstOrDefault();
double chgBck = a.QtyChange * iList[i].Price1;
if (a.QtyChange < 0)
{
chgBck = chgBck * -1;
}
if (chgBck >= 250)
{
emp = entities.Employees.Where(x => x.Role.Equals("Store Manager")).FirstOrDefault();
}
a.ApproverId = emp.EmpId;
a.ApproverComment = "";
entities.Adjustments.Add(a);
entities.SaveChanges();
// for email
AdjustmentVM adj = new AdjustmentVM();
adj.VoucherNo = a.VoucherNo;
adj.EmpId = a.EmpId;
adj.DateTimeIssued = a.DateTimeIssued;
adj.ItemCode = a.ItemCode;
adj.Reason = a.Reason;
adj.QtyChange = a.QtyChange;
adj.Status = a.Status;
adj.ApproverId = (int)a.ApproverId;
adj.ApproverComment = a.ApproverComment;
adjList.Add(adj);
int fromEmpIdA = empId;
int toEmpIdA = emp.EmpId;
string typeA = "Adjustment Request";
string contentA = vNum + " has been raised";
NotificationBL.AddNewNotification(fromEmpIdA, toEmpIdA, typeA, contentA);
}
}
// for email
EmailBL.SendAdjReqEmail(empId, adjList);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
// get a list of adjustment by status
// done
public static List <AdjustmentVM> GetAdjListByStatus(string status)
{
try
{
List <AdjustmentVM> list = new List <AdjustmentVM>();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
List <Adjustment> adjlist = new List <Adjustment>();
if (status.Equals("All"))
{
adjlist = entities.Adjustments.Where(a => a.Status.Equals("Submitted") ||
a.Status.Equals("Approved") || a.Status.Equals("Rejected")).ToList();
for (int i = 0; i < adjlist.Count; i++)
{
AdjustmentVM adj = new AdjustmentVM();
adj.VoucherNo = adjlist[i].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;
Employee emp = entities.Employees.Where(x => x.Role.Equals("Store Supervisor")).FirstOrDefault();
if (adjlist[i].ApproverId != null)
{
adj.ApproverId = (int)adjlist[i].ApproverId;
}
else
{
adj.ApproverId = emp.EmpId;
}
adj.ApproverComment = adjlist[i].ApproverComment;
list.Add(adj);
}
}
else
{
adjlist = entities.Adjustments.Where(a => a.Status == status).ToList();
for (int i = 0; i < adjlist.Count; i++)
{
AdjustmentVM adj = new AdjustmentVM();
adj.VoucherNo = adjlist[i].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;
Employee emp = entities.Employees.Where(x => x.Role.Equals("Store Supervisor")).FirstOrDefault();
if (adjlist[i].ApproverId != null)
{
adj.ApproverId = (int)adjlist[i].ApproverId;
}
else
{
adj.ApproverId = emp.EmpId;
}
adj.ApproverComment = adjlist[i].ApproverComment;
list.Add(adj);
}
}
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
public HttpResponseMessage SendAdjApprEmail(int empId, AdjustmentVM adj)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
