public ActionResult UpdateStatus(ProcessedApplication p, string Command)
{
int id = int.Parse(Request.Form["txtid"].ToString());
var data = db.ProcessedApplications.Where(x => x.application_id == id).SingleOrDefault();
if (Command == "Status")
{
ModelState.AddModelError("", data.comments);
return(View());
}
if (Command == "Update")
{
string comment = Request.Form["txtcomment"].ToString();
data.comments = comment;
data.date_of_resolve = DateTime.Now;
var prstatus = (from t in db.Applications join b in db.Branches on t.branch_Id equals b.branch_id where t.id == id select b.contact_person).SingleOrDefault();
data.resolved_by = prstatus;
var res = db.SaveChanges();
if (res > 0)
{
ModelState.AddModelError("", "Status Updated");
}
return(View());
}
return(View());
}
public ActionResult Insert(Application ap, ProcessedApplication pa)
{
//if(string.IsNullOrEmpty("txtname"))
// ModelState.AddModelError("", "Name Cannot be Empty!!");
//if (Request.Form["ddlbranch"]=="select")
// ModelState.AddModelError("", "Select a Branch!!");
//if (Request.Form["ddlclassid"] == "select")
// ModelState.AddModelError("", "Select a ClassID!!");
int branchid = int.Parse(Request.Form["ddlbranch"].ToString());
int classid = int.Parse(Request.Form["ddlclassid"].ToString());
string name = Request.Form["txtname"].ToString();
int age = int.Parse(Request.Form["txtage"].ToString());
DateTime dob = DateTime.Parse(Request.Form["txtdob"].ToString());
string addr = Request.Form["txtaddress"].ToString();
ap.branch_Id = branchid;
ap.class_Id = classid;
ap.name = name;
ap.age = age;
ap.dob = dob;
ap.address = addr;
pa.comments = "Submitted, But Not Yet Processed";
db.Applications.Add(ap);
db.ProcessedApplications.Add(pa);
var res = db.SaveChanges();
if (res > 0)
{
ModelState.AddModelError("", "Data Inserted");
ModelState.AddModelError("", "Your Application has been submitted. Your Application id = " + ap.id);
}
return(View());
}
public ActionResult process(string command)
{
int id = int.Parse(Request.Form["txtid"].ToString());
if (command == "status")
{
var data = db.Applications.Where(x => x.Id == id).SingleOrDefault();
if (data != null)
{
if (data.category == "not processed")
{
Response.Write("Application not processed");
}
else
{
var dat = db.ProcessedApplications.Where(x => x.Id == id).SingleOrDefault();
Response.Write(" Aplication is processed by :" + dat.resolvedby);
}
}
else
{
Response.Write("Invalid Application Id");
}
}
if (command == "Submit")
{
string cmt = Request.Form["txtcmt"].ToString();
if (cmt == "accepted")
{
var data = db.Applications.Where(x => x.Id == id).SingleOrDefault();
int bid = data.branch_id;
data.category = "processed";
db.SaveChanges();
var resdata = db.Branches.Where(x => x.branch_id == bid).SingleOrDefault();
ProcessedApplication rs = new ProcessedApplication();
rs.Id = id;
rs.comments = cmt;
rs.resolvedby = resdata.contact_person;
rs.date_of_resolve = DateTime.Now;
db.ProcessedApplications.Add(rs);
var b = db.SaveChanges();
if (b > 0)
{
Response.Write("Application " + id + " is processed");
}
}
}
return(View());
}
public ActionResult Status(ProcessedApplication p)
{
int id = int.Parse(Request.Form["txtid"].ToString());
var data = db.ProcessedApplications.Where(x => x.application_id == id).SingleOrDefault();
string st = data.comments;
string rt = data.resolved_by;
if (st == "Submitted, But Not Yet Processed")
{
ModelState.AddModelError("", st + " Check Later.");
}
else
{
ModelState.AddModelError("", st + " Please Contact :" + rt);
}
return(View());
}
