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