// lưu danh sách ca public void luuDanhSachca(DataTable dt) { try { using (TransactionScope scope = new TransactionScope()) { foreach (DataRow dRow in dt.Rows) { switch (dRow.RowState) { case DataRowState.Added: dtoCa dtoCa = new dtoCa() { MA_LOAI_CA = dRow["MA_LOAI_CA"].ToString(), TENCA = dRow["TENCA"].ToString() }; dalCa.themDanhSachCa(dtoCa); break; case DataRowState.Modified: dtoCa dtoCa1 = new dtoCa() { MA_LOAI_CA = dRow["MA_LOAI_CA"].ToString(), TENCA = dRow["TENCA"].ToString() }; dalCa.suaDanhSachCa(dtoCa1); break; case DataRowState.Deleted: string MA_LOAI_CA = dRow["MA_LOAI_CA", DataRowVersion.Original].ToString(); dalCa.xoaCa(MA_LOAI_CA); break; } } dt.AcceptChanges(); scope.Complete(); } } catch (ArgumentException ex) { throw ex; } catch (TransactionAbortedException) { throw new ArgumentException(Constants.MsgExceptionLuuLoi); } catch (ApplicationException) { throw new ArgumentException(Constants.MsgExceptionLoiChung); } }
//thêm danh sách ca public int themDanhSachCa(dtoCa dtoCa) { try { SqlParameter[] parameters = { new SqlParameter("@MA_LOAI_CA", dtoCa.MA_LOAI_CA), new SqlParameter("@TENCA", dtoCa.TENCA) }; return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(Constants.ConnectionString, "themDanhSachCa", parameters))); } catch (SqlException) { throw new ArgumentException(Constants.MsgExceptionTonTaiMauTin); } catch (Exception) { throw new ArgumentException(Constants.MsgExceptionTruyCapLoi); } }