public void luuDanhSachLoaiNguoiDung(DataTable dt) { try { using (TransactionScope scope = new TransactionScope()) { foreach (DataRow dRow in dt.Rows) { switch (dRow.RowState) { case DataRowState.Added: dtoLoaiNguoiDung dtoLoaiNguoiDung = new dtoLoaiNguoiDung() { MA_LND = dRow["MA_LND"].ToString(), TENLOAINGUOIDUNG = dRow["TENLOAINGUOIDUNG"].ToString(), MOTA = dRow["MOTA"].ToString() }; dalLoaiNguoiDung.themDanhSachLoaiNguoiDung(dtoLoaiNguoiDung); break; case DataRowState.Modified: dtoLoaiNguoiDung dtoLoaiNguoiDung1 = new dtoLoaiNguoiDung() { MA_LND = dRow["MA_LND"].ToString(), TENLOAINGUOIDUNG = dRow["TENLOAINGUOIDUNG"].ToString(), MOTA = dRow["MOTA"].ToString() }; dalLoaiNguoiDung.suaDanhSachLoaiNguoiDung(dtoLoaiNguoiDung1); break; case DataRowState.Deleted: string MA_LND = dRow["MA_LND", DataRowVersion.Original].ToString(); dalLoaiNguoiDung.xoaLoaiNguoiDung(MA_LND); break; } } dt.AcceptChanges(); scope.Complete(); } } catch (ArgumentException ex) { throw ex; } catch (TransactionAbortedException) { throw new ArgumentException(Constants.MsgExceptionLuuLoi); } catch (ApplicationException) { throw new ArgumentException(Constants.MsgExceptionLoiChung); } }
public int themDanhSachLoaiNguoiDung(dtoLoaiNguoiDung dtoLoaiNguoiDung) { try { SqlParameter[] parameters = { new SqlParameter("@MA_LND", dtoLoaiNguoiDung.MA_LND), new SqlParameter("@TENLOAINGUOIDUNG", dtoLoaiNguoiDung.TENLOAINGUOIDUNG), new SqlParameter("MOTA", dtoLoaiNguoiDung.MOTA) }; return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(Constants.ConnectionString, "themDanhSachLoaiNguoiDung", parameters))); } catch (SqlException) { throw new ArgumentException(Constants.MsgExceptionTonTaiMauTin); } catch (Exception) { throw new ArgumentException(Constants.MsgExceptionTruyCapLoi); } }