public void luuDanhSachMonAn(DataTable dt) { try { using (TransactionScope scope = new TransactionScope()) { foreach (DataRow dRow in dt.Rows) { switch (dRow.RowState) { case DataRowState.Added: dtoDSMonAn dtoDSMonAn = new dtoDSMonAn() { MA_MONAN = dRow["MA_MONAN"].ToString(), TENMONAN = dRow["TENMONAN"].ToString(), DONGIA = dRow["DONGIA"].ToString(), GHICHU = dRow["GHICHU"].ToString() }; dalDSMonAn.themDanhSachMonAn(dtoDSMonAn); break; case DataRowState.Modified: dtoDSMonAn dtoDSMonAn1 = new dtoDSMonAn() { MA_MONAN = dRow["MA_MONAN"].ToString(), TENMONAN = dRow["TENMONAN"].ToString(), DONGIA = dRow["DONGIA"].ToString(), GHICHU = dRow["GHICHU"].ToString() }; dalDSMonAn.suaDanhSachMonAn(dtoDSMonAn1); break; case DataRowState.Deleted: string MA_MONAN = dRow["MA_MONAN", DataRowVersion.Original].ToString(); dalDSMonAn.xoaMonAn(MA_MONAN); 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 themDanhSachMonAn(dtoDSMonAn dtoDSMonAn) { try { SqlParameter[] parameters = { new SqlParameter("@MA_MONAN", dtoDSMonAn.MA_MONAN), new SqlParameter("@TENMONAN", dtoDSMonAn.TENMONAN), new SqlParameter("@DONGIA", dtoDSMonAn.DONGIA), new SqlParameter("GHICHU", dtoDSMonAn.GHICHU) }; return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(Constants.ConnectionString, "themDanhSachMonAn", parameters))); } catch (SqlException) { throw new ArgumentException(Constants.MsgExceptionTonTaiMauTin); } catch (Exception) { throw new ArgumentException(Constants.MsgExceptionTruyCapLoi); } }