public IList <Bill_customers_Model> GetId(Bill_customers_Model model) { IList <Bill_customers_Model> result = new List <Bill_customers_Model>(); result = Connect_Enttity.Bill_customers.Where(x => x.billid == model.billid).Select(x => new Bill_customers_Model { billid = x.billid, userid = (int)(x.userid), totalmoney = x.totalmoney, idate = Convert.ToDateTime(x.idate), xdate = Convert.ToDateTime(x.xdate), request = x.request, typepay = x.typepay, state = (int)(x.state), lang = x.lang, show = (int)(x.show) }).ToList(); return(result); }
public void Update(Bill_customers_Model model) { var data = Connect_Enttity.Bill_customers.FirstOrDefault(x => x.billid == model.billid); if (data != null) { data.userid = (int)(model.userid); data.totalmoney = model.totalmoney; data.idate = Convert.ToDateTime(model.idate); data.xdate = Convert.ToDateTime(model.xdate); data.request = model.request; data.typepay = model.typepay; data.state = (int)(model.state); data.lang = model.lang; data.show = (int)(model.show); Connect_Enttity.SaveChanges(); Dispose(); } }
public void Create(Bill_customers_Model model) { var data = Connect_Enttity.Bill_customers.FirstOrDefault(x => x.billid == model.billid); if (data == null) { var entity = new Bill_customers(); entity.userid = (int)(model.userid); entity.totalmoney = model.totalmoney; entity.idate = Convert.ToDateTime(model.idate); entity.xdate = Convert.ToDateTime(model.xdate); entity.request = model.request; entity.typepay = model.typepay; entity.state = (int)(model.state); entity.lang = model.lang; entity.show = (int)(model.show); Connect_Enttity.Bill_customers.Add(entity); Connect_Enttity.SaveChanges(); Dispose(); } }
public IEnumerable <Bill_customers_Model> ReadID(Bill_customers_Model model) { return(GetId(model)); }