public ActionResult MenuInsert(Menus menus)
{
//添加菜单信息
db.Menus.Add(menus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Teacher teacher)
{
db.Teacher.Add(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Index(int AnswerID, int TopicID, string DetailAnswer)
{
var result = db.Detail.FirstOrDefault(p => p.TopicID == TopicID && p.AnswerID == AnswerID);
result.DetailAnswer = DetailAnswer;
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "TopicID,TopicExplain,TopicScore,TopicType,TopicA,TopicB,TopicC,TopicD,TopicSort,TopicAnswer,PaperID")] Topic topic)
{
if (ModelState.IsValid)
{
db.Topic.Add(topic);
db.SaveChanges();
return(RedirectToAction("Index", "Papers"));
}
List <SelectListItem> listType = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "1", Text = "单选", Selected = true
},
new SelectListItem()
{
Value = "2", Text = "判断"
},
new SelectListItem()
{
Value = "3", Text = "问答"
}
};
ViewBag.Paper = db.Paper.Find(topic.PaperID);
ViewBag.TopicType = new SelectList(listType, "Value", "Text");
return(View(topic));
}
public ActionResult Delete(int?id)
{
//根据角色id查角色菜单关系表，是否有菜单绑定
var rrm = db.R_Role_Menus.Where(p => p.RoleID == id).ToList();
//根据角色id查用户角色关系表,是否有用户绑定
var rur = db.R_User_Roles.Where(p => p.RoleID == id).ToList();
if (rrm.Count > 0)
{
return(Content("<script>alert('撤除菜单绑定才可删除该角色！');history.go(-1);</script>"));
}
else if (rur.Count > 0)
{
return(Content("<script>alert('撤除用户绑定才可删除该角色！');location.href='/Role/Index';</script>"));
}
else
{
Roles role = db.Roles.Find(id);
db.Roles.Remove(role);
db.SaveChanges();
}
//跳转到首页index
return(RedirectToAction("index"));
}
/// <summary>
/// 删除操作的菜单
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult RoleDelete(int ID)
{
//获得角色菜单表信息
R_Role_Menus RoleMenus = db.R_Role_Menus.Find(ID);
db.R_Role_Menus.Remove(RoleMenus);
db.SaveChanges();
return(RedirectToAction("Index", "Role"));
}
public void Index(int AnswerID, int TopicID, string DetailAnswer)
{
//根据AnswerID和topicID 查询学生在答题卡中的记录
var result = db.Detail.FirstOrDefault(d => d.TopicID == TopicID && d.AnswerID == AnswerID);
//修改成最新提交的答案
result.DetailAnswer = DetailAnswer;
db.SaveChanges();
}
public ActionResult Delete(int?RUserRolesID)
{
//获得删除的对象
R_User_Roles r = db.R_User_Roles.Find(RUserRolesID);
//EF remove删除对象
db.R_User_Roles.Remove(r);
//从数据库中删除对象
db.SaveChanges();
return(RedirectToAction("Index", "UserInfo"));
}
public ActionResult Delete(int?id)
{
if (id != null)
{
R_Role_Menus rrm = db.R_Role_Menus.Find(id);
db.R_Role_Menus.Remove(rrm);
db.SaveChanges();
}
return(RedirectToAction("Index", "Role"));
}
public ActionResult Create([Bind(Include = "PaperID,PaperName,PaperExplain,PaperTime")] Paper paper)
{
if (ModelState.IsValid)
{
db.Paper.Add(paper);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(paper));
}
public ActionResult Create([Bind(Include = "TopicID,TopicExplain,TopicScore,TopicType,TopicA,TopicB,TopicC,TopicD,TopicSort,TopicAnswer,PaperID")] Topic topic)
{
if (ModelState.IsValid)
{
db.Topic.Add(topic);
db.SaveChanges();
return(RedirectToAction("Details", "Papers", new { id = topic.PaperID }));
}
//跳转到get请求的创建方法中，并将试卷id传参带过去。
//解决了视图上初始化Paper对象为空报错，和题目类型下拉框初始化为空取值报错
return(RedirectToAction("Create", new { id = topic.PaperID }));
}
/// <summary>
/// 删除【【---角色---】】
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult Delete(int ID)
{
//根据获得的ID查找
R_User_Roles kk = db.R_User_Roles.Find(ID);
//删除
db.R_User_Roles.Remove(kk);
//操作数据库
db.SaveChanges();
//删除成功后，跳转到另一个控制器下的视图
return(RedirectToAction("Index", "UserInfo"));
}
public ActionResult Deposit(Users users, int moneyinput)
{
if (ModelState.IsValid)
{
System.Diagnostics.Debug.WriteLine(users.PIN);
users.Balance += moneyinput;
atmbalance += moneyinput;
db.Entry(users).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Balance", new { id = users.AccountNumber }));
}
return(View(users));
}
public ActionResult Create(Topic t)
{
if (ModelState.IsValid)
{
db.Topic.Add(t);
db.SaveChanges();
return(RedirectToAction("Index", "Papers"));
}
else
{
return(View());
}
}
public ActionResult Create(Paper p)
{
if (ModelState.IsValid)
{
db.Paper.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public ActionResult Delete(int?id)
{
//根据这个ID查询对象，并且删除 EF lINQ
//var userInfo = db.UserInfos.Where(p => p.ID == id).FirstOrDefault();
if (id != null)
{
var userInfo = db.UserInfos.Find(id);
db.UserInfos.Remove(userInfo);
db.SaveChanges();
}
//跳转到首页index
return(RedirectToAction("index"));
}
public ActionResult Create(Teacher tea)
{
if (ModelState.IsValid)
{
db.Teacher.Add(tea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public void Put(int id, string column, string value)
{
using (AccountDBEntities entities = new AccountDBEntities()) {
user user = (from usr in entities.users
where usr.id == id
select usr).First();
switch (column)
{
case "username":
user.username = value;
break;
case "password":
user.password = value;
break;
case "email":
user.email = value;
break;
case "fullname":
user.fullname = value;
break;
default:
break;
}
entities.SaveChanges();
}
}
public ActionResult Create(Account account)
{
if (ModelState.IsValid)
{
account.UserId = Guid.NewGuid();
db.Accounts.Add(account);
if (!ExistEmail(account))
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ModelState.AddModelError("error", "Email exist");
ViewBag.error = TempData["error"];
return(View(account));
}
public ActionResult Delete(int?id)
{
var rrm = db.R_Role_Menus.Where(p => p.MenuID == id).ToList();
if (rrm.Count > 0)
{
return(Content("<script>alert('该菜单已授权不可，不可删除，如果想清除该菜单的授权！');location.href='/Menu/Index';</script>"));
}
else
{
Menus menus = db.Menus.Find(id);
db.Menus.Remove(menus);
db.SaveChanges();
}
//跳转到首页index
return(RedirectToAction("index"));
}
public void Delete(int id)
{
using (AccountDBEntities entities = new AccountDBEntities()) {
user user = (from usr in entities.users
where usr.id == id
select usr).First();
entities.users.Remove(user);
entities.SaveChanges();
}
}
/// <summary>
/// 根据关系表的id删除角色与用户的关系
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Delete(int?id)
{
if (id != null)
{
R_User_Roles r_User_Roles = db.R_User_Roles.Find(id);
db.R_User_Roles.Remove(r_User_Roles);
db.SaveChanges();
}
return(RedirectToAction("Index", "User"));
}
public ActionResult Create(Student stu)
{
if (ModelState.IsValid)
{
Student s = db.Student.SingleOrDefault(p => p.StuLoginName == stu.StuLoginName);
if (s == null)
{
db.Student.Add(stu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Content("<script>alert('登录名已存在')</script>"));
}
}
else
{
return(View());
}
}
public void Post(string username, string password, string email, string fullname)
{
user user = new user
{
username = username,
password = password,
email = email,
fullname = fullname
};
using (AccountDBEntities entities = new AccountDBEntities()) {
entities.users.Add(user);
entities.SaveChanges();
}
}
public HttpResponseMessage Register1(Domain.UserModel um)
{
string message = "";
try
{
using (AccountDBEntities adb = new AccountDBEntities())
{
var isExistEmail = IsEmailExist(um.Email);
if (isExistEmail)
{
message += "Email already exists|";
}
var isMobileNumber = IsMobileNumberExist(um.MobileNumber);
if (isMobileNumber)
{
message += "Mobile number already exists|";
}
if (!isExistEmail && !isMobileNumber)
{
adb.Users.Add(new User()
{
Email = um.Email,
MobileNumber = um.MobileNumber,
FirstName = um.FirstName,
LastName = um.LastName,
DateOfBirth = um.DateOfBirth,
Gender = um.Gender,
Password = um.Password,
});
adb.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, um));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, message));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult Insert(HttpPostedFileBase Photo, UserInfos userInfo, List <int> roles)
{
//-----添加图片
//判断图片是否为空
if (Photo != null)
{
//判断图片大小
if (Photo.ContentLength > 0 && Photo.ContentLength < 4194304)
{
//获取上传路径
string FileName = Path.GetFileName(Photo.FileName);
//获取文件后缀名
string suff = FileName.Substring(FileName.IndexOf(".") + 1);
//判断格式
if (suff == "jpg" || suff == "png" || suff == "gif")
{
//图片存储位置
Photo.SaveAs(Server.MapPath("~/images/users/" + Photo.FileName));
userInfo.Photo = Photo.FileName;
}
}
}
else
{
return(Content("<script>alert('未获取到上传的文件')</script>"));
}
//-----添加用户信息
db.UserInfos.Add(userInfo);
db.SaveChanges();
//-----添加用户与角色的关系
//遍历所选中的角色
foreach (var item in roles)
{
//new 一个新的 R_User_Roles对象，将角色ID 与 RoleID 组成一个新的对象添加
R_User_Roles UR = new R_User_Roles()
{
UserID = userInfo.ID,
RoleID = item
};
db.R_User_Roles.Add(UR);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Add(Student stu)
{
if (ModelState.IsValid)
{//判断注册时填写的登录账号是否再数据库中已存在
Student s = db.Student.SingleOrDefault(p => p.StuLoginName == stu.StuLoginName);
if (s == null)
{
db.Student.Add(stu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("flag", "该账号已存在！");
return(View());
}
}
else
{
return(View());
}
}
public ActionResult Add(UserInfos user, HttpPostedFileBase Photo, int[] roles)
{
if (ModelState.IsValid)
{
foreach (var item in roles)
{
R_User_Roles rur = new R_User_Roles();
rur.RoleID = item;
rur.UserID = user.ID;
db.R_User_Roles.Add(rur);
}
if (Photo != null)
{
if (Photo.ContentLength > 0 && Photo.ContentLength < 4194304)
{
string fileName = Path.GetFileName(Photo.FileName);
//string suffix = fileName.Substring(fileName.LastIndexOf(".") + 1);
if (fileName.EndsWith("gif") || fileName.EndsWith("jpg") || fileName.EndsWith("png"))
{
Photo.SaveAs(Server.MapPath("~/Content/images/images/users/" + fileName));
user.Photo = fileName;
}
}
else
{
return(Content("<script>alert('上传的文件必须是图片')</script>"));
}
}
else
{
return(Content("<script>alert('未获取上传的文件')</script>"));
}
db.UserInfos.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.dlist = db.Departments.ToList();
ViewBag.list = db.Roles.ToList();
return(View());
}
}
public ActionResult AddUser(UserInfos user, HttpPostedFileBase Photo, int[] roles)
{
//处理图片
if (Photo != null)
{
//1、获得文件的名称
string fileName = Path.GetFileName(Photo.FileName);
//2、判断文件是否是图片
//string hz = Path.GetExtension(fileName); //.jpg
if (fileName.EndsWith("jpg") || fileName.EndsWith("png") ||
fileName.EndsWith("gif") || fileName.EndsWith("jpeg"))
{
//3、保存图片到项目文件夹当中
Photo.SaveAs(Server.MapPath("~/Content/images/users/" + fileName));
//4、将图片文件名，绑定到该用户的photo字段中
user.Photo = fileName;
}
else
{
return(Content("<script>alert('上传的文件必须是图片！')</script>"));
}
}
else
{
return(Content("<script>alert('未获取上传的文件')</script>"));
}
//添加用户
db.UserInfos.Add(user);
db.SaveChanges();
//添加用户与角色的关系
foreach (var roleID in roles)
{
R_User_Roles rur = new R_User_Roles();
rur.RoleID = roleID;
rur.UserID = user.ID;
db.R_User_Roles.Add(rur);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Add(Menus menus)
{
db.Menus.Add(menus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
