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