public int Update()
{
var t = new Can_tru_no_nhap_ngoai //Make sure you have a table called test in DB
{
ID = this.ID,
Id_chat_luong = this.Id_chat_luong,
Ma_vat_tu = this.Ma_vat_tu, // ID = Guid.NewGuid(),
So_luong_can_tru = this.So_luong_can_tru,
Ma_phieu_nhap = this.Ma_phieu_nhap,
Ma_phieu_nhap_no = this.Ma_phieu_nhap_no,
};
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
int temp = 0;
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
using (var context = help.ent)
{
context.Can_tru_no_nhap_ngoai.Attach(t);
context.Entry(t).State = EntityState.Modified;
temp = help.ent.SaveChanges();
dbcxtransaction.Commit();
}
}
return temp;
}
public int Insert(DatabaseHelper help)
{
{
try
{
var t = new Can_tru_no_nhap_ngoai //Make sure you have a table called test in DB
{
Id_chat_luong = this.Id_chat_luong,
Ma_vat_tu = this.Ma_vat_tu, // ID = Guid.NewGuid(),
So_luong_can_tru = this.So_luong_can_tru,
Ma_phieu_nhap = this.Ma_phieu_nhap,
Ma_phieu_nhap_no = this.Ma_phieu_nhap_no,
};
help.ent.Can_tru_no_nhap_ngoai.Add(t);
help.ent.SaveChanges();
//dbcxtransaction.Commit();
return 1;
}
catch (Exception ex)
{
//dbcxtransaction.Rollback();
return 0;
}
}
}
public int Update(DatabaseHelper help)
{
var t = new Can_tru_no_nhap_ngoai //Make sure you have a table called test in DB
{
ID = this.ID,
Id_chat_luong = this.Id_chat_luong,
Ma_vat_tu = this.Ma_vat_tu, // ID = Guid.NewGuid(),
So_luong_can_tru = this.So_luong_can_tru,
Ma_phieu_nhap = this.Ma_phieu_nhap,
Ma_phieu_nhap_no = this.Ma_phieu_nhap_no,
};
int temp = 0;
{
using (var context = help.ent)
{
context.Can_tru_no_nhap_ngoai.Attach(t);
context.Entry(t).State = EntityState.Modified;
temp = help.ent.SaveChanges();
}
}
return temp;
}
