public IEnumerable <ShowProduct> Main(HR_DATA data)
{
List <ShowProduct> results = new List <ShowProduct>();
try
{
ShowProduct getvalue = new ShowProduct();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = db.VW_SHOW_PRODUCTs.Where(F => F.STCODE == data.USERONLINE).OrderBy(F => F.PTDATE);
var q = db.HR_SALE_GETUSER(data.USERONLINE).FirstOrDefault();
getvalue.Bal = q.CBal;
getvalue.Total = q.CTotal;
getvalue.NET = q.ABal;
foreach (var ux in sql)
{
ShowProduct.SProduct mp = new ShowProduct.SProduct();
mp.S_MPCODE = ux.MPCODE;
mp.S_ABBNO = ux.ABBNO;
mp.S_MPNAME = ux.MPNAME;
mp.S_PRICE = ux.CPRICE;
mp.PRICE = ux.SPRICE;
mp.S_DATE = ux.CDATE;
mp.QTY = ux.QTY.ToString();
getvalue.Ans_SProduct.Add(mp);
//lstMP.Add(mp);
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> Del_now(ShowProduct data)
{
List <Detail> results = new List <Detail>();
try
{
Detail value = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
//---------------------- HR_DelProduct ---------------//
var Del = (from xx in db.HR_SALE_PIs
where xx.STCODE == data.de_USER &&
xx.ABBNO == data.de_ABBNO &&
xx.MPCODE == data.de_MPCODE
select xx).FirstOrDefault();
db.HR_SALE_PIs.DeleteOnSubmit(Del);
db.SubmitChanges();
//----------------------------------------------------
var ss = db.HR_SALE_GetBal(data.de_USER).FirstOrDefault();
if (ss == null)
{
var ss2 = (from sale in db.HR_SALE_USERs
where sale.STCODE == data.de_USER
select sale).FirstOrDefault();
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.de_USER
select xx).FirstOrDefault();
USER.BAL = ss.Total - 0;
db.SubmitChanges();
//----------------------------------------------------
}
else
{
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.de_USER
select xx).FirstOrDefault();
USER.BAL = ss.Total - ss.NET;
db.SubmitChanges();
//----------------------------------------------------
}
}
results.Add(value);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> Change_now(ShowProduct data)
{
List <Detail> results = new List <Detail>();
try
{
Detail value = new Detail();
if (data.ch_QTY <= 0)
{
value.Error = "QTY";
//TempData["QTY"] = "false";
//return RedirectToAction("Main", "Employee");
}
else
{
int price = Convert.ToInt32(Convert.ToDouble(data.ch_PRICE));
int ch_price = data.ch_QTY * price;
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var ss = db.HR_SALE_GetBal(data.ch_USER).FirstOrDefault();
try
{
if (ss.NET + ch_price > ss.Total)
{
value.Error = "limit";
//TempData["limit"] = "false";
//return RedirectToAction("Main", "Employee");
}
else
{
//---------------------- HR_ChProduct ---------------//
var ch = (from xx in db.HR_SALE_PIs
where xx.STCODE == data.ch_USER &&
xx.MPCODE == data.ch_MPCODE &&
xx.ABBNO == data.ch_ABBNO
select xx).FirstOrDefault();
ch.QTY = data.ch_QTY;
ch.NET = ch_price;
db.SubmitChanges();
//----------------------------------------------------
var ss2 = db.HR_SALE_GetBal(data.ch_USER).FirstOrDefault();
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.ch_USER
select xx).FirstOrDefault();
USER.BAL = ss2.Total - ss2.NET;
db.SubmitChanges();
//----------------------------------------------------
}
}
catch
{
}
}
}
results.Add(value);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
