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