public string Delete(DTONCC data)
{
try
{
string connect = Provider.Connecting();
SqlConnection con = new SqlConnection(connect);
con.Open();
SqlTransaction sqlTransaction = con.BeginTransaction();
string query = @"Delete dbo_NCC where NCC_ID=" + data.NCC_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 : DAOUnit ->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ệ : DAOUnit ->Delete : " + e.Message);
}
}
public string Update(DTONCC data)
{
try
{
string connect = Provider.Connecting();
SqlConnection con = new SqlConnection(connect);
con.Open();
SqlTransaction sqlTransaction = con.BeginTransaction();
string query = @"update dbo_NCC set NCC_Name=N'" + data.NCC_Name + "',DiaChi=N'" + data.DiaChi + "',Email=N'" + data.Email + "',SDT='" + data.SDT + "',Fax='" + data.Fax + "',MaSoThue='" + data.MaSoThue + "',SoGiayPhepDKKD='" + data.SoGiayPhepDKKD + "',MacDinh=" + data.MacDinh + ",TenNguoiDaiDien=N'" + data.TenNguoiDaiDien + "' where NCC_ID=" + data.NCC_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 : DAOUnit ->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ệ : DAOUnit ->Update : " + e.Message);
}
}
public string Delete(DTONCC data)
{
try
{
DAONCC daoUnit = new DAONCC();
return(daoUnit.Delete(data));
}
catch (Exception e)
{
return("Lỗi ngoại lệ: BUSUnit -> Delete: " + e.Message);
}
}
public string Insert(ref DTONCC data)
{
try
{
DAONCC daoUnit = new DAONCC();
return(daoUnit.Insert(ref data));
}
catch (Exception e)
{
return(@"Lỗi ngoại lệ : BUSUnit -> Insert : " + e.Message);
}
}
public string Insert(ref DTONCC data)
{
try
{
string connect = Provider.Connecting();
SqlConnection con = new SqlConnection(connect);
con.Open();
SqlTransaction sqlTransaction = con.BeginTransaction();
string query = @"insert into dbo_NCC(NCC_Name,DiaChi,Email,SDT,Fax,MaSoThue,SoGiayPhepDKKD,MacDinh) values(N'" + data.NCC_Name + "',N'" + data.DiaChi + "','" + data.Email + "','" + data.SDT + "','" + data.Fax + "','" + data.MaSoThue + "','" + data.SoGiayPhepDKKD + "'," + 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_NCC')";
SqlCommand cmdID = new SqlCommand(query, con);
cmdID.CommandType = CommandType.Text;
cmdID.Transaction = sqlTransaction;
object id = cmdID.ExecuteScalar();
data.NCC_ID = id.ToString();
if (result > 0)
{
sqlTransaction.Commit();
}
else
{
sqlTransaction.Rollback();
sqlTransaction.Dispose();
con.Close();
return("Lỗi số 2 : DAOUnit -> Insert : Lấy mã đơn vị tính lỗi");
}
}
else
{
sqlTransaction.Rollback();
sqlTransaction.Dispose();
con.Close();
return(@"Lỗi số 1 : DAOUnit ->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ệ: DAOUnit -> Insert: " + e.Message);
}
}
