/// <summary> /// Delete Sub Category /// </summary> /// <param name="objViewSubCategoryModel"></param> /// <returns></returns> public ViewSubCategoryModel DeleteSubCategory(ViewSubCategoryModel objViewSubCategoryModel) { try { SqlParameter pErrorCode = new SqlParameter("@ErrorCode", objViewSubCategoryModel.ErrorCode); pErrorCode.Direction = ParameterDirection.Output; SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", objViewSubCategoryModel.Message); pErrorMessage.Direction = ParameterDirection.Output; SqlParameter[] parmList = { new SqlParameter("@SubCategoryID", objViewSubCategoryModel.DeletedSubCategoryID) , new SqlParameter("@CreatedBy", objViewSubCategoryModel.DeletedBy) , pErrorCode , pErrorMessage }; //Call delete stored procedure to delete category SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_DeleteSubCategory, parmList); //set output parameter error code and error message objViewSubCategoryModel.ErrorCode = Convert.ToInt32(pErrorCode.Value); objViewSubCategoryModel.Message = Convert.ToString(pErrorMessage.Value); return(objViewSubCategoryModel); } catch (Exception ex) { throw ex; } }
public ActionResult ViewSubCategory() { ViewSubCategoryModel ObjViewSubCategoryModel = new ViewSubCategoryModel(); try { //initial set of current page, pageSize , Total pages ObjViewSubCategoryModel.CurrentPage = 1; ObjViewSubCategoryModel.PageSize = CommonUtils.PageSize; ObjViewSubCategoryModel.TotalPages = 0; //Get SubCategory List serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.SubCategory + "/GetSubCategoryList", ObjViewSubCategoryModel); ObjViewSubCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewSubCategoryModel>().Result : null; //ObjViewSubCategoryModel = objBLSubCategory.GetSubCategoryList(ObjViewSubCategoryModel); //Set Success Message if comes from save page after click on save button if (!String.IsNullOrEmpty(Convert.ToString(TempData["SucessMessage"]))) { ObjViewSubCategoryModel.Message = Convert.ToString(TempData["SucessMessage"]); ObjViewSubCategoryModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower(); TempData["SucessMessage"] = null; } CaegoryDropDown(ObjViewSubCategoryModel.FilterCategoryId); // EmailTyepDropDown(ObjViewSubCategoryModel.FilterCategoryId); GroupDropDown(ObjViewSubCategoryModel.FilterGroupID); } catch (Exception ex) { ErrorLog(ex, "SubCategory", "View GET"); } return(View("ViewSubCategory", ObjViewSubCategoryModel)); }
/// <summary> /// Get SubCategory List with paging, sorting and searching parameter /// </summary> /// <param name="objViewSubCategoryModel">object of Model ViewSubCategoryModel </param> /// <returns></returns> public DataTable GetSubCategoryList(ViewSubCategoryModel objViewSubCategoryModel) { try { SqlParameter[] parmList = { new SqlParameter("@SubCategoryName", objViewSubCategoryModel.FilterSubCatName) , new SqlParameter("@CategoryId", objViewSubCategoryModel.FilterCategoryId) , new SqlParameter("@CurrentPage", objViewSubCategoryModel.CurrentPage) , new SqlParameter("@PageSize", objViewSubCategoryModel.PageSize) , new SqlParameter("@SortBy", objViewSubCategoryModel.SortBy) , new SqlParameter("@SortOrder", objViewSubCategoryModel.SortOrder) }; DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetSubCategoryList, parmList); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } return(null); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get SubCategory List based on paging, searching and sorting parameter /// </summary> /// <param name="objViewSubCategoryModel">object of Model ViewSubCategoryModel</param> /// <returns></returns> public ViewSubCategoryModel GetSubCategoryList(ViewSubCategoryModel objViewSubCategoryModel) { List <SubCategoryModel> lstSubCategoryModel = new List <SubCategoryModel>(); //if FilterSubCategoryName is NULL than set to empty objViewSubCategoryModel.FilterSubCatName = objViewSubCategoryModel.FilterSubCatName ?? String.Empty; //if SortBy is NULL than set to empty objViewSubCategoryModel.SortBy = objViewSubCategoryModel.SortBy ?? String.Empty; //call GetSubCategoryList Method which will retrun datatable of SubCategory DataTable dtSubCategory = objDLSubCategory.GetSubCategoryList(objViewSubCategoryModel); //fetch each row of datable foreach (DataRow dr in dtSubCategory.Rows) { //Convert datarow into Model object and set Model object property SubCategoryModel itemSubCategoryModel = GetDataRowToEntity <SubCategoryModel>(dr); //Add SubCategory in List lstSubCategoryModel.Add(itemSubCategoryModel); } //set SubCategory List of Model ViewSubCategoryModel objViewSubCategoryModel.SubCategoryList = lstSubCategoryModel; //if SubCategory List count is not null and greater than 0 Than set Total Pages for Paging. if (objViewSubCategoryModel != null && objViewSubCategoryModel.SubCategoryList != null && objViewSubCategoryModel.SubCategoryList.Count > 0) { objViewSubCategoryModel.CurrentPage = objViewSubCategoryModel.SubCategoryList[0].CurrentPage; int totalRecord = objViewSubCategoryModel.SubCategoryList[0].TotalCount; if (decimal.Remainder(totalRecord, objViewSubCategoryModel.PageSize) > 0) { objViewSubCategoryModel.TotalPages = (totalRecord / objViewSubCategoryModel.PageSize + 1); } else { objViewSubCategoryModel.TotalPages = totalRecord / objViewSubCategoryModel.PageSize; } } else { objViewSubCategoryModel.TotalPages = 0; objViewSubCategoryModel.CurrentPage = 1; } return(objViewSubCategoryModel); }
public ActionResult ViewSubCategory(ViewSubCategoryModel objViewSubCategoryModel) { try { int ErrorCode = 0; String ErrorMessage = ""; objViewSubCategoryModel.Message = objViewSubCategoryModel.MessageType = String.Empty; if (objViewSubCategoryModel.ActionType == "delete") { //delete serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.SubCategory + "/DeleteSubCategory", objViewSubCategoryModel); objViewSubCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewSubCategoryModel>().Result : null; if (Convert.ToInt32(ErrorCode).Equals(0)) { //if error code 0 means delete successfully than set Delete success message. objViewSubCategoryModel.Message = "SubCategory Deleted Successfully"; objViewSubCategoryModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower(); } else { //if error code is not 0 means delete error than set Delete error message. objViewSubCategoryModel.Message = "Error while deleting record"; objViewSubCategoryModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();; } } //Get SubCategory List based on searching , sorting and paging parameter. serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.SubCategory + "/GetSubCategoryList", objViewSubCategoryModel); objViewSubCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewSubCategoryModel>().Result : null; CaegoryDropDown(objViewSubCategoryModel.FilterCategoryId); GroupDropDown(objViewSubCategoryModel.FilterGroupID); } catch (Exception ex) { ErrorLog(ex, "SubCategory", "View POST"); } return(PartialView("_SubCategoryList", objViewSubCategoryModel)); }
public HomeLayOutModel GetLayOutData() { HomeLayOutModel objHomeLayOutModel = new HomeLayOutModel(); BLCategory objBLCategory = new BLCategory(); BLDocument objBLDocument = new BLDocument(); BLSubCategory objBLSubCategory = new BLSubCategory(); ViewCategoryModel objViewCategoryModel = new ViewCategoryModel(); objViewCategoryModel.CurrentPage = 1; objViewCategoryModel.PageSize = int.MaxValue - 1; objHomeLayOutModel.objViewCategoryModel = new ViewCategoryModel(); objHomeLayOutModel.objViewCategoryModel = objBLCategory.GetCategoryList(objViewCategoryModel); if (objHomeLayOutModel != null && objHomeLayOutModel.objViewCategoryModel != null && objHomeLayOutModel.objViewCategoryModel.CategoryList != null && objHomeLayOutModel.objViewCategoryModel.CategoryList.Count > 0) { for (int i = 0; i < objHomeLayOutModel.objViewCategoryModel.CategoryList.Count; i++) { //string[] DocumentIds = objHomeLayOutModel.objViewCategoryModel.CategoryList[i].QuickLinks.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); //if (DocumentIds != null && DocumentIds.Length > 0) //{ // objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList = new List<DocumentModel>(); // for (int j = 0; j < DocumentIds.Length; j++) // { // objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList.Add(objBLDocument.GetDocumentById(Convert.ToInt32(DocumentIds[j]))); // } //} } } ViewSubCategoryModel objViewSubCategoryModel = new ViewSubCategoryModel(); objViewSubCategoryModel.CurrentPage = 1; objViewSubCategoryModel.PageSize = int.MaxValue - 1; objHomeLayOutModel.objSubViewCategoryModel = new ViewSubCategoryModel(); objHomeLayOutModel.objSubViewCategoryModel = objBLSubCategory.GetSubCategoryList(objViewSubCategoryModel); return(objHomeLayOutModel); }
/// <summary> /// Delete SubCategory by SubCategory ID /// </summary> /// <param name="objViewSubCategoryModel"></param> /// <param name="createdBy"></param> /// <param name="errorCode"></param> /// <param name="errorMessage"></param> public ViewSubCategoryModel DeleteSubCategory(ViewSubCategoryModel objViewSubCategoryModel) { return(objDLSubCategory.DeleteSubCategory(objViewSubCategoryModel)); }
public ViewSubCategoryModel GetSubCategoryList(ViewSubCategoryModel objViewSubCategoryModel) { return(objBLSubCategory.GetSubCategoryList(objViewSubCategoryModel)); }