public DataTable EventReview_I(EventReviewBase PictureBase)
{
dtContainer = new DataTable();
try
{
MyParameter[] myParams =
{
new MyParameter("@EventID", PictureBase.EventID),
new MyParameter("@Description", PictureBase.Description),
new MyParameter("@ReviewTable", PictureBase.ReviewTable),
new MyParameter("@ReviewID", PictureBase.EventReviewID),
new MyParameter("@ItemNumber", PictureBase.ItemNumber),
new MyParameter("@ReplacedBy", PictureBase.Replaced),
new MyParameter("@FromHoursMinutes", PictureBase.ReviewFrom),
new MyParameter("@ToHoursMinutes", PictureBase.ReviewTo),
new MyParameter("@Reason", PictureBase.Reason),
};
Common.Set_Procedures("EventReview_I");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public ActionResult EventReview_I(EventReviewBase PictureBase)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = EventDL.EventReview_I(PictureBase);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
}
return(actionResult);
}
public ActionResult EventReview_DeleteById(EventReviewBase EventBase)
{
try
{
actionResult.dtResult = EventDL.EventReview_DeleteById(EventBase);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
ErrorReporting.ActionLayerError(ex);
}
return(actionResult);
}
public ActionResult Review_LoadById(EventReviewBase EventBase)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = EventDL.Review_LoadById(EventBase);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
}
return(actionResult);
}
public DataTable EventReview_DeleteById(EventReviewBase EventBase)
{
dtContainer = new DataTable();
try
{
MyParameter[] myParams =
{
new MyParameter("@EventReviewID", EventBase.EventReviewID)
};
Common.Set_Procedures("EventReview_DeleteById");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
ErrorReporting.DataLayerError(ex);
}
return(dtContainer);
}
public DataTable Review_LoadById(EventReviewBase EventBase)
{
dtContainer = new DataTable();
try
{
MyParameter[] myParams =
{
new MyParameter("@EventID", EventBase.EventID)
};
Common.Set_Procedures("Review_LoadById");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}