public ActionResult ViewMaster()
{
ViewMasterModel ObjViewMasterModel = new ViewMasterModel();
try
{
//initial set of current page, pageSize , Total pages
ObjViewMasterModel.CurrentPage = 1;
ObjViewMasterModel.PageSize = CommonUtils.PageSize;
ObjViewMasterModel.TotalPages = 0;
//Get Master List
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Master + "/GetMasterList", ObjViewMasterModel);
ObjViewMasterModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewMasterModel>().Result : null;
//ObjViewMasterModel = objBLMaster.GetMasterList(ObjViewMasterModel);
//Set Success Message if comes from save page after click on save button
if (!String.IsNullOrEmpty(Convert.ToString(TempData["SucessMessage"])))
{
ObjViewMasterModel.Message = Convert.ToString(TempData["SucessMessage"]);
ObjViewMasterModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
TempData["SucessMessage"] = null;
}
}
catch (Exception ex)
{
ErrorLog(ex, "Master", "View GET");
}
return(View("ViewMaster", ObjViewMasterModel));
}
/// <summary>
/// Delete Sub Category
/// </summary>
/// <param name="objViewSubCategoryModel"></param>
/// <returns></returns>
public ViewMasterModel DeleteMaster(ViewMasterModel objViewMasterModel)
{
try
{
SqlParameter pErrorCode = new SqlParameter("@ErrorCode", objViewMasterModel.ErrorCode);
pErrorCode.Direction = ParameterDirection.Output;
SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", objViewMasterModel.Message);
pErrorMessage.Direction = ParameterDirection.Output;
SqlParameter[] parmList =
{
new SqlParameter("@MasterID", objViewMasterModel.DeletedMasterID)
, new SqlParameter("@CreatedBy", objViewMasterModel.DeletedBy)
, pErrorCode
, pErrorMessage
};
//Call delete stored procedure to delete category
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_DeleteMaster, parmList);
//set output parameter error code and error message
objViewMasterModel.ErrorCode = Convert.ToInt32(pErrorCode.Value);
objViewMasterModel.Message = Convert.ToString(pErrorMessage.Value);
return(objViewMasterModel);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get Master List with paging, sorting and searching parameter
/// </summary>
/// <param name="objViewMasterModel">object of Model ViewMasterModel </param>
/// <returns></returns>
public DataTable GetMasterList(ViewMasterModel objViewMasterModel)
{
try
{
SqlParameter[] parmList =
{
new SqlParameter("@MasterValue", objViewMasterModel.FilterMasterText)
, new SqlParameter("@CurrentPage", objViewMasterModel.CurrentPage)
, new SqlParameter("@PageSize", objViewMasterModel.PageSize)
, new SqlParameter("@SortBy", objViewMasterModel.SortBy)
, new SqlParameter("@SortOrder", objViewMasterModel.SortOrder)
};
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetMasterList, parmList);
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get Master List based on paging, searching and sorting parameter
/// </summary>
/// <param name="objViewMasterModel">object of Model ViewMasterModel</param>
/// <returns></returns>
public ViewMasterModel GetMasterList(ViewMasterModel objViewMasterModel)
{
List <MasterModel> lstMasterModel = new List <MasterModel>();
//if FilterMasterName is NULL than set to empty
objViewMasterModel.FilterSubCatName = objViewMasterModel.FilterSubCatName ?? String.Empty;
//if SortBy is NULL than set to empty
objViewMasterModel.SortBy = objViewMasterModel.SortBy ?? String.Empty;
//call GetMasterList Method which will retrun datatable of Master
DataTable dtMaster = objDLMaster.GetMasterList(objViewMasterModel);
//fetch each row of datable
foreach (DataRow dr in dtMaster.Rows)
{
//Convert datarow into Model object and set Model object property
MasterModel itemMasterModel = GetDataRowToEntity <MasterModel>(dr);
//Add Master in List
lstMasterModel.Add(itemMasterModel);
}
//set Master List of Model ViewMasterModel
objViewMasterModel.MasterList = lstMasterModel;
//if Master List count is not null and greater than 0 Than set Total Pages for Paging.
if (objViewMasterModel != null && objViewMasterModel.MasterList != null && objViewMasterModel.MasterList.Count > 0)
{
objViewMasterModel.CurrentPage = objViewMasterModel.MasterList[0].CurrentPage;
int totalRecord = objViewMasterModel.MasterList[0].TotalCount;
if (decimal.Remainder(totalRecord, objViewMasterModel.PageSize) > 0)
{
objViewMasterModel.TotalPages = (totalRecord / objViewMasterModel.PageSize + 1);
}
else
{
objViewMasterModel.TotalPages = totalRecord / objViewMasterModel.PageSize;
}
}
else
{
objViewMasterModel.TotalPages = 0;
objViewMasterModel.CurrentPage = 1;
}
return(objViewMasterModel);
}
public ActionResult ViewMaster(ViewMasterModel objViewMasterModel)
{
try
{
int ErrorCode = 0;
String ErrorMessage = "";
objViewMasterModel.Message = objViewMasterModel.MessageType = String.Empty;
if (objViewMasterModel.ActionType == "delete")
{
//delete
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Master + "/DeleteMaster", objViewMasterModel);
objViewMasterModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewMasterModel>().Result : null;
if (Convert.ToInt32(ErrorCode).Equals(0))
{
//if error code 0 means delete successfully than set Delete success message.
objViewMasterModel.Message = "Master Deleted Successfully";
objViewMasterModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
}
else
{
//if error code is not 0 means delete error than set Delete error message.
objViewMasterModel.Message = "Error while deleting record";
objViewMasterModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();;
}
}
//Get Master List based on searching , sorting and paging parameter.
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Master + "/GetMasterList", objViewMasterModel);
objViewMasterModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewMasterModel>().Result : null;
}
catch (Exception ex)
{
ErrorLog(ex, "Master", "View POST");
}
return(PartialView("_MasterList", objViewMasterModel));
}
public ViewMasterModel GetMasterList(ViewMasterModel objViewMasterModel)
{
return(objBLMaster.GetMasterList(objViewMasterModel));
}
public ViewMasterModel DeleteMaster(ViewMasterModel objViewMasterModel)
{
return(objBLMaster.DeleteMaster(objViewMasterModel));
}