public string Delete(DTODieuKienBaoQuan data)
{
try
{
string connect = Provider.Connecting();
SqlConnection con = new SqlConnection(connect);
con.Open();
SqlTransaction sqlTransaction = con.BeginTransaction();
string query = @"delete dbo_DKBQ where DKBQ_ID= " + data.DKBQ_ID + "";
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.Text;
cmd.Transaction = sqlTransaction;
int result = cmd.ExecuteNonQuery();
if (result != 1)
{
sqlTransaction.Rollback();
sqlTransaction.Dispose();
con.Close();
return(@"Lỗi số 1 : DAOHoatChat ->Update : Cập nhật dữ liệu đơn vị tính lỗi");
}
sqlTransaction.Commit();
sqlTransaction.Dispose();
con.Close();
return("SUCCESS");
}
catch (Exception e)
{
return(@"Lỗi ngoại lệ : DAOHoatChat ->Delete : " + e.Message);
}
}
public string Delete(DTODieuKienBaoQuan data)
{
try
{
DAODieuKienBaoQuan DKBQ = new DAODieuKienBaoQuan();
return(DKBQ.Delete(data));
}
catch (Exception e)
{
return("Lỗi ngoại lệ: BUSHoatChat -> Delete: " + e.Message);
}
}
public string Insert(ref DTODieuKienBaoQuan data)
{
try
{
DAODieuKienBaoQuan DKBQ = new DAODieuKienBaoQuan();
return(DKBQ.Insert(ref data));
}
catch (Exception e)
{
return(@"Lỗi ngoại lệ : BUSHoatChat -> Insert : " + e.Message);
}
}
public string Insert(ref DTODieuKienBaoQuan data)
{
try
{
string connect = Provider.Connecting();
SqlConnection con = new SqlConnection(connect);
con.Open();
SqlTransaction sqlTransaction = con.BeginTransaction();
string query = @"insert into dbo_DKBQ(DKBQ_Name) values(N'" + data.DKBQ_Name + "')";
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.Text;
cmd.Transaction = sqlTransaction;
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
query = "SELECT IDENT_CURRENT('dbo_DKBQ')";
SqlCommand cmdID = new SqlCommand(query, con);
cmdID.CommandType = CommandType.Text;
cmdID.Transaction = sqlTransaction;
object id = cmdID.ExecuteScalar();
data.DKBQ_ID = id.ToString();
if (result > 0)
{
sqlTransaction.Commit();
}
else
{
sqlTransaction.Rollback();
sqlTransaction.Dispose();
con.Close();
return("Lỗi số 2 : DAODKBQ -> Insert : Lấy mã đơn vị tính lỗi");
}
}
else
{
sqlTransaction.Rollback();
sqlTransaction.Dispose();
con.Close();
return(@"Lỗi số 1 : DAODKBQ ->Insert : Thêm dữ liệu đơn vị tính lỗi ");
}
sqlTransaction.Dispose();
con.Close();
return("SUCCESS");
}
catch (Exception e)
{
return("Lỗi ngoại lệ: DAODKBQ -> Insert: " + e.Message);
}
}