public string GetCurrCollectionPt(string deptCode)
{
string place = " ";
context = new Team4_ADEntities();
var point = from dt in context.Departments from cp in context.CollectionPoints where cp.CollectionID == ((from d in context.Departments where d.Department_Code == deptCode select new { d.CollectionID }).FirstOrDefault().CollectionID) select new { cp.Place };
foreach (var p in point)
{
place = p.Place.ToString();
}
return place;
}
public void UpdateDeptInfo(string dName, int id)
{
context = new Team4_ADEntities();
var query = (from dt in context.Departments where dt.Department_Code == dName select dt).FirstOrDefault();
if (query != null)
{
//list.CollectionID = id;
//cntx.AddToDepartments(list);
query.CollectionID = id;
context.SaveChanges();
}
}
public IList DeptName()
{
context = new Team4_ADEntities();
var name = from d in context.Departments join er in context.EmpRequisitions on d.Department_Code equals er.Department_Code select new { d.Department_Code, d.Department_Name };
return name.Distinct().ToList();
}
public IList DeptItemLstByThreeMonths(string itemcode, int cMonth, int fMonth, int sMonth, int fmYear, int smYear)
{
context = new Team4_ADEntities();
var list = context.sp_DeptItemListByThreeMonth(itemcode, cMonth, fMonth, sMonth, fmYear, smYear).ToList();
return list;
}
//******************************************************************************************************************************
//public List<Stock_Item> ItemList(int id)
//{
// context = new Team4_ADEntities();
// var item = context.getStockItemInfo(id).ToList();
// return item;
//}
//*****************************************************New*********************************************************************
public List<sp_CurrMonthInfo_Result> DeptItemLst(string itemcode, int cMonth, int fMonth)
{
context = new Team4_ADEntities();
var curList = context.sp_CurrMonthInfo(itemcode, cMonth, fMonth).ToList();
return curList;
}
//**************************************************************New***********************************************************
public List<sp_CurrMonthPurchase_Result> CurrMonthPurchase(int pMonth, int cMonth)
{
context = new Team4_ADEntities();
var currList = context.sp_CurrMonthPurchase(pMonth, cMonth).ToList();
return currList;
}
//*****************************************************New**************************************************************
public List<Category> Category_Name()
{
context = new Team4_ADEntities();
var query = from c in context.Categories select c;
return query.ToList();
}
public IList CategoryName()
{
context = new Team4_ADEntities();
var name = from c in context.Categories join st in context.Stock_Item on c.CategoryID equals st.CategoryID join pod in context.PurchaseOrderDetails on st.Item_Code equals pod.Item_Code select new { c.CategoryID, c.Category_Name };
return name.Distinct().ToList();
}
public EmployeeBLL(Team4_ADEntities edm)
{
this.edm = edm;
}
public IList ItemName()
{
context = new Team4_ADEntities();
var name = from st in context.Stock_Item join erd in context.EmpRequisitionDetails on st.Item_Code equals erd.Item_Code select new { st.Item_Code, st.Description };
return name.Distinct().ToList();
}
public IList GetStockHistory(string itemCode, int month)
{
context = new Team4_ADEntities();
var query = from h in context.sp_StockAdjustmentHistory(itemCode, month) select h;
return query.ToList();
}
public IList GetItembyCatId(int id)
{
context = new Team4_ADEntities();
var query = from st in context.Stock_Item join c in context.Categories on st.CategoryID equals id select new { st.Item_Code, st.Description };
return query.Distinct().ToList();
}
public IList DeptRequestRepostThree(string code, int fMonth, int sMonth, int cMonth, int fmYear, int smYear, string status)
{
context = new Team4_ADEntities();
if (status == "ALL")
{
var list = context.sp_DeptReqReportByThree(code, fMonth, sMonth, cMonth, fmYear, smYear).ToList();
return list;
}
else
{
var slist = context.sp_DeptReqReportByStatusThree(code, fMonth, sMonth, cMonth, fmYear, smYear, status).ToList();
return slist;
}
}
public IList CollectionPt()
{
context = new Team4_ADEntities();
var point = from pt in context.CollectionPoints select new { pt.CollectionID, pt.Place };
return point.ToList();
}
//*********************************************************************************************************************************
public List<sp_DeptReqReport_Result> DeptRequestReport(string code, int pMonth, int cMonth)
{
context = new Team4_ADEntities();
var list = context.sp_DeptReqReport(code, pMonth, cMonth).ToList();
return list;
}
public IList PurchaseCatByThreeMonth(int cMonth, int fMonth, int sMonth, int fmYear, int smYear)
{
context = new Team4_ADEntities();
var list = context.sp_PurchaseCatByThree(cMonth, fMonth, sMonth, fmYear, smYear).ToList();
return list;
}
//******************************************************************New*************************************************************
public IList DeptRequestReportMultiple(string code, int pMonth, int cMonth, string status)
{
context = new Team4_ADEntities();
if (status == "ALL")
{
var list = context.sp_DeptReqReport(code, pMonth, cMonth).ToList();
return list;
}
else
{
var slist = context.sp_DeptReqReportByStatus(code, pMonth, cMonth, status).ToList();
return slist;
}
}
public EmployeeBLL()
{
this.edm = new Team4_ADEntities();
}
