public IList <Billdetail_Model> GetId(Billdetail_Model model)
{
IList <Billdetail_Model> result = new List <Billdetail_Model>();
result = Connect_Enttity.Billdetails.Where(x => x.id == model.id).Select(x => new Billdetail_Model
{
id = x.id,
bilid = (int)(x.bilid), //khoa ngoai Bill_customers_Model
proid = (int)(x.proid),
sizeid = (int)(x.sizeid),
colorid = (int)(x.colorid),
quantity = (int)(x.quantity),
bilprice = x.bilprice,
bilpricevnd = x.bilpricevnd,
bilmoney = x.bilmoney,
billlocation = (int)(x.billlocation),
Date = Convert.ToDateTime(x.Date),
status = (int)(x.status)
}).ToList();
return(result);
}
public void Update(Billdetail_Model model)
{
var data = Connect_Enttity.Billdetails.FirstOrDefault(x => x.id == model.id);
if (data != null)
{
data.bilid = (int)(model.bilid);
data.proid = (int)(model.proid);
data.sizeid = (int)(model.sizeid);
data.colorid = (int)(model.colorid);
data.quantity = (int)(model.quantity);
data.bilprice = model.bilprice;
data.bilpricevnd = model.bilpricevnd;
data.bilmoney = model.bilmoney;
data.billlocation = (int)(model.billlocation);
data.Date = Convert.ToDateTime(model.Date);
data.status = (int)(model.status);
Connect_Enttity.SaveChanges();
Dispose();
}
}
public IEnumerable <Billdetail_Model> ReadID(Billdetail_Model model)
{
return(GetId(model));
}
