public string Update(DTOHoatChat data)
{
try
{
string connect = Provider.Connecting();
SqlConnection con = new SqlConnection(connect);
con.Open();
SqlTransaction sqlTransaction = con.BeginTransaction();
string query = @"update dbo_HoatChat set HoatChat_Name=N'" + data.Name + "',MacDinh=" + data.MacDinh + " where HoatChat_ID='" + data.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 ->Update : " + e.Message);
}
}
public string Delete(DTOHoatChat data)
{
try
{
DAOHoatChat daoHoatChat = new DAOHoatChat();
return(daoHoatChat.Delete(data));
}
catch (Exception e)
{
return("Lỗi ngoại lệ: BUSHoatChat -> Delete: " + e.Message);
}
}
public string Insert(ref DTOHoatChat data)
{
try
{
DAOHoatChat daoHoatChat = new DAOHoatChat();
return(daoHoatChat.Insert(ref data));
}
catch (Exception e)
{
return(@"Lỗi ngoại lệ : BUSHoatChat -> Insert : " + e.Message);
}
}
public string Insert(ref DTOHoatChat data)
{
try
{
string connect = Provider.Connecting();
SqlConnection con = new SqlConnection(connect);
con.Open();
SqlTransaction sqlTransaction = con.BeginTransaction();
string query = @"insert into dbo_HoatChat(HoatChat_Name,MacDinh) values(N'" + data.Name + "','" + data.MacDinh + "')";
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_HoatChat')";
SqlCommand cmdID = new SqlCommand(query, con);
cmdID.CommandType = CommandType.Text;
cmdID.Transaction = sqlTransaction;
object id = cmdID.ExecuteScalar();
data.ID = id.ToString();
if (result > 0)
{
sqlTransaction.Commit();
}
else
{
sqlTransaction.Rollback();
sqlTransaction.Dispose();
con.Close();
return("Lỗi số 2 : DAOHoatChat -> Insert : Lấy mã đơn vị tính lỗi");
}
}
else
{
sqlTransaction.Rollback();
sqlTransaction.Dispose();
con.Close();
return(@"Lỗi số 1 : DAOHoatChat ->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ệ: DAOHoatChat -> Insert: " + e.Message);
}
}