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