// [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()));
}
