using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebApplication15.Models;
namespace WebApplication15.Controllers
{
public class UserLoginController : ApiController
{
UserDBHelper db = new UserDBHelper();
[HttpGet]
//登录
public UserLogin Login(string UserName, string PassWord)
{
var list = db.logins.Where(p => p.UserName.Contains(UserName) && p.PassWord.Contains(PassWord)).FirstOrDefault();
return list;
}
[HttpPost]
//注册
public int ZhuCe(UserLogin ul)
{
db.logins.Add(ul);
return db.SaveChanges();
}
[HttpGet]
//显示
public List<Student> Show()
{
return db.students.ToList();
}
[HttpPost]
//添加
public int Add(Student s)
{
db.students.Add(s);
return db.SaveChanges();
}
[HttpGet]
//查询
public List<Student> Find(string Name)
{
if (Name==null)
{
return db.students.ToList();
}
else
{
return db.students.Where(p => p.Name.Contains(Name)).ToList();
}
}
//删除
[HttpDelete]
public int Delete(int Id)
{
var list = db.students.Find(Id);
db.students.Remove(list);
return db.SaveChanges();
}
[HttpGet]
//反填
public Student GetStudent(int Id)
{
var list = db.students.Find(Id);
return list;
}
[HttpPost]
//修改
public int Update(Student s)
{
var list = db.students.Find(s.Id);
list.Name = s.Name;
list.Sex = s.Sex;
list.Age = s.Age;
return db.SaveChanges();
}
}
}