public ActionResult Delete(int id, FormCollection collection)
{
try
{
REPORTEREntities1 db = new REPORTEREntities1();
jobs jb = db.jobs.Where(e => e.Jid == id).Select(e => e).Single();
db.jobs.DeleteObject(jb);
db.SaveChanges();
return RedirectToAction("Index");
} catch
{
return View();
}
}
public ActionResult Create(jobs jb)
{
try
{
REPORTEREntities1 db = new REPORTEREntities1();
db.AddTojobs(jb);
db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult Details(int id)
{
REPORTEREntities1 db = new REPORTEREntities1 ();
//var data = db.jobs.Where(e => e.Jid == id).Select(e => e).Single();
var data = db.jobs.Where(e => e.Jid == id).Select(e => e);
if (data.Count() == 0)
{
throw new NoSuchRecordException();
}
else
{
jobs jbrecord = data.Single();
return View(jbrecord);
}
//return View(data);
}
//
// GET: /Summ/
public ActionResult Index()
{
REPORTEREntities1 db = new REPORTEREntities1();
//blablabla.where(ttt = > ttt.Project== "Project1")
//выбрать все элементы, свойство Project которых равно "Poject1"
//var movies = from m in db.Table1
//var query = from o in db.jobs
//IEnumerable<Reporter1.Models.REPORTEREntities1> query = from j in db.jobs
// where j.Uid == 1
// select j;
//where (o.Uid == 1)
//group o.Date by o.Date into o
//select o;
//od => od.UnitPrice*od.Quantity) >= 10000);
//var query = db(object=>db.SumTimeview2)
return View();
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
// Попытка зарегистрировать пользователя
MembershipCreateStatus createStatus = MembershipService.CreateUser(model.UserName, model.Password,
model.Email);
if (createStatus == MembershipCreateStatus.Success)
{
REPORTEREntities1 db = new REPORTEREntities1();
UsersRP jb = new UsersRP();
jb.Login = model.UserName;
jb.Pass = model.Password;
jb.email = model.Email;
db.AddToUsersRP(jb);
db.SaveChanges();
FormsService.SignIn(model.UserName, false /* createPersistentCookie */);
return RedirectToAction("Index", "Home");
}
else
{
ModelState.AddModelError("", AccountValidation.ErrorCodeToString(createStatus));
}
// Появление этого сообщения означает наличие ошибки; повторное отображение формы
ViewData["PasswordLength"] = MembershipService.MinPasswordLength;
return View(model);
}
return View();
}
public ActionResult Delete(int id)
{
REPORTEREntities1 db = new REPORTEREntities1();
var data = db.jobs.Where(e => e.Jid == id).Select(e => e).Single();
return View(data);
}
//
// GET: /jobs/
public ActionResult Index()
{
REPORTEREntities1 db = new REPORTEREntities1();
System.Web.UI.Page wp = new System.Web.UI.Page();
//string firstName = "wpride88";
//if (Session != null) Session.Add("LgUser", firstName);
// Redirect to second page.
//string sss = Page.User.Identity.Name;
System.Web.UI.Page pg = new System.Web.UI.Page();
string sss = pg.User.Identity.Name;
Session["LgUser"] = sss;
return View();
}