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); } }