public string UpdateCollegeGroup(CollegeGroupVM collegeGroup) { string collegeGroupId = string.Empty; SqlParameter[] parameters = { new SqlParameter { ParameterName = "@Id", Value = collegeGroup.Id }, new SqlParameter { ParameterName = "@UserGroupId", Value = collegeGroup.UserGroupId }, new SqlParameter { ParameterName = "@Name", Value = collegeGroup.Name }, new SqlParameter { ParameterName = "@Description", Value = collegeGroup.Description }, new SqlParameter { ParameterName = "@IsActive", Value = collegeGroup.IsActive }, new SqlParameter { ParameterName = "@UpdatedBy", Value = collegeGroup.UpdatedBy } }; collegeGroupId = Convert.ToString(DALHelper.ExecuteScalar("UpdateCollegeGroup", parameters)); return(collegeGroupId); }
public ActionResult Edit(Guid id) { var collegeGroup = collegeGroupRepository.GetCollegeGroupById(id); CollegeGroupVM model = new CollegeGroupVM(); if (collegeGroup != null) { model = collegeGroup; var userGroupList = new SelectList(userGroupRepository.GetUserGroupsWithCurrencyInfo() .Select( m => new SelectListItem() { Value = m.Id.ToString(), Text = (m.Name + " - " + m.CurrencyCode) } ), "Value", "Text").ToList(); ViewBag.UserGroupList = userGroupList; return(View(model)); } return(RedirectToAction("List")); }
public ActionResult Create(CollegeGroupVM model) { try { string collegeGroupId = string.Empty; model.CreatedBy = LogInManager.LoggedInUserId; #region Check College Group Name Exist. if (this.CheckCollegeGroupNameExist(model.Id, model.Name) == false) { return(Json(new { IsSuccess = false, errorMessage = string.Format("Name : {0} already exist.", model.Name) }, JsonRequestBehavior.AllowGet)); } #endregion collegeGroupId = collegeGroupRepository.AddCollegeGroup(model); if (!string.IsNullOrWhiteSpace(collegeGroupId)) { return(Json(new { IsSuccess = true, data = new { CollegeGroupId = collegeGroupId } }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { IsSuccess = false, errorMessage = "College Group details not saved successfully." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { Utility.Utility.LogError(e, "Create"); return(Json(new { IsSuccess = false, errorMessage = e.Message })); } }
public CollegeGroupVM GetCollegeGroupById(Guid?collegeGroupId) { SqlParameter[] parameters = { new SqlParameter { ParameterName = "@Id", Value = collegeGroupId } }; var dt = DALHelper.GetDataTableWithExtendedTimeOut("GetCollegeGroupById", parameters); var collegeGroup = new CollegeGroupVM(); collegeGroup = DALHelper.CreateListFromTable <CollegeGroupVM>(dt).FirstOrDefault(); return(collegeGroup); }
public ActionResult Create() { var userGroupList = new SelectList(userGroupRepository.GetUserGroupsWithCurrencyInfo() .Select( m => new SelectListItem() { Value = m.Id.ToString(), Text = (m.Name + " - " + m.CurrencyCode) } ), "Value", "Text").ToList(); ViewBag.UserGroupList = userGroupList; CollegeGroupVM model = new CollegeGroupVM(); model.UserGroupId = userGroupRepository.GetUserGroupByName().FirstOrDefault().ID; return(View(model)); }