public static List <GoodsReceivedRecord> ReceivedList()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.GoodsReceivedRecords.ToList <GoodsReceivedRecord>());
}
}
public static List <GoodsReceivedRecordDetail> ReceivedDetailList(int receivedID)
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.GoodsReceivedRecordDetails.Where(p => p.GoodReceiveID == receivedID).ToList <GoodsReceivedRecordDetail>());
}
}
public static List <PurchaseOrder> CompletedPurchaseOrderList()
{
Team10ADModel context = new Team10ADModel();
List <PurchaseOrder> polist = context.PurchaseOrders.Where(x => x.Status == "Received").ToList();
return(polist);
}
/////////////Catalogue
public static List <Catalogue> ListCatalogues()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Catalogues.ToList <Catalogue>());
}
}
public static Requisition GetRequisitionById(int reqId)
{
using (Team10ADModel context = new Team10ADModel())
{
return(context.Requisitions.Where(r => r.RequisitionID == reqId).First());
}
}
////////////Representative
public static List <Employee> R_EmployeeList(string departmentCode)
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Employees.Where(p => p.DepartmentCode == departmentCode && p.EmployeeID != p.Department.HODID && p.EmployeeID != p.Department.ApproverID).ToList <Employee>());
}
}
public static StoreStaff GetStoreStaffById(int id)
{
using (Team10ADModel context = new Team10ADModel())
{
return(context.StoreStaffs.Where(x => x.StoreStaffID == id).First());
}
}
public static List <Requisition> ProcessedRequisitionList()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Requisitions.Where(p => p.Status == "Approved" || p.Status == "Rejected" || p.Status == "Ready To Collect").ToList <Requisition>());
}
}
public static List <Catalogue> CatalogueList()
{
using (Team10ADModel context = new Team10ADModel())
{
return(context.Catalogues.ToList());
}
}
public static List <Requisition> RequisitionList()
{
using (Team10ADModel context = new Team10ADModel())
{
return(context.Requisitions.ToList());
}
}
public static List <Catalogue> SearchCatalogue(string search)
{
using (Team10ADModel context = new Team10ADModel())
{
return(context.Catalogues.Where(x => x.Description.Contains(search) || x.Category.Contains(search)).ToList());
}
}
public static List <RequisitionDetail> CombineReqDetail(int id)
{
using (Team10ADModel context = new Team10ADModel())
{
return(context.RequisitionDetails.Where(r => r.RequisitionID == id).ToList());
}
}
public static Catalogue GetItemByCode(string itemCode)
{
using (Team10ADModel tm = new Team10ADModel())
{
return(tm.Catalogues.Where(x => x.ItemCode == itemCode).Select(x => x).First());
}
}
public static List <Catalogue> GetLowStockByStatus(string status)
{
using (Team10ADModel tm = new Team10ADModel())
{
return(tm.Catalogues.Where(x => x.ShortfallStatus == status).Select(x => x).ToList());
}
}
public static StockAdjustmentVoucher GetStockAdjustmentVoucherById(int id)
{
using (Team10ADModel context = new Team10ADModel())
{
return(context.StockAdjustmentVouchers.Where(v => v.VoucherID == id).First());
}
}
public static List <Requisition> PartialRequisitionList()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Requisitions.Where(p => p.Status == "Partial").ToList <Requisition>());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string requisitionid = (string)Session["requisitiondetail"];
int reqid = Convert.ToInt32(requisitionid);
Requisition req = RayBizLogic.GetRequisitionById(requisitionid);
var qry = from r in context.RequisitionDetails where r.RequisitionID == reqid select new { r.ItemCode, r.Catalogue.Description, r.QuantityRequested, r.QuantityRetrieved };
dgvRequisitionDetail.DataSource = qry.ToList();
dgvRequisitionDetail.DataBind();
dgvRequisitionDetail.AllowPaging = true;
Model.Employee emp = context.Employees.Where(x => x.EmployeeID == req.RequestorID).First();
Model.Department dept = context.Departments.Where(x => x.DepartmentCode == emp.DepartmentCode).First();
ReqIDTextBox.Text = req.RequisitionID.ToString();
StatusTextBox.Text = req.Status;
DeptNameTextBox.Text = dept.DepartmentName;
DeptCodeTextBox.Text = dept.DepartmentCode;
NameTextBox.Text = emp.Name;
EmployeePhoneTextBox.Text = emp.Phone.ToString();
EmailTextBox.Text = emp.Email;
}
}
public static List <RequisitionDetail> GetRequisitionDetail(int requisitionID)
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.RequisitionDetails.Where(p => p.RequisitionID == requisitionID).ToList <RequisitionDetail>());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string id = (string)Session["AdjustVoucherId"];
int adjId = Convert.ToInt32(id);
int storestaffid = (int)Session["clerkid"];
StoreStaff staff = RayBizLogic.GetStoreStaffById(storestaffid);
dgvVoucherDetail.DataSource = RayBizLogic.AdjustmentVoucherDetailList(adjId);
dgvVoucherDetail.DataBind();
StockAdjustmentVoucher voucher = context.StockAdjustmentVouchers.Where(v => v.VoucherID == adjId).First();
VouchderIdBox.Text = voucher.VoucherID.ToString();
DateTextBox.Text = voucher.DateIssue.ToString();
GenByTextBox.Text = voucher.StoreStaff.Name;
if (staff.Title == "Supervisor" && voucher.Status == "Pending" && RayBizLogic.AdjustmentVoucherCost(adjId) <= 250)
{
AcknowledgeButton.Visible = true;
}
else if (staff.Title == "Manager" && voucher.Status == "Pending" && RayBizLogic.AdjustmentVoucherCost(adjId) > 250)
{
AcknowledgeButton.Visible = true;
}
}
}
public static List <Requisition> checkRequisition(int employeeID)
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Requisitions.Where(p => p.RequestorID == employeeID && p.Status == "Pending").ToList <Requisition>());
}
}
public static List <Retrieval> ListCollectedRetrievals()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Retrievals.Where(p => p.Status == "Retrieved").ToList <Retrieval>());
}
}
public static List <StoreStaff> ClerkLogIn()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.StoreStaffs.Where(p => p.Title == "Clerk").ToList());
}
}
//////////Receive & ReceiveDetail
public static List <PurchaseOrder> PendingReceive()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.PurchaseOrders.ToList <PurchaseOrder>());
}
}
public static List <PurchaseOrder> PendingPurchaseOrderList()
{
Team10ADModel context = new Team10ADModel();
List <PurchaseOrder> polist = context.PurchaseOrders.Where(x => x.Status == "Unreceived" || x.Status == "Partial").ToList();
return(polist);
}
////////////Requisition & RequisitionDetail
public static List <Requisition> RequisitionList()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Requisitions.ToList <Requisition>());
}
}
public static List <RetrievalDetail> ListRetrievalDetails(int retrievalID)
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.RetrievalDetails.Where(p => p.RetrievalID == retrievalID).ToList <RetrievalDetail>());
}
}
public static List <Supplier> ShowSuppliers()
{
using (Team10ADModel tm = new Team10ADModel())
{
return(tm.Suppliers.OrderBy(x => x.SupplierName).ToList());
}
}
/////////////Retrieval & RetrievalDetail
public static List <Retrieval> ListRetrievals()
{
using (Team10ADModel m = new Team10ADModel())
{
return(m.Retrievals.ToList <Retrieval>());
}
}
public static void UpdateCustomer(Catalogue c)
{
using (Team10ADModel m = new Team10ADModel())
{
m.Entry(c).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
}
}
public static void InsertCustomer(Catalogue c)
{
using (Team10ADModel m = new Team10ADModel())
{
m.Catalogues.Add(c);
m.SaveChanges();
}
}
