/// <summary>
/// Update ALL
/// </summary>
/// <returns></returns>
public int Update(DM_Nhan_Vien nv)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
int temp = 0;
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
using (var context = help.ent)
{
context.DM_Nhan_Vien.Attach(nv);
context.Entry(nv).State = EntityState.Modified;
temp = help.ent.SaveChanges();
dbcxtransaction.Commit();
}
}
return temp;
////Mở
//m_dbConnection.Open();
////Chuẩn bị
//string sql = "";
//sql += "UPDATE DM_Nhan_Vien ";
//sql += "Set Ten_nhan_vien=@Ten_nhan_vien, ";
//sql += "Ma_nhan_vien=@Ma_nhan_vien, ";
//sql += "Trang_thai=@Trang_thai ";
//sql += "WHERE ID_nhan_vien=@ID_nhan_vien";
//SqlCommand command = new SqlCommand(sql, m_dbConnection);
//command.Parameters.Add("@ID_nhan_vien", SqlDbType.Int).Value = ID_nhan_vien;
//command.Parameters.Add("@Ten_nhan_vien", SqlDbType.NVarChar, 50).Value = Ten_nhan_vien;
//command.Parameters.Add("@Ma_nhan_vien", SqlDbType.VarChar, 50).Value = Ma_nhan_vien;
//command.Parameters.Add("@Trang_thai", SqlDbType.Bit).Value = Trang_thai;
//command.CommandType = CommandType.Text;
////Run
//int result = command.ExecuteNonQuery();
////Đóng
//m_dbConnection.Close();
//return result;
}
/// <summary>
/// Xoa by ID
/// </summary>
/// <returns>bool</returns>
public int Delete(DM_Nhan_Vien nv)
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
help.ent.DM_Nhan_Vien.Attach(nv);
help.ent.DM_Nhan_Vien.Remove(nv);
help.ent.SaveChanges();
dbcxtransaction.Commit();
return 1;
}
return 0;
//{
// //Mở
// m_dbConnection.Open();
// //Chuẩn bị
// string sql = "";
// sql += "Delete from DM_Nhan_Vien ";
// sql += "WHERE ID_nhan_vien=@ID_nhan_vien";
// SqlCommand command = new SqlCommand(sql, m_dbConnection);
// command.Parameters.Add("@ID_nhan_vien", SqlDbType.Int).Value = ID_nhan_vien;
// command.CommandType = CommandType.Text;
// //Run
// int result = command.ExecuteNonQuery();
// //Đóng
// m_dbConnection.Close();
// return result;
}
