public int themDanhSachNguoiDung(dtoNguoiDung dtoNguoiDung)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@MA_ND", dtoNguoiDung.MA_ND),
new SqlParameter("@MA_LND", dtoNguoiDung.MA_LND),
new SqlParameter("@TEN_ND", dtoNguoiDung.TEN_ND),
new SqlParameter("@DIACHI", dtoNguoiDung.DIACHI),
new SqlParameter("@SODIENTHOAI", dtoNguoiDung.SODIENTHOAI),
new SqlParameter("@CMND", dtoNguoiDung.CMND),
new SqlParameter("@NGAYSINH", dtoNguoiDung.NGAYSINH),
new SqlParameter("@NGAYVAOLAM", dtoNguoiDung.NGAYVAOLAM),
new SqlParameter("@TENDANGNHAP", dtoNguoiDung.TENDANGNHAP),
new SqlParameter("@PASS", dtoNguoiDung.PASS),
};
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(Constants.ConnectionString, "themDanhSachNguoiDung", parameters)));
}
catch (SqlException)
{
throw new ArgumentException(Constants.MsgExceptionTonTaiMauTin);
}
catch (Exception)
{
throw new ArgumentException(Constants.MsgExceptionTruyCapLoi);
}
}
public void luuDanhSachNguoiDung(DataTable dt)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
foreach (DataRow dRow in dt.Rows)
{
switch (dRow.RowState)
{
case DataRowState.Added:
dtoNguoiDung dtoNguoiDung = new dtoNguoiDung()
{
MA_ND = dRow["MA_ND"].ToString(),
MA_LND = dRow["MA_LND"].ToString(),
TEN_ND = dRow["TEN_ND"].ToString(),
DIACHI = dRow["DIACHI"].ToString(),
SODIENTHOAI = dRow["SODIENTHOAI"].ToString(),
CMND = dRow["CMND"].ToString(),
NGAYSINH = dRow["NGAYSINH"].ToString(),
NGAYVAOLAM = dRow["NGAYVAOLAM"].ToString(),
TENDANGNHAP = dRow["TENDANGNHAP"].ToString(),
PASS = dRow["PASS"].ToString()
};
dalNguoiDung.themDanhSachNguoiDung(dtoNguoiDung);
break;
case DataRowState.Modified:
dtoNguoiDung dtoNguoiDung1 = new dtoNguoiDung()
{
MA_ND = dRow["MA_ND"].ToString(),
MA_LND = dRow["MA_LND"].ToString(),
TEN_ND = dRow["TEN_ND"].ToString(),
DIACHI = dRow["DIACHI"].ToString(),
SODIENTHOAI = dRow["SODIENTHOAI"].ToString(),
CMND = dRow["CMND"].ToString(),
NGAYSINH = dRow["NGAYSINH"].ToString(),
NGAYVAOLAM = dRow["NGAYVAOLAM"].ToString(),
TENDANGNHAP = dRow["TENDANGNHAP"].ToString(),
PASS = dRow["PASS"].ToString()
};
dalNguoiDung.suaDanhSachNguoiDung(dtoNguoiDung1);
break;
case DataRowState.Deleted:
string MA_ND = dRow["MA_ND", DataRowVersion.Original].ToString();
dalNguoiDung.xoaNguoiDung(MA_ND);
break;
}
}
dt.AcceptChanges();
scope.Complete();
}
}
catch (ArgumentException ex)
{
throw ex;
}
catch (TransactionAbortedException)
{
throw new ArgumentException(Constants.MsgExceptionLuuLoi);
}
catch (ApplicationException)
{
throw new ArgumentException(Constants.MsgExceptionLoiChung);
}
}
