public ActionResult updateRetrieve()
{
StationeryModel entity = new StationeryModel();
if (Request.QueryString["ErrorMessage"] != null)
{
TempData["ErrorMessage"] = Request.QueryString["ErrorMessage"];
return(RedirectToAction("GenerateRetrieveForm"));
}
var RetrieveQty = Convert.ToInt32((Request.QueryString["key1"]));
var itemCode = Request.QueryString["key2"];
var description = Request.QueryString["key4"];
var Qty = Convert.ToInt32(Request.QueryString["key3"]);
var page = Convert.ToInt32(Request.QueryString["key5"]);
var stock = Convert.ToInt32(Request.QueryString["key6"]);
var status = Request.QueryString["key7"];
if (status != null)
{
List <Requisition_Detail> list = entity.Requisition_Detail.Where(x => x.itemCode == itemCode).ToList();
foreach (var item in list)
{
item.allocatedQty = 0;
}
entity.SaveChanges();
}
var rlist = (List <RetrieveForm>)HttpContext.Application["retrieveList"];
rlist.Where(x => x.ItemCode == itemCode).First().retrieveQty = RetrieveQty;
HttpContext.Application["retrieveList"] = rlist;
TempData["Successful"] = "Retrieve successfully.";
return(RedirectToAction("GenerateRetrieveForm", new { pagenumber = page }));
}
//for android: different cos of execution of rd.allocateQty += allocateQty
public int UpdateRequisitionDetailsAndroid(string itemcode, int requisitionNo, int?allocateQty)
{
try
{
StationeryModel entity = new StationeryModel();
Requisition_Detail rd = new Requisition_Detail();
rd = entity.Requisition_Detail.Where(x => x.itemCode == itemcode && x.requisitionNo == requisitionNo).First();
//start of code added by alex//
//deduct retrieve qty after doing allocation
List <RetrieveForm> retrievalList = (List <RetrieveForm>)HttpContext.Current.Application["retrieveForm"];
int index = retrievalList.FindIndex(x => x.ItemCode == itemcode);
retrievalList[index].retrieveQty -= allocateQty;
HttpContext.Current.Application["retrieveForm"] = retrievalList;
//end of code//
rd.allocatedQty += allocateQty;
entity.SaveChanges();
return(0);
}
catch
{
return(0);
}
}
public int UpdateAdjustmentVoucherInfo(Adjustment_Voucher_Record voucher)
{
using (StationeryModel context = new StationeryModel())
{
try
{
Adjustment_Voucher_Record record = (from r in context.Adjustment_Voucher_Records
where r.voucherID == voucher.voucherID
select r).First();
record.approvalDate = voucher.approvalDate;
record.authorisingStaffID = voucher.authorisingStaffID;
record.handlingStaffID = voucher.handlingStaffID;
record.issueDate = voucher.issueDate;
record.remarks = voucher.remarks;
record.status = voucher.status;
return(context.SaveChanges());
}
catch (Exception e)
{
string errorMessage = String.Format("Error occurs when updating adjustment voucher. ({0})", e.Message);
throw new Exception(errorMessage);
}
}
}
public bool AddPurchaseDetail(string deliveryOrderNo, string itemCode, int qty, string remarks, decimal price)
{
using (StationeryModel Entity = new StationeryModel())
{
int maxOrderNo = 0;
//to obtain highest order number
List <Purchase_Order_Record> pds = Entity.Purchase_Order_Records.ToList();
foreach (Purchase_Order_Record p in pds)
{
maxOrderNo = 1;
if (p.orderNo > maxOrderNo)
{
maxOrderNo = p.orderNo;
}
}
Purchase_Detail pd = new Purchase_Detail();
pd.orderNo = maxOrderNo + 1;
pd.deliveryOrderNo = deliveryOrderNo;
pd.itemCode = itemCode;
pd.qty = qty;
pd.remarks = remarks;
pd.price = price;
Entity.Purchase_Detail.Add(pd);
Entity.SaveChanges();
return(true);
}
}
public Boolean AddNewDepartment(Department dept)
{
try
{
StationeryModel entity = new StationeryModel();
Department department = new Department();
string capDeptCode = dept.departmentCode.ToUpper();
department.departmentCode = capDeptCode;
department.departmentName = dept.departmentName;
department.contactName = dept.contactName;
department.phoneNo = dept.phoneNo;
department.faxNo = dept.faxNo;
//department.departmentHeadID = dept.departmentHeadID;
if (dept.collectionPointID.ToString() == "--Select--")
{
return(false);
}
else
{
department.collectionPointID = dept.collectionPointID;
//department.representativeID = dept.representativeID;
entity.Departments.Add(department);
entity.SaveChanges();
}
}
catch
{
return(false);
}
return(true);
}
public bool AddNewPurchaseOrder(Purchase_Order_Record purchase_order_record)
{
StationeryModel Entity = new StationeryModel();
Entity.Purchase_Order_Records.Add(purchase_order_record);
Entity.SaveChanges();
return(true);
}
//CLERK
//transfer to transactionDAO
public bool AddNewTransactionRecord(Transaction_Record tr)
{
using (StationeryModel ctx = new StationeryModel())
{
ctx.Transaction_Records.Add(tr);
ctx.SaveChanges();
return(true);
}
}
//CLERK
//transfer this code to transactionDAO
public bool AddNewTransactionDetail(Transaction_Detail td)
{
using (StationeryModel ctx = new StationeryModel())
{
ctx.Transaction_Details.Add(td);
ctx.SaveChanges();
return(true);
}
}
public bool AddNewAdjustmentVoucher(Adjustment_Voucher_Record voucher)
{
using (StationeryModel context = new StationeryModel())
{
context.Adjustment_Voucher_Records.Add(voucher);
context.SaveChanges();
return(true);
}
}
public bool AddPurchaseDetail(Purchase_Detail pd)
{
using (StationeryModel Entity = new StationeryModel())
{
Entity.Purchase_Detail.Add(pd);
Entity.SaveChanges();
return(true);
}
}
public bool DeletePurchaseOrder(int orderID)
{
using (StationeryModel Entity = new StationeryModel())
{
Purchase_Order_Record por = Entity.Purchase_Order_Records.Where(x => x.orderNo == orderID).First();
Entity.Purchase_Order_Records.Remove(por);
Entity.SaveChanges();
return(true);
}
}
public int UpdateRequisitionDetails(string itemcode, int requisitionNo, int?allocateQty, int?fulfilledQty)
{
StationeryModel entity = new StationeryModel();
Requisition_Detail rd = new Requisition_Detail();
rd = entity.Requisition_Detail.Where(x => x.itemCode == itemcode && x.requisitionNo == requisitionNo).First();
rd.allocatedQty = allocateQty;
rd.fulfilledQty = fulfilledQty;
entity.SaveChanges();
return(0);
}
public void UpdateReqDetail(string No, string itemCode, string quantity)
{
int requisitionNo = Convert.ToInt32(No);
int qty = Convert.ToInt32(quantity);
using (StationeryModel entity = new StationeryModel())
{
entity.Requisition_Detail.Where(x => x.itemCode == itemCode && x.requisitionNo == requisitionNo).First().qty = (int)qty;
entity.SaveChanges();
}
}
//saving the permission into DB
public void CreatePermissions(int permissionID, string controller, string action)
{
using (StationeryModel context = new StationeryModel())
{
permissionInfo p = new permissionInfo();
p.permissionID = permissionID;
p.action = action;
p.controller = controller;
p.description = "";
context.permissionInfoes.Add(p);
context.SaveChanges();
}
}
public void DelegateEmp(string userid, DateTime?from, DateTime?to)
{
using (StationeryModel entity = new StationeryModel())
{
DateTime start = (DateTime)from;
DateTime end = (DateTime)to;
User u = (from user in entity.Users where user.userID == userid select user).FirstOrDefault();
u.delegationStart = start.Date;
u.delegationEnd = end.Date;
u.role = (int)UserRoles.RoleID.ActingDepartmentHead;
entity.SaveChanges();
}
}
public bool DeleteSupplier(string supplierCode)
{
using (StationeryModel context = new StationeryModel())
{
Supplier supplier = (from s in context.Suppliers
where s.supplierCode == supplierCode
select s).FirstOrDefault();
context.Suppliers.Remove(supplier);
context.SaveChanges();
return(true);
}
}
public bool DeleteStationery(string itemCode)
{
using (StationeryModel context = new StationeryModel())
{
Stationery stationery = (from s in context.Stationeries
where s.itemCode == itemCode
select s).FirstOrDefault();
context.Stationeries.Remove(stationery);
context.SaveChanges();
return(true);
}
}
bool ICollectionPointDAO.DeleteCollectionPoint(int collectionPointID)
{
using (StationeryModel context = new StationeryModel())
{
Collection_Point collectionPoint = (from s in context.Collection_Points
where s.collectionPointID == collectionPointID
select s).FirstOrDefault();
context.Collection_Points.Remove(collectionPoint);
context.SaveChanges();
return(true);
}
}
public void AutoRomove(User user)
{
using (StationeryModel entity = new StationeryModel())
{
int UR = 0;
// int supervisor = 0;
User actDeptHead = new User();
actDeptHead = null;
List <User> users = (from u in entity.Users where u.departmentCode == user.departmentCode select u).ToList <User>();
foreach (User check in users)
{
if (check.role == (int)UserRoles.RoleID.ActingDepartmentHead)
{
actDeptHead = (from user1 in entity.Users where (user1.role == 8 && user1.departmentCode == user.departmentCode) select user1).First();
}
}
if (actDeptHead != null)
{
DateTime endDate = (DateTime)actDeptHead.delegationEnd;
DateTime tdy = DateTime.Today;
if (tdy.CompareTo(endDate) > 0)
{
foreach (User u in users)
{
switch (u.role)
{
case (int)UserRoles.RoleID.UserRepresentative:
UR++;
break;
}
}
if (UR < 1) // no userrepresentative in list
{
actDeptHead.role = (int)UserRoles.RoleID.UserRepresentative; //assign as ur
}
else
{
actDeptHead.role = (int)UserRoles.RoleID.Employee; //assign as employee
}
actDeptHead.delegationStart = null;
actDeptHead.delegationEnd = null;
}
entity.SaveChanges();
}
}
}
public bool AddNewSupplier(Supplier supplier)
{
using (StationeryModel context = new StationeryModel())
{
context.Suppliers.Add(supplier);
int rowAffected = context.SaveChanges();
if (rowAffected != 1)
{
throw new DAOException();
}
return(true);
}
}
public void RemovePendingRequisition(string NO)
{
int requisitionNo = Convert.ToInt32(NO);
using (StationeryModel entity = new StationeryModel())
{
Requisition_Record record = (from r in entity.Requisition_Records
where r.requisitionNo == requisitionNo
select r).FirstOrDefault();
entity.Requisition_Detail.RemoveRange(record.Requisition_Detail);
entity.Requisition_Records.Remove(record);
entity.SaveChanges();
}
}
bool ICollectionPointDAO.AddNewCollectionPoint(Collection_Point collectionPoint)
{
using (StationeryModel context = new StationeryModel())
{
context.Collection_Points.Add(collectionPoint);
int rowAffected = context.SaveChanges();
if (rowAffected != 1)
{
throw new DAOException();
}
return(true);
}
}
public int changePassword(User user)
{
using (StationeryModel context = new StationeryModel())
{
User u = (from x in context.Users
where x.userID == user.userID
select x).FirstOrDefault();
u.password = user.password;
int rowAffected = context.SaveChanges();
return(rowAffected);
}
}
public int UpdateRequisitionDetails(string itemcode, int requisitionNo, int?allocateQty)
{
try
{
StationeryModel entity = new StationeryModel();
Requisition_Detail rd = new Requisition_Detail();
rd = entity.Requisition_Detail.Where(x => x.itemCode == itemcode && x.requisitionNo == requisitionNo).First();
rd.allocatedQty = allocateQty;
entity.SaveChanges();
return(0);
}
catch (Exception e) {
e.Message.ToString();
return(1);
}
}
public bool SubmitNewRequisition(Requisition_Record requisition)
{
using (StationeryModel context = new StationeryModel())
{
try
{
context.Requisition_Records.Add(requisition);
context.SaveChanges();
return(true);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
}
int ICollectionPointDAO.UpdateCollectionPointInfo(Collection_Point collectionPoint)
{
using (StationeryModel context = new StationeryModel())
{
Collection_Point c = (from x in context.Collection_Points
where x.collectionPointID == collectionPoint.collectionPointID
select x).FirstOrDefault();
c.collectionPointName = collectionPoint.collectionPointName;
int rowAffected = context.SaveChanges();
return(rowAffected);
}
}
public bool AddNewTransaction(Transaction_Record transaction_record)
{
using (StationeryModel context = new StationeryModel())
{
try
{
context.Transaction_Records.Add(transaction_record);
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public int UpdateDepartmentInfo(Department dept)
{
StationeryModel entity = new StationeryModel();
Department dt = entity.Departments.Where(x => x.departmentCode == dept.departmentCode).First();
dt.departmentName = dept.departmentName;
dt.contactName = dept.contactName;
dt.phoneNo = dept.phoneNo;
dt.faxNo = dept.faxNo;
//dt.departmentHeadID = dept.departmentHeadID;
dt.collectionPointID = dept.collectionPointID;
//dt.representativeID = dept.representativeID;
//dt = dept;
int row = entity.SaveChanges();
return(row);
}
public static Boolean changePassWord(string userID, string CurrentPassword, string NewPassWord)
{
using (StationeryModel entity = new StationeryModel())
{
if (entity.Users.Where(x => x.userID == userID && x.password == CurrentPassword).Count() > 0)
{
User updateUser = entity.Users.Where(x => x.userID == userID && x.password == CurrentPassword).First();
updateUser.password = NewPassWord;
entity.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public int UpdatePurchaseDetailsInfo(Purchase_Detail pd)
{
using (StationeryModel Entity = new StationeryModel())
{
Purchase_Detail purchd = (from x in Entity.Purchase_Detail
where x.orderNo == pd.orderNo && x.itemCode == pd.itemCode
select x).FirstOrDefault();
purchd.fulfilledQty = pd.fulfilledQty;
purchd.price = pd.price;
purchd.deliveryOrderNo += " /" + pd.deliveryOrderNo;
purchd.remarks = pd.remarks;
int rowAffected = Entity.SaveChanges();
return(rowAffected);
}
}