public ActionResult Index(FormCollection formInputs)
{
// Creating the connection string
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = formInputs["server"];
builder.UserID = formInputs["user"];
builder.Password = formInputs["pass"];
builder.InitialCatalog = formInputs["database"];
string conStr = builder.ConnectionString;
try
{
// Generating a markup string to use in the view
PersonMarkupGenerator markupGen = new PersonMarkupGenerator();
markupGen.setPeople(conStr);
string markupStr = markupGen.generateMarkup();
ViewData["markup"] = markupStr;
return(View());
} catch (Exception e)
{
return(RedirectToAction("SignIn", "Home", new { signinpass = false }));
}
}
public ActionResult Index(FormCollection formInputs)
{
// Checking if the user is logged in
if (Convert.ToBoolean(Session["loginsuccess"]))
{
// Generating a markup string to use in the view
PersonMarkupGenerator markupGen = new PersonMarkupGenerator();
markupGen.setPeople(Session["connection"].ToString());
string markupStr = markupGen.generateMarkup();
ViewData["markup"] = markupStr;
Session["tablemarkup"] = markupStr;
return(View());
}
else
{
try
{
// Creating the connection string
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = formInputs["server"];
builder.UserID = formInputs["user"];
builder.Password = formInputs["pass"];
builder.InitialCatalog = formInputs["database"];
string conStr = builder.ConnectionString;
// Generating a markup string to use in the view
PersonMarkupGenerator markupGen = new PersonMarkupGenerator();
markupGen.setPeople(conStr);
string markupStr = markupGen.generateMarkup();
ViewData["markup"] = markupStr;
Session["connection"] = conStr;
Session["loginsuccess"] = true;
return(View());
}
catch (Exception e)
{
return(RedirectToAction("SignIn", "Home", new { signinpass = false }));
}
}
}
