public ActionResult ViewGroup() { ViewGroupModel ObjViewGroupModel = new ViewGroupModel(); try { //initial set of current page, pageSize , Total pages ObjViewGroupModel.CurrentPage = 1; ObjViewGroupModel.PageSize = CommonUtils.PageSize; ObjViewGroupModel.TotalPages = 0; //Get Group List serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Group + "/GetGroupList", ObjViewGroupModel); ObjViewGroupModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewGroupModel>().Result : null; //ObjViewGroupModel = objBLGroup.GetGroupList(ObjViewGroupModel); //Set Success Message if comes from save page after click on save button if (!String.IsNullOrEmpty(Convert.ToString(TempData["SucessMessage"]))) { ObjViewGroupModel.Message = Convert.ToString(TempData["SucessMessage"]); ObjViewGroupModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower(); TempData["SucessMessage"] = null; } } catch (Exception ex) { ErrorLog(ex, "Group", "View GET"); } return(View("ViewGroup", ObjViewGroupModel)); }
/// <summary> /// Delete Sub Category /// </summary> /// <param name="objViewSubCategoryModel"></param> /// <returns></returns> public ViewGroupModel DeleteGroup(ViewGroupModel objViewGroupModel) { try { SqlParameter pErrorCode = new SqlParameter("@ErrorCode", objViewGroupModel.ErrorCode); pErrorCode.Direction = ParameterDirection.Output; SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", objViewGroupModel.Message); pErrorMessage.Direction = ParameterDirection.Output; SqlParameter[] parmList = { new SqlParameter("@GroupID", objViewGroupModel.DeletedGroupID) , new SqlParameter("@CreatedBy", objViewGroupModel.DeletedBy) , pErrorCode , pErrorMessage }; //Call delete stored procedure to delete category SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_DeleteGroup, parmList); //set output parameter error code and error message objViewGroupModel.ErrorCode = Convert.ToInt32(pErrorCode.Value); objViewGroupModel.Message = Convert.ToString(pErrorMessage.Value); return(objViewGroupModel); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get Group List with paging, sorting and searching parameter /// </summary> /// <param name="objViewGroupModel">object of Model ViewGroupModel </param> /// <returns></returns> public DataTable GetGroupList(ViewGroupModel objViewGroupModel) { try { SqlParameter[] parmList = { new SqlParameter("@GroupText", objViewGroupModel.FilterGroupText) , new SqlParameter("@CurrentPage", objViewGroupModel.CurrentPage) , new SqlParameter("@PageSize", objViewGroupModel.PageSize) , new SqlParameter("@SortBy", objViewGroupModel.SortBy) , new SqlParameter("@SortOrder", objViewGroupModel.SortOrder) }; DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetGroupList, parmList); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } return(null); } catch (Exception ex) { throw ex; } }
public ActionResult EditGroup(int groupId) { GroupDTO groupDTO = groupService.GetById(groupId); ViewGroupModel group = new ViewGroupModel(); if (groupDTO != null) { group.Id = groupDTO.Id; group.Name = groupDTO.Name; } return(View(group)); }
/// <summary> /// Get Group List based on paging, searching and sorting parameter /// </summary> /// <param name="objViewGroupModel">object of Model ViewGroupModel</param> /// <returns></returns> public ViewGroupModel GetGroupList(ViewGroupModel objViewGroupModel) { List <GroupModel> lstGroupModel = new List <GroupModel>(); //if FilterGroupName is NULL than set to empty objViewGroupModel.FilterSubCatName = objViewGroupModel.FilterSubCatName ?? String.Empty; //if SortBy is NULL than set to empty objViewGroupModel.SortBy = objViewGroupModel.SortBy ?? String.Empty; //call GetGroupList Method which will retrun datatable of Group DataTable dtGroup = objDLGroup.GetGroupList(objViewGroupModel); //fetch each row of datable foreach (DataRow dr in dtGroup.Rows) { //Convert datarow into Model object and set Model object property GroupModel itemGroupModel = GetDataRowToEntity <GroupModel>(dr); //Add Group in List lstGroupModel.Add(itemGroupModel); } //set Group List of Model ViewGroupModel objViewGroupModel.GroupList = lstGroupModel; //if Group List count is not null and greater than 0 Than set Total Pages for Paging. if (objViewGroupModel != null && objViewGroupModel.GroupList != null && objViewGroupModel.GroupList.Count > 0) { objViewGroupModel.CurrentPage = objViewGroupModel.GroupList[0].CurrentPage; int totalRecord = objViewGroupModel.GroupList[0].TotalCount; if (decimal.Remainder(totalRecord, objViewGroupModel.PageSize) > 0) { objViewGroupModel.TotalPages = (totalRecord / objViewGroupModel.PageSize + 1); } else { objViewGroupModel.TotalPages = totalRecord / objViewGroupModel.PageSize; } } else { objViewGroupModel.TotalPages = 0; objViewGroupModel.CurrentPage = 1; } return(objViewGroupModel); }
public ActionResult EditGroup(ViewGroupModel group) { int flag = 0; foreach (var item in groupService.GetAll()) { if (item.Name.Equals(group.Name)) { flag++; break; } } if (flag > 0 && group.Id == 0) { ModelState.AddModelError("", "Такая группа уже существует"); } if (ModelState.IsValid) { if (group.Id == 0) { groupService.Create(new GroupDTO { Id = group.Id, Name = group.Name }); TempData["message"] = string.Format("Добавление группы \"{0}\" выполнено успешно", group.Name); } else { GroupDTO newGroup = groupService.GetById(group.Id); if (newGroup != null) { newGroup.Name = group.Name; groupService.Update(newGroup); TempData["message"] = string.Format("Обновление группы \"{0}\" выполнено успешно", group.Name); } } return(RedirectToAction("AdminPanel", new { result = "groups" })); } return(View()); }
public ActionResult ViewGroup(ViewGroupModel objViewGroupModel) { try { int ErrorCode = 0; String ErrorMessage = ""; objViewGroupModel.Message = objViewGroupModel.MessageType = String.Empty; if (objViewGroupModel.ActionType == "delete") { //delete serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Group + "/DeleteGroup", objViewGroupModel); objViewGroupModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewGroupModel>().Result : null; if (Convert.ToInt32(ErrorCode).Equals(0)) { //if error code 0 means delete successfully than set Delete success message. objViewGroupModel.Message = "Group Deleted Successfully"; objViewGroupModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower(); } else { //if error code is not 0 means delete error than set Delete error message. objViewGroupModel.Message = "Error while deleting record"; objViewGroupModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();; } } //Get Group List based on searching , sorting and paging parameter. serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Group + "/GetGroupList", objViewGroupModel); objViewGroupModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewGroupModel>().Result : null; } catch (Exception ex) { ErrorLog(ex, "Group", "View POST"); } return(PartialView("_GroupList", objViewGroupModel)); }
public ViewGroupModel GetGroupList(ViewGroupModel objViewGroupModel) { return(objBLGroup.GetGroupList(objViewGroupModel)); }
public ViewGroupModel DeleteGroup(ViewGroupModel objViewGroupModel) { return(objBLGroup.DeleteGroup(objViewGroupModel)); }