public IEnumerable <SelfSelectedStockListNumber_Table_AddModel> SelfSelectedStockListNumber_Table_Add(string EmpID, int ListID, string StockID)
{
var finallistnumber = (from s in db.SelfSelectedStockList
where s.SSS_EmpID == EmpID && s.SSS_ListID == ListID
orderby s.SSS_ListNumberID descending
select s.SSS_ListNumberID).First();
var stockrepeated = (from s in db.SelfSelectedStockList
where s.SSS_EmpID == EmpID && s.SSS_ListID == ListID && s.SSS_StockID == StockID
select s.SSS_StockID).Count();
var listname = (from s in db.SelfSelectedStockList
where s.SSS_EmpID == EmpID && s.SSS_ListID == ListID
select s.SSS_ListName).First();
if (finallistnumber == 0)
{
var update = from s in db.SelfSelectedStockList
where s.SSS_EmpID == EmpID && s.SSS_ListID == ListID
select s;
foreach (var sss in update)
{
sss.SSS_ListNumberID = 1;
sss.SSS_StockID = StockID;
}
db.SaveChanges();
}
else
{
if (stockrepeated == 0)
{
var insert = new SelfSelectedStockList();
insert.SSS_EmpID = EmpID;
insert.SSS_ListID = ListID;
insert.SSS_ListName = listname;
insert.SSS_ListNumberID = (finallistnumber + 1);
insert.SSS_StockID = StockID;
db.SelfSelectedStockList.Add(insert);
db.SaveChanges();
}
}
IEnumerable <SelfSelectedStockListNumber_Table_AddModel> q = from sss in db.SelfSelectedStockList
join si in db.StockInfo
on sss.SSS_StockID equals si.SI_StockID
where sss.SSS_EmpID == EmpID && sss.SSS_ListID == ListID
orderby sss.SSS_ListNumberID
select new SelfSelectedStockListNumber_Table_AddModel
{
SSS_ListNumberID = sss.SSS_ListNumberID,
SSS_StockID = sss.SSS_StockID,
SI_StockName = si.SI_StockName
};
return(q);
}
public IEnumerable <SelfSelectedStockList_Table_AddModel> SelfSelectedStockList_Table_Add(string EmpID, int ListID, string ListName)
{
var insert = new SelfSelectedStockList();
insert.SSS_EmpID = EmpID;
insert.SSS_ListID = ListID;
insert.SSS_ListName = ListName;
insert.SSS_ListNumberID = 0;
db.SelfSelectedStockList.Add(insert);
db.SaveChanges();
IEnumerable <SelfSelectedStockList_Table_AddModel> q = (from s in db.SelfSelectedStockList
where s.SSS_EmpID == EmpID
orderby s.SSS_ListID
select new SelfSelectedStockList_Table_AddModel
{
SSS_ListID = s.SSS_ListID,
SSS_ListName = s.SSS_ListName
}).Distinct();
return(q);
}
