public int themDanhSachKhachHang(dtoKhachHang dtoKhachHang)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@MA_KH", dtoKhachHang.MA_KH),
new SqlParameter("@TEN_CR", dtoKhachHang.TEN_CR),
new SqlParameter("@TEN_CD", dtoKhachHang.TEN_CD),
new SqlParameter("@DIACHI_CR", dtoKhachHang.DIACHI_CR),
new SqlParameter("@DIACHI_CD", dtoKhachHang.DIACHI_CD),
new SqlParameter("@SDT_CR", dtoKhachHang.SDT_CR),
new SqlParameter("@SDT_CD", dtoKhachHang.SDT_CD),
new SqlParameter("@CMND_CR", dtoKhachHang.CMND_CR),
new SqlParameter("@CMND_CD", dtoKhachHang.CMND_CD),
new SqlParameter("@NGAYSINH_CR", dtoKhachHang.NGAYSINH_CR),
new SqlParameter("@NGAYSINH_CD", dtoKhachHang.NGAYSINH_CD)
};
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(Constants.ConnectionString, "themDanhSachKhachHang", parameters)));
}
catch (SqlException)
{
throw new ArgumentException(Constants.MsgExceptionTonTaiMauTin);
}
catch (Exception)
{
throw new ArgumentException(Constants.MsgExceptionTruyCapLoi);
}
}
/// <summary>
/// Lấy khách hàng theo cmnd
/// </summary>
/// <param name="CMND"></param>
/// <returns></returns>
public dtoKhachHang LayTheoCMNDKhachHang(string CMND)
{
dtoKhachHang result = null;
string query = "USP_getKhachHangbyMAKH @MAKH";
DataTable data = DataProvider.Instance.ExecuteQuery(query, new object[] { CMND });
foreach (DataRow item in data.Rows)
{
result = new dtoKhachHang(item);
}
return(result);
}
public void luuDanhSachKhachHang(DataTable dt)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
foreach (DataRow dRow in dt.Rows)
{
switch (dRow.RowState)
{
case DataRowState.Added:
dtoKhachHang dtoKhachHang = new dtoKhachHang()
{
MA_KH = dRow["MA_KH"].ToString(),
TEN_CR = dRow["TEN_CR"].ToString(),
TEN_CD = dRow["TEN_CD"].ToString(),
DIACHI_CR = dRow["DIACHI_CR"].ToString(),
DIACHI_CD = dRow["DIACHI_CD"].ToString(),
SDT_CR = dRow["SDT_CR"].ToString(),
SDT_CD = dRow["SDT_CD"].ToString(),
CMND_CR = dRow["CMND_CR"].ToString(),
CMND_CD = dRow["CMND_CD"].ToString(),
NGAYSINH_CR = dRow["NGAYSINH_CR"].ToString(),
NGAYSINH_CD = dRow["NGAYSINH_CD"].ToString()
};
dalKhachHang.themDanhSachKhachHang(dtoKhachHang);
break;
case DataRowState.Modified:
dtoKhachHang dtoKhachHang1 = new dtoKhachHang()
{
MA_KH = dRow["MA_KH"].ToString(),
TEN_CR = dRow["TEN_CR"].ToString(),
TEN_CD = dRow["TEN_CD"].ToString(),
DIACHI_CR = dRow["DIACHI_CR"].ToString(),
DIACHI_CD = dRow["DIACHI_CD"].ToString(),
SDT_CR = dRow["SDT_CR"].ToString(),
SDT_CD = dRow["SDT_CD"].ToString(),
CMND_CR = dRow["CMND_CR"].ToString(),
CMND_CD = dRow["CMND_CD"].ToString(),
NGAYSINH_CR = dRow["NGAYSINH_CR"].ToString(),
NGAYSINH_CD = dRow["NGAYSINH_CD"].ToString()
};
dalKhachHang.suaDanhSachKhachHang(dtoKhachHang1);
break;
case DataRowState.Deleted:
string MA_KH = dRow["MA_KH", DataRowVersion.Original].ToString();
dalKhachHang.xoaKhachHang(MA_KH);
break;
}
}
dt.AcceptChanges();
scope.Complete();
}
}
catch (ArgumentException ex)
{
throw ex;
}
catch (TransactionAbortedException)
{
throw new ArgumentException(Constants.MsgExceptionLuuLoi);
}
catch (ApplicationException)
{
throw new ArgumentException(Constants.MsgExceptionLoiChung);
}
}
