public ActionResult ApplicationForm(application_form model)
{
var dbs = Database.Open("sqlConnection");
ViewBag.StateName = dropdown(null);
string newCommand = "SELECT count(*) FROM application_form WHERE userid='" + User.Identity.Name + "'";
ViewBag.status = newCommand;
int val = dbs.QueryValue(newCommand);
if (val == 1)
{
ModelState.AddModelError("", "You have already submitted the Application Form, If You fill again previous details will be replaced.");
return(View(model));
}
return(View());
}
public ActionResult ApplicationForm(application_form model, FormCollection form)
{
string value = form["States"];
ViewBag.StateName = dropdown(value.Split(','));
try
{
var dbs = Database.Open("sqlConnection");
string[] content;
content = new string[19];
content[0] = model.fname;
content[1] = model.mname;
content[2] = model.lname;
content[3] = model.fatname;
content[4] = model.Maaname;
content[5] = form["Gender"];
content[6] = model.calender;
content[7] = form["Religion"];
content[8] = form["MT"];
content[9] = model.add1;
content[10] = model.add2;
content[11] = model.add3;
content[12] = value;
content[13] = form["District"];
content[14] = form["Taluka"];
content[15] = model.pinCode;
content[16] = model.mob;
content[17] = User.Identity.Name;
content[18] = form["Category"];
string join = null;
for (int i = 0; i < content.Length - 1; i++)
{
join = join + "'" + content[i] + "'" + ",";
}
// ViewBag.status = join;
string newCommand = "SELECT count(*) FROM application_form WHERE userid='" + content[17] + "'";
ViewBag.status = newCommand;
int val = dbs.QueryValue(newCommand);
if (val == 1)
{
var newmodel = new application_form
{
fname = dbs.QueryValue("SELECT fname FROM application_form WHERE userid='" + content[17] + "'"),
mname = dbs.QueryValue("SELECT mname FROM application_form WHERE userid='" + content[17] + "'"),
lname = dbs.QueryValue("SELECT lname FROM application_form WHERE userid='" + content[17] + "'"),
fatname = dbs.QueryValue("SELECT faname FROM application_form WHERE userid='" + content[17] + "'"),
Maaname = dbs.QueryValue("SELECT moname FROM application_form WHERE userid='" + content[17] + "'"),
gender = dbs.QueryValue("SELECT gender FROM application_form WHERE userid='" + content[17] + "'"),
calender = dbs.QueryValue("SELECT dob FROM application_form WHERE userid='" + content[17] + "'"),
religion = dbs.QueryValue("SELECT religion FROM application_form WHERE userid='" + content[17] + "'"),
mt = dbs.QueryValue("SELECT mtounge FROM application_form WHERE userid='" + content[17] + "'"),
add1 = dbs.QueryValue("SELECT add1 FROM application_form WHERE userid='" + content[17] + "'"),
add2 = dbs.QueryValue("SELECT add2 FROM application_form WHERE userid='" + content[17] + "'"),
add3 = dbs.QueryValue("SELECT add3 FROM application_form WHERE userid='" + content[17] + "'"),
state = dbs.QueryValue("SELECT states FROM application_form WHERE userid='" + content[17] + "'"),
// = dbs.QueryValue("SELECT district FROM application_form WHERE userid='" + content[17] + "'"),
//form["Taluka"] = dbs.QueryValue("SELECT taluka FROM application_form WHERE userid='" + content[17] + "'"),
pinCode = dbs.QueryValue("SELECT pincode FROM application_form WHERE userid='" + content[17] + "'"),
mob = dbs.QueryValue("SELECT mobileNo FROM application_form WHERE userid='" + content[17] + "'"),
};
return(View(newmodel));
}
else
{
string command = "insert into application_form values(" + join + "'" + content[18] + "')";//+ "'" + content[16] + "')";
dbs.Execute(command);
return(RedirectToAction("preferenceCollege"));
}
//return RedirectToAction("verifyCertificate");
}
catch (Exception e)
{
ModelState.AddModelError("", e.Message.ToString());
return(View(model));
}
}
