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()); }