public ActionResult ViewStep()
{
ViewStepModel ObjViewStepModel = new ViewStepModel();
try
{
//initial set of current page, pageSize , Total pages
ObjViewStepModel.CurrentPage = 1;
ObjViewStepModel.PageSize = CommonUtils.PageSize;
ObjViewStepModel.TotalPages = 0;
//Get Step List
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Step + "/GetStepList", ObjViewStepModel);
ObjViewStepModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewStepModel>().Result : null;
//ObjViewStepModel = objBLStep.GetStepList(ObjViewStepModel);
//Set Success Message if comes from save page after click on save button
if (!String.IsNullOrEmpty(Convert.ToString(TempData["SucessMessage"])))
{
ObjViewStepModel.Message = Convert.ToString(TempData["SucessMessage"]);
ObjViewStepModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
TempData["SucessMessage"] = null;
}
}
catch (Exception ex)
{
ErrorLog(ex, "Step", "View GET");
}
return(View("ViewStep", ObjViewStepModel));
}
/// <summary>
/// Delete Sub Category
/// </summary>
/// <param name="objViewSubCategoryModel"></param>
/// <returns></returns>
public ViewStepModel DeleteStep(ViewStepModel objViewStepModel)
{
try
{
SqlParameter pErrorCode = new SqlParameter("@ErrorCode", objViewStepModel.ErrorCode);
pErrorCode.Direction = ParameterDirection.Output;
SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", objViewStepModel.Message);
pErrorMessage.Direction = ParameterDirection.Output;
SqlParameter[] parmList =
{
new SqlParameter("@StepID", objViewStepModel.DeletedStepID)
, new SqlParameter("@CreatedBy", objViewStepModel.DeletedBy)
, pErrorCode
, pErrorMessage
};
//Call delete stored procedure to delete category
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_DeleteStep, parmList);
//set output parameter error code and error message
objViewStepModel.ErrorCode = Convert.ToInt32(pErrorCode.Value);
objViewStepModel.Message = Convert.ToString(pErrorMessage.Value);
return(objViewStepModel);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get Step List with paging, sorting and searching parameter
/// </summary>
/// <param name="objViewStepModel">object of Model ViewStepModel </param>
/// <returns></returns>
public DataTable GetStepList(ViewStepModel objViewStepModel)
{
try
{
SqlParameter[] parmList =
{
new SqlParameter("@StepText", objViewStepModel.FilterStepName)
, new SqlParameter("@CurrentPage", objViewStepModel.CurrentPage)
, new SqlParameter("@PageSize", objViewStepModel.PageSize)
, new SqlParameter("@SortBy", objViewStepModel.SortBy)
, new SqlParameter("@SortOrder", objViewStepModel.SortOrder)
};
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetStepList, parmList);
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get Step List based on paging, searching and sorting parameter
/// </summary>
/// <param name="objViewStepModel">object of Model ViewStepModel</param>
/// <returns></returns>
public ViewStepModel GetStepList(ViewStepModel objViewStepModel)
{
List <StepModel> lstStepModel = new List <StepModel>();
//if FilterStepName is NULL than set to empty
objViewStepModel.FilterSubCatName = objViewStepModel.FilterSubCatName ?? String.Empty;
//if SortBy is NULL than set to empty
objViewStepModel.SortBy = objViewStepModel.SortBy ?? String.Empty;
//call GetStepList Method which will retrun datatable of Step
DataTable dtStep = objDLStep.GetStepList(objViewStepModel);
//fetch each row of datable
foreach (DataRow dr in dtStep.Rows)
{
//Convert datarow into Model object and set Model object property
StepModel itemStepModel = GetDataRowToEntity <StepModel>(dr);
//Add Step in List
lstStepModel.Add(itemStepModel);
}
//set Step List of Model ViewStepModel
objViewStepModel.StepList = lstStepModel;
//if Step List count is not null and greater than 0 Than set Total Pages for Paging.
if (objViewStepModel != null && objViewStepModel.StepList != null && objViewStepModel.StepList.Count > 0)
{
objViewStepModel.CurrentPage = objViewStepModel.StepList[0].CurrentPage;
int totalRecord = objViewStepModel.StepList[0].TotalCount;
if (decimal.Remainder(totalRecord, objViewStepModel.PageSize) > 0)
{
objViewStepModel.TotalPages = (totalRecord / objViewStepModel.PageSize + 1);
}
else
{
objViewStepModel.TotalPages = totalRecord / objViewStepModel.PageSize;
}
}
else
{
objViewStepModel.TotalPages = 0;
objViewStepModel.CurrentPage = 1;
}
return(objViewStepModel);
}
public ActionResult ViewStep(ViewStepModel objViewStepModel)
{
try
{
int ErrorCode = 0;
String ErrorMessage = "";
objViewStepModel.Message = objViewStepModel.MessageType = String.Empty;
if (objViewStepModel.ActionType == "delete")
{
//delete
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Step + "/DeleteStep", objViewStepModel);
objViewStepModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewStepModel>().Result : null;
if (Convert.ToInt32(ErrorCode).Equals(0))
{
//if error code 0 means delete successfully than set Delete success message.
objViewStepModel.Message = "Step Deleted Successfully";
objViewStepModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
}
else
{
//if error code is not 0 means delete error than set Delete error message.
objViewStepModel.Message = "Error while deleting record";
objViewStepModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();;
}
}
//Get Step List based on searching , sorting and paging parameter.
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Step + "/GetStepList", objViewStepModel);
objViewStepModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewStepModel>().Result : null;
}
catch (Exception ex)
{
ErrorLog(ex, "Step", "View POST");
}
return(PartialView("_StepList", objViewStepModel));
}
/// <summary>
/// Delete Step by Step ID
/// </summary>
/// <param name="objViewStepModel"></param>
/// <param name="createdBy"></param>
/// <param name="errorCode"></param>
/// <param name="errorMessage"></param>
public ViewStepModel DeleteStep(ViewStepModel objViewStepModel)
{
return(objDLStep.DeleteStep(objViewStepModel));
}
public ViewStepModel GetStepList(ViewStepModel objViewStepModel)
{
return(objBLStep.GetStepList(objViewStepModel));
}
