public int Update(Phieu_Xuat_Tam_Vat_Tu pxt)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
int temp = 0;
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
using (var context = help.ent)
{
context.Phieu_Xuat_Tam_Vat_Tu.Attach(pxt);
context.Entry(pxt).State = EntityState.Modified;
temp = help.ent.SaveChanges();
dbcxtransaction.Commit();
}
}
return temp;
// DAL.BeginTransaction();
// m_dbConnection = DAL.m_conn;
// if (m_dbConnection.State == ConnectionState.Closed)
// m_dbConnection.Open();
// string sql = "";
// sql += "UPDATE Phieu_xuat_tam_vat_tu ";
// sql += "Set ma_phieu_xuat_tam=@ma_phieu_xuat_tam,ID_kho=@ID_kho,ID_nhan_vien=@ID_nhan_vien,ngay_xuat=@ngay_xuat,Ly_do = @Ly_do ";
// sql += "WHERE ma_phieu_xuat_tam=@ma_phieu_xuat_tam";
// SqlCommand command = new SqlCommand(sql, m_dbConnection,DAL.m_trans);
// command.CommandType = CommandType.Text;
// command.Parameters.Add(new SqlParameter("@ma_phieu_xuat_tam", Ma_phieu_xuat_tam));
// command.Parameters.Add(new SqlParameter("@ID_kho", ID_kho));
// command.Parameters.Add(new SqlParameter("@ngay_xuat", Ngay_xuat.ToString("yyyy-MM-dd")));
// command.Parameters.Add(new SqlParameter("@ID_nhan_vien", ID_Nhan_vien));
//// command.Parameters.Add(new SqlParameter("@so_hoa_don", So_hoa_don));
// command.Parameters.Add(new SqlParameter("@Ly_do", Ly_do));
// int result = command.ExecuteNonQuery();
// DAL.CommitTransaction();
// return result;
}
public int Update(DatabaseHelper help)
{
try
{
{
var item = new Phieu_Xuat_Tam_Vat_Tu();
item.ID_kho = this.ID_kho;
item.ID_nhan_vien = this.ID_Nhan_vien;
item.isGiuLai = this.isGiuLai;
item.isHoanNhap = this.isHoanNhap;
item.Ly_do = this.Ly_do;
item.Cong_trinh = this.Cong_trinh;
item.Dia_chi = this.Dia_chi;
item.Ngay_xuat = this.Ngay_xuat;
item.Ma_phieu_xuat_tam = this.Ma_phieu_xuat_tam;
item.Da_duyet = this.Da_duyet;
item.ID_phieu_xuat_tam = this.ID_phieu_xuat_tam;
help.ent.Phieu_Xuat_Tam_Vat_Tu.Attach(item);
help.ent.Entry(item).State = EntityState.Modified;
help.ent.SaveChanges();
var ctpxt = new Chi_Tiet_Phieu_Xuat_Tam();
var dm = (from d in help.ent.Chi_Tiet_Phieu_Xuat_Tam
where d.Ma_phieu_xuat_tam == item.Ma_phieu_xuat_tam
select d
).ToList();
if (dm == null)
{
return 1;
}
for (int i = 0; i < dm.Count; i++)
{
help.ent.Chi_Tiet_Phieu_Xuat_Tam.Attach(dm[i]);
help.ent.Chi_Tiet_Phieu_Xuat_Tam.Remove(dm[i]);
help.ent.SaveChanges();
}
return 1;
}
}
catch (Exception ex)
{
return 0;
}
}
public int Insert()
{
try
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
var item = new Phieu_Xuat_Tam_Vat_Tu();
item.ID_kho = this.ID_kho;
item.ID_nhan_vien = this.ID_Nhan_vien;
item.isGiuLai = this.isGiuLai;
item.isHoanNhap = this.isHoanNhap;
item.Ly_do = this.Ly_do;
item.Cong_trinh = this.Cong_trinh;
item.Dia_chi = this.Dia_chi;
item.Ngay_xuat = this.Ngay_xuat;
item.Ma_phieu_xuat_tam = this.Ma_phieu_xuat_tam;
item.Da_duyet = this.Da_duyet;
help.ent.Phieu_Xuat_Tam_Vat_Tu.Add(item);
help.ent.SaveChanges();
dbcxtransaction.Commit();
return 1;
}
}
catch (Exception ex)
{
return 0;
}
}
public int Insert(DatabaseHelper help)
{
var item = new Phieu_Xuat_Tam_Vat_Tu();
item.ID_kho = this.ID_kho;
item.ID_nhan_vien = this.ID_Nhan_vien;
item.isGiuLai = this.isGiuLai;
item.isHoanNhap = this.isHoanNhap;
item.Ly_do = this.Ly_do;
item.Cong_trinh = this.Cong_trinh;
item.Dia_chi = this.Dia_chi;
item.Ngay_xuat = this.Ngay_xuat;
item.Ma_phieu_xuat_tam = this.Ma_phieu_xuat_tam;
item.Da_duyet = this.Da_duyet;
item.ID_phieu_xuat_tam = this.ID_phieu_xuat_tam;
help.ent.Phieu_Xuat_Tam_Vat_Tu.Add(item);
return help.ent.SaveChanges();
}
public int Delete(Phieu_Xuat_Tam_Vat_Tu pxt)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
help.ent.Phieu_Xuat_Tam_Vat_Tu.Attach(pxt);
help.ent.Phieu_Xuat_Tam_Vat_Tu.Remove(pxt);
return help.ent.SaveChanges();
//DAL.BeginTransaction();
//m_dbConnection = DAL.m_conn;
//if (m_dbConnection.State == ConnectionState.Closed)
//m_dbConnection.Open();
//string sql = "Delete from Phieu_xuat_tam_vat_tu WHERE ma_phieu_xuat_tam=@ma_phieu_xuat_tam";
//SqlCommand command = new SqlCommand(sql, m_dbConnection, DAL.m_trans);
//command.CommandType = CommandType.Text;
//command.Parameters.Add(new SqlParameter("@ma_phieu_xuat_tam", Ma_phieu_xuat_tam));
//int result = command.ExecuteNonQuery();
//DAL.CommitTransaction();
//return result;
}
