public void luuDanhSachDichVu(DataTable dt) { try { using (TransactionScope scope = new TransactionScope()) { foreach (DataRow dRow in dt.Rows) { switch (dRow.RowState) { case DataRowState.Added: dtoDichVu dtoDichVu = new dtoDichVu() { MA_DV = dRow["MA_DV"].ToString(), TENDV = dRow["TENDV"].ToString(), GIADV = dRow["GIADV"].ToString() }; dalDichVu.themDanhSachDichVu(dtoDichVu); break; case DataRowState.Modified: dtoDichVu dtoDichVu1 = new dtoDichVu() { MA_DV = dRow["MA_DV"].ToString(), TENDV = dRow["TENDV"].ToString(), GIADV = dRow["GIADV"].ToString() }; dalDichVu.suaDanhSachDichVu(dtoDichVu1); break; case DataRowState.Deleted: string MA_DV = dRow["MA_DV", DataRowVersion.Original].ToString(); dalDichVu.xoaDichVu(MA_DV); 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 themDanhSachDichVu(dtoDichVu dtoDichVu) { try { SqlParameter[] parameters = { new SqlParameter("@MA_DV", dtoDichVu.MA_DV), new SqlParameter("@TENCA", dtoDichVu.TENDV), new SqlParameter("@GIADV", dtoDichVu.GIADV) }; return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(Constants.ConnectionString, "themDanhSachDichVu", parameters))); } catch (SqlException) { throw new ArgumentException(Constants.MsgExceptionTonTaiMauTin); } catch (Exception) { throw new ArgumentException(Constants.MsgExceptionTruyCapLoi); } }