// [ValidateAntiForgeryToken] public ActionResult Login(Mem_Tab model) { if (ModelState.IsValid) { Database1Entities2 db = new Database1Entities2(); var user = (from Mem_Tab in db.Mem_Tab where Mem_Tab.Email == model.Email && Mem_Tab.PWD == model.PWD select new { model.Email, model.Name }).ToList(); if (user.FirstOrDefault() != null) { Session["Email"] = user.FirstOrDefault().Email; Session["Name"] = user.FirstOrDefault().Name; //return View("Create", "Resumes"); } else { ModelState.AddModelError("", "Invalid login credentials."); } } return(RedirectToAction("Create", "Resumes")); }
protected void Button1_Click(object sender, EventArgs e) { using (Database1Entities2 db = new Database1Entities2()) { try { int id = Convert.ToInt32(TextBox1.Text); string status = DropDownList1.Text.ToString(); var ord_status = (from o in db.Orders where o.order_id == id select o).Single(); ord_status.status = status; ord_status.status_date = DateTime.Now; db.SaveChanges(); Label3.Text = "updated status at " + DateTime.Now; } catch (Exception ex) { Response.Write(ex.Message); } finally { GridView1.DataBind(); } } }
public ActionResult PayHistory(Payment pay) { using (Database1Entities2 db = new Database1Entities2()) { return(View(db.Payments.ToList())); } return(View()); }
public ActionResult Details(int id) { //string email = Request.Cookies["user_email"].Value.ToString(); using (Database1Entities2 db1 = new Database1Entities2()) { } using (Database1Entities1 db = new Database1Entities1()) { return(View(db.Products.Where(x => x.productId == id).FirstOrDefault())); } }
public CompanyRepository(User user) { if (_companies == null) { _companies = new List <Company>(); } using (var entities = new Database1Entities2()) { var query = entities.Companies.Where(c => c.Users_Companies.Any(uc => uc.User.UserId == user.UserId)); /*foreach (var company in query) * _companies.Add(new Company(company.Ticker, company.Name));*/ } }
public ActionResult Payment(Payment Tb) { if (ModelState.IsValid) { using (Database1Entities2 db = new Database1Entities2()) { db.Payments.Add(Tb); db.SaveChanges(); ModelState.Clear(); Tb = null; ViewBag.Message = "Registration Successful"; } } return(View()); }
public ActionResult Patient(Patient_Info a) { Database1Entities2 D = new Database1Entities2(); D.Patient_Infoes.Add(a); var st = D.SaveChanges(); if (st > 0) { } else { } ModelState.Clear(); return(View()); }
public ActionResult PatientList() { Database1Entities2 D = new Database1Entities2(); return(View(D.Patient_Infoes.ToList())); }