private List <SelectListItem> PopulateApplications(string userName)
{
AssignApplication assignApplication = new AssignApplication();
assignApplication.UserName = userName;
List <SelectListItem> items = new List <SelectListItem>();
assignApplicationService = new AssignApplicationService();
var applications = assignApplicationService.GetUserApplicationIds(assignApplication);
if (applications.AssignedApplications == null)
{
applications.AssignedApplications = "0";
}
string[] values = applications.AssignedApplications.ToString().Split(',');
for (int i = 0; i < values.Length; i++)
{
values[i] = values[i].Trim();
}
foreach (var item in values)
{
items.Add(new SelectListItem
{
Value = item
});
}
return(items);
}
public IActionResult AssignApplication(PopulateApplicationsView populateApplicationsView)
{
AssignApplication assignApplication = new AssignApplication();
string name = (string)TempData["User"];
populateApplicationsView.SelectedApplicationList = GetAllApplications();
if (populateApplicationsView.SelectedApplicationId != null && name != "")
{
var selectedItems = populateApplicationsView.SelectedApplicationList.Where(p => populateApplicationsView.SelectedApplicationId.Contains(int.Parse(p.Value))).ToList();
string applist = "";
ViewBag.Message = "Selected Apps:";
foreach (var selectedItem in selectedItems)
{
applist += selectedItem.Value + ",";
ViewBag.Message += "\\n" + selectedItem.Text;
}
applist = applist.TrimEnd(',');
assignApplication.AssignedApplications = applist;
assignApplication.UserName = name;
}
else if (populateApplicationsView.SelectedApplicationId == null && name != "")
{
assignApplication.AssignedApplications = null;
assignApplication.UserName = name;
}
assignApplicationService = new AssignApplicationService();
var result = assignApplicationService.AssignApplicationToUser(assignApplication);
return(RedirectToAction("list", "User"));
//return View();
}
public AssignApplication GetAssignedApplicationIdsToUser(AssignApplication assignApplication)
{
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.Add("@UserName", assignApplication.UserName);
var ids = SqlMapper.Query <string>(connectionstring, "get_assigned_applications_by_username", dynamicParameters, commandType: StoredProcedure).FirstOrDefault();
assignApplication.AssignedApplications = Convert.ToString(ids);
return(assignApplication);
}
public AssignApplication AssignApplicationsToUser(AssignApplication assignApplication)
{
try
{
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.Add("@UserName", assignApplication.UserName);
dynamicParameters.Add("@AssignedApplications", assignApplication.AssignedApplications);
dynamicParameters.Add("@InsertedId", dbType: DbType.Int32, direction: ParameterDirection.Output);
SqlMapper.ExecuteAsync(connectionstring, "assign_applications_to_user", dynamicParameters, commandType: StoredProcedure);
int user_inserted = dynamicParameters.Get <int>("@InsertedId");
assignApplication.AssignedApplicationId = user_inserted;
return(assignApplication);
}
catch (Exception message)
{
assignApplication.AssignedApplicationId = 0;
return(assignApplication);
}
}
public AssignApplication GetUserApplicationIds(AssignApplication assignApplication)
{
return(api.Post(String.Format("{0}/AssignedApplication/GetUserAssignedApplications", baseUrl), assignApplication));
}
public AssignApplication AssignApplicationToUser(AssignApplication assignApp)
{
return(api.Post(String.Format("{0}/AssignedApplication/AssignApplicationsToUser", baseUrl), assignApp));
}
public AssignApplication AssignApplicationsToUser(AssignApplication assignApplication)
{
return(_assignedApplicationRepository.AssignApplicationsToUser(assignApplication));
}
public AssignApplication GetUserAssignedApplications(AssignApplication assignApplication)
{
return(_assignedApplicationRepository.GetAssignedApplicationIdsToUser(assignApplication));
}
public AssignApplication AssignApplicationsToUser(AssignApplication assignApplication)
{
return(_assignedApplicationService.AssignApplicationsToUser(assignApplication));
}
public AssignApplication GetUserAssignedApplications(AssignApplication assignApplication)
{
return(_assignedApplicationService.GetUserAssignedApplications(assignApplication));
}
