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