public System.Web.Mvc.RedirectResult AddProfl(string ProfileUserName, string profilecontactselectlist)
{
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString))
{
var result = new ProfileRepository(connection).AddProfl(ProfileUserName, profilecontactselectlist);
if (result == "success")
{
return Redirect("Profile/Profile/?error=fileloaded");
}
else
{
//do something else here.
return Redirect("Profile/Profile/?error=invalidfile");
}
}
}
// GET: AddOfficeVisit
public async System.Threading.Tasks.Task<ActionResult> EditProfile(int id)
{
ProfileCollection coll = new ProfileCollection();
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString))
{
await connection.OpenAsync();
var result = new ProfileRepository(connection).GetProfile(id);
var result2 = new ProfileRepository(connection).GetProfiles();
var result3 = new ContactRepository(connection).GetSortedContacts(result.Result.First().contact_id.ToString());
coll.singleProfile = (IEnumerable<Models.ProfileModel>)result.Result.ToArray();
coll.allProfiles = (IEnumerable<Models.ProfileModel>)result2.Result.ToArray();
coll.profilecontactselectlist = new SelectList(result3.Result.ToList(), "contact_id", "contact_name", new { id = "TxtContact", @required = "required" });
}
return View(coll);
}
