public IEnumerable <Detail> Ch_LVL_NOW(lvl data) { List <Detail> results = new List <Detail>(); try { Detail getvalue = new Detail(); using (HR_SALEDataContext db = new HR_SALEDataContext()) { var sql = (from xx in db.HR_LVLs where xx.LVL == data.CH_LVLNAME && xx.SECTION == data.CH_SECTION select xx).FirstOrDefault(); int Set_Net = Convert.ToInt32(Convert.ToDouble(data.NEW_NET)); int Set_Net_CB = Convert.ToInt32(Convert.ToDouble(data.NEW_NET_CB)); sql.BAL = Set_Net; sql.CBAL = Set_Net_CB; db.SubmitChanges(); } 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 <lvl> LVL(Inputlvl data) { List <lvl> results = new List <lvl>(); try { lvl getvalue = new lvl(); getvalue.CH_LVLNAME = data.LVLNAME; getvalue.CH_SECTION = data.SECTION; getvalue.C_NET = data.NET; getvalue.NEW_NET = data.NET; getvalue.NEW_NET_CB = data.CNET; using (HR_SALEDataContext db = new HR_SALEDataContext()) { var sql = (from xx in db.HR_LVLs select xx); foreach (var item in sql) { lvl.Getlvl mp = new lvl.Getlvl(); mp.LVLNAME = item.LVL; mp.SECTION = item.SECTION; mp.CNET = item.CBAL.ToString(); mp.NET = item.BAL.ToString(); getvalue.Showlvl.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()); }