public ActionResult CreateRanks(PERSON rank, FormCollection collection)
{
try
{
var f = collection.GetValue("chair");
string chair = f.AttemptedValue.ToString();
var au = collection.GetValue("degree");
string degree = au.AttemptedValue.ToString();
if(ModelState.IsValid)
{
string n = rank.PR_NAME;
if((from c in ctx.PERSON where c.PR_NAME == n select c).Any())
{
return RedirectToAction("Problem");
}
else
{
var ch = (from c in ctx.DIC_CHAIRS where c.DCH_NAME == chair select c).First();
var dg = (from c in ctx.DIC_DEGREE where c.DDG_NAME == degree select c).First();
rank.PR_DDG = dg.DDG_ID;
rank.PR_DCH = ch.DCH_ID;
rank.DIC_CHAIRS = ch;
ctx.PERSON.Add(rank);
ctx.SaveChanges();
}
}
return RedirectToAction("AllPeople");
}
catch
{
return RedirectToAction("Problem");
}
return View();
}
public ActionResult PersonSearch(FormCollection collection)
{
var f = collection.GetValue("name");
string name = f.AttemptedValue.ToString();
var f1 = collection.GetValue("chair");
string chair = f1.AttemptedValue.ToString();
var f2 = collection.GetValue("degree");
string degree = f2.AttemptedValue.ToString();
var f3 = collection.GetValue("rank");
string rank = f3.AttemptedValue.ToString();
var f4 = collection.GetValue("audience");
string audience = f4.AttemptedValue.ToString();
//===============
// List<PERSON> result = new List<PERSON>();
result.Clear();
List<PERSON> list1 = new List<PERSON>();
List<PERSON> list2 = new List<PERSON>();
List<PERSON> list3 = new List<PERSON>();
List<PERSON> list4 = new List<PERSON>();
List<PERSON> list5 = new List<PERSON>();
if (name == String.Empty)
{
list1 = (from c in ctx.PERSON where c.PR_ID == c.PR_ID select c).ToList();
}
else
{
list1 = (from c in ctx.PERSON where c.PR_NAME == name select c).ToList();
}
if (chair == String.Empty)
{
list2 = (from c in ctx.PERSON where c.PR_ID == c.PR_ID select c).ToList();
}
else
{
int ch = (from c in ctx.DIC_CHAIRS where c.DCH_NAME == chair select c.DCH_ID).First();
list2 = (from c in ctx.PERSON where ch == c.PR_DCH select c).ToList();
}
if (degree == String.Empty)
{
list3 = (from c in ctx.PERSON where c.PR_ID == c.PR_ID select c).ToList();
}
else
{
int dg = (from c in ctx.DIC_DEGREE where c.DDG_NAME == degree select c.DDG_ID).First();
list3 = (from c in ctx.PERSON where c.PR_DDG == dg select c).ToList();
}
if (rank == String.Empty)
{
list4 = (from c in ctx.PERSON where c.PR_ID == c.PR_ID select c).ToList();
}
else
{
int r = (from c in ctx.DIC_RANKS where c.DRK_NAME == rank select c.DRK_ID).First();
var pr = (from c in ctx.PERSON_RANKS where c.PRS_DRK == r select c.PRS_PR).ToList();
list4 = (from c in ctx.PERSON where pr.Contains(c.PR_ID) select c).ToList();
}
if (audience == String.Empty)
{
list5 = (from c in ctx.PERSON where c.PR_ID == c.PR_ID select c).ToList();
}
else
{
int au = (from c in ctx.DIC_AUDIENCE where c.DAU_NAME == audience select c.DAU_ID).First();
var pr = (from c in ctx.PERSON_AUDIENCE where c.PAU_DAU == au select c.PAU_PR).ToList();
list5 = (from c in ctx.PERSON where pr.Contains(c.PR_ID) select c).ToList();
}
var universum = (from c in ctx.PERSON select c).ToList();
foreach (var c in universum)
{
if (list1.Contains(c)&&list2.Contains(c) && list3.Contains(c) && list4.Contains(c) && list5.Contains(c))
{
PERSON tr = new PERSON();
tr = c;
result.Add(tr);
}
}
//==========
return RedirectToAction("Result");// problem
// return View(result);
}
public ActionResult Create()
{
PERSON rank = new PERSON();
return View(rank);
}
public ActionResult PersonEdit(int id, FormCollection collection)
{
var p = (from c in ctx.PERSON where c.PR_ID == id select c).First();
try
{
var f = collection.GetValue("chair");
string chair = f.AttemptedValue.ToString();
var au = collection.GetValue("degree");
string degree = au.AttemptedValue.ToString();
string name = p.PR_NAME;
PERSON per = new PERSON();
UpdateModel(per);
string w = per.PR_NAME;
if ((from c in ctx.PERSON where c.PR_ID!= id && c.PR_NAME == w select c ).Any())
{
return RedirectToAction("Problem");
}
else
{
var ch = (from c in ctx.DIC_CHAIRS where c.DCH_NAME == chair select c).First();
var dg = (from c in ctx.DIC_DEGREE where c.DDG_NAME == degree select c).First();
UpdateModel(p);
p.PR_DCH = ch.DCH_ID;
p.PR_DDG = dg.DDG_ID;
p.DIC_CHAIRS = ch;
ctx.SaveChanges();
}
return RedirectToAction("AllPeople");
}
catch
{
return RedirectToAction("Problem");
}
return View();
}