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