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));
}
