/// <summary>
/// Delete StepDocMapped
/// </summary>
/// <param name="objViewSubCategoryModel"></param>
/// <returns></returns>
public ViewStepDocMappedModel DeleteStepDocMapped(ViewStepDocMappedModel objViewStepDocMappedModel)
{
try
{
SqlParameter pErrorCode = new SqlParameter("@ErrorCode", objViewStepDocMappedModel.ErrorCode);
pErrorCode.Direction = ParameterDirection.Output;
SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", objViewStepDocMappedModel.Message);
pErrorMessage.Direction = ParameterDirection.Output;
SqlParameter[] parmList =
{
new SqlParameter("@StepDocMappedID", objViewStepDocMappedModel.DeletedStepDocMappedID)
, new SqlParameter("@CreatedBy", objViewStepDocMappedModel.DeletedBy)
, pErrorCode
, pErrorMessage
};
//Call delete stored procedure to delete category
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.ADMIN_DELETESTEPDOCMAPPED, parmList);
//set output parameter error code and error message
objViewStepDocMappedModel.ErrorCode = Convert.ToInt32(pErrorCode.Value);
objViewStepDocMappedModel.Message = Convert.ToString(pErrorMessage.Value);
return(objViewStepDocMappedModel);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get StepDocMapped List based on paging, searching and sorting parameter
/// </summary>
/// <param name="objViewStepDocMappedModel">object of Model ViewStepDocMappedModel</param>
/// <returns></returns>
public ViewStepDocMappedModel GetStepDocMappedList(int StepID, int DocumentID)
{
ViewStepDocMappedModel objViewStepDocMappedModel = new ViewStepDocMappedModel();
objViewStepDocMappedModel.StepDocMappedList = new List <StepDocMappedModel>();
//call GetStepDocMappedList Method which will retrun datatable of StepDocMapped
DataTable dtStepDocMapped = objDLStepDocMapped.GetStepDocMappedByDocumentID(StepID, DocumentID);
//fetch each row of datable
foreach (DataRow dr in dtStepDocMapped.Rows)
{
//Convert datarow into Model object and set Model object property
StepDocMappedModel itemStepDocMappedModel = GetDataRowToEntity <StepDocMappedModel>(dr);
//Add StepDocMapped in List
objViewStepDocMappedModel.StepDocMappedList.Add(itemStepDocMappedModel);
}
return(objViewStepDocMappedModel);
}
public ViewStepDocMappedModel DeleteStepDocMapped(ViewStepDocMappedModel objViewStepDocMappedModel)
{
return(objBLStepDocMapped.DeleteStepDocMapped(objViewStepDocMappedModel));
}
