public ActionResult CreateRanks(PERSON_AUDIENCE rank, FormCollection collection)
{
try
{
var f = collection.GetValue("head");
string head = f.AttemptedValue.ToString();
var au = collection.GetValue("audience");
string audi = au.AttemptedValue.ToString();
if((from c in ctx.PERSON_AUDIENCE where c.PERSON.PR_NAME == head && c.DIC_AUDIENCE.DAU_NAME == audi select c).Any())
{
return RedirectToAction("AllRelations");
}else
{
var person = (from c in ctx.PERSON where c.PR_NAME == head select c).First();
var audience = (from c in ctx.DIC_AUDIENCE where c.DAU_NAME == audi select c).First();
rank.DIC_AUDIENCE = audience;
rank.PERSON = person;
rank.PAU_PR = person.PR_ID;
rank.PAU_DAU = audience.DAU_ID;
ctx.PERSON_AUDIENCE.Add(rank);
ctx.SaveChanges();
// return RedirectToAction("AllRelations");
}
return RedirectToAction("AllRelations");
}
catch
{
return RedirectToAction("Problem");
}
return View();
}
public ActionResult Create()
{
PERSON_AUDIENCE rank = new PERSON_AUDIENCE();
return View(rank);
}
