public ActionResult Save(Employee emp)
{
bool status = false;
if (ModelState.IsValid)
{
using (MyDatabaseEntities2 dc = new MyDatabaseEntities2())
{
if (emp.EmployeeID > 0)
{
//Edit
var v = dc.Employees.Where(a => a.EmployeeID == emp.EmployeeID).FirstOrDefault();
if (v != null)
{
v.FirstName = emp.FirstName;
v.LastName = emp.LastName;
v.EmailID = emp.EmailID;
v.City = emp.City;
v.Country = emp.Country;
}
}
else
{
//Save
dc.Employees.Add(emp);
}
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Save(Event events)
{
bool status = false;
if (ModelState.IsValid)
{
using (MyDatabaseEntities2 db = new MyDatabaseEntities2())
{
if (events.Id > 0)
{
var view = db.Events.Where(a => a.Id == events.Id).FirstOrDefault();
if (view != null)
{
view.Name = events.Name;
view.Location = events.Location;
view.StartDate = events.StartDate;
view.StartDateTime = events.StartDateTime;
view.EndDate = events.EndDate;
view.EndDateTime = events.EndDateTime;
}
}
else
{
db.Events.Add(events);
}
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
private void okBtn_Click(object sender, RoutedEventArgs e)
{
if (passWordTb.Text == qrPasswprdTb.Text)
{
using (MyDatabaseEntities2 db = new MyDatabaseEntities2())
{
Random ran = new Random();
db.UserInfo.Add(new UserInfo
{
UserID = userNameTb.Text,
UserPassword = passWordTb.Text,
UserBalance = 0,
UserName = nameTb.Text,
UserCardNumber = IdTb.Text,
UserStartTime = DateTime.Now,
UserPhoneNumber = phoneTb.Text,
});
try
{
db.SaveChanges();
MessageBox.Show("注册成功！");
this.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}
else
{
MessageBox.Show("确认密码不正确！");
}
}
public ActionResult Save(int id)
{
using (MyDatabaseEntities2 db = new MyDatabaseEntities2())
{
var view = db.Events.Where(a => a.Id == id).FirstOrDefault();
return(View(view));
}
}
public ActionResult GetEvent()
{
using (MyDatabaseEntities2 db = new MyDatabaseEntities2())
{
var events = db.Events.OrderBy(a => a.Name).ToList();
return(Json(new { data = events }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(int id)
{
using (MyDatabaseEntities2 dc = new MyDatabaseEntities2())
{
var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault();
return(View(v));
}
}
public ActionResult GetEmployees()
{
using (MyDatabaseEntities2 dc = new MyDatabaseEntities2())
{
var employees = dc.Employees.OrderBy(a => a.FirstName).ToList();
return(Json(new { data = employees }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (MyDatabaseEntities2 db = new MyDatabaseEntities2())
{
var view = db.Events.Where(a => a.Id == id).FirstOrDefault();
if (view != null)
{
return(View(view));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Delete(int id)
{
using (MyDatabaseEntities2 dc = new MyDatabaseEntities2())
{
var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault();
if (v != null)
{
return(View(v));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult DeleteEvent(int id)
{
bool status = false;
using (MyDatabaseEntities2 db = new MyDatabaseEntities2())
{
var view = db.Events.Where(a => a.Id == id).FirstOrDefault();
if (view != null)
{
db.Events.Remove(view);
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult DeleteEmployee(int id)
{
bool status = false;
using (MyDatabaseEntities2 dc = new MyDatabaseEntities2())
{
var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault();
if (v != null)
{
dc.Employees.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
private void enterBtn_Click(object sender, RoutedEventArgs e)
{
using (var db = new MyDatabaseEntities2())
{
userName = userTb.Text;
var q = from t in db.UserInfo
where userTb.Text == t.UserID && passwordTb.Password == t.UserPassword
select t;
if (q.Count() > 0)
{
if (identityLb.Text == "玩家")
{
Window w = new MainWindow();
this.Close();
w.ShowDialog();
}
else
{
MessageBox.Show("未查询到相关信息！");
}
}
}
}
