public void saveToFile(string input, string des)
{
if (des.Equals("input"))
{
var todo = dbContext.InputDataModels.SingleOrDefault();
dbContext.InputDataModels.Remove(todo);
dbContext.SaveChanges();
InputDataModel data = new InputDataModel();
data.Input = input;
dbContext.InputDataModels.Add(data);
dbContext.SaveChanges();
}
else
{
var todo = dbContext.AlphabetizedDataModels.SingleOrDefault();
dbContext.AlphabetizedDataModels.Remove(todo);
dbContext.SaveChanges();
AlphabetizedDataModel data = new AlphabetizedDataModel();
data.Alphabetized = input;
dbContext.AlphabetizedDataModels.Add(data);
dbContext.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "ID,Name,Accounted,Encrypted,Production")] DBdata dBdata)
{
if (ModelState.IsValid)
{
db.Dbset.Add(dBdata);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dBdata));
}
public ActionResult Create(Category model)
{
int categoryId = (from Category in dBContext.Categories
where model.CategoryName.Equals(Category.CategoryName)
select Category.CategoryId).FirstOrDefault();
if (categoryId != 0)
{
return(Json("Failure", JsonRequestBehavior.AllowGet));
}
dBContext.Categories.Add(model);
dBContext.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Product model)
{
int productId = (from product in dBContext.Products
where model.ProductName.Equals(product.ProductName)
where model.CategoryId.Equals(product.CategoryId)
select product.ProductId).FirstOrDefault();
if (productId != 0)
{
return(Json("Failure", JsonRequestBehavior.AllowGet));
}
dBContext.Products.Add(model);
dBContext.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult <string> Register(string email, string password, string nickname)
{
var uuid = Guid.NewGuid().ToString();
var info = dbContext.Users.Where(n => n.NickName.Equals(nickname)).ToList().FirstOrDefault();
if (info != null)
{
return(Ok(new
{
status = false,
msg = "昵称重复"
}));
}
dbContext.Users.Add(new DBModel.User {
UserId = uuid, NickName = nickname
});
dbContext.SaveChanges();
dbContext.Accounts.Add(new DBModel.Account {
UserId = uuid, Email = email, Password = password, State = 1, Type = 0
});
if (dbContext.SaveChanges() == 1)
{
return(Ok(new
{
status = true,
msg = "注册成功"
}));
}
else
{
return(Ok(new
{
status = false,
msg = "注册失败"
}));
}
}
public ActionResult <string> ModifyInfo(string id, string nickname, int gender, string phoneNumber, string majorID, int year, int degree)
{
var info = dbContext.Users.Where(n => n.UserId.Equals(id)).ToList().FirstOrDefault();
info.NickName = nickname;
info.Gender = gender;
info.PhoneNumber = phoneNumber;
info.MajorId = majorID;
dbContext.SaveChanges();
return(Ok(new
{
status = true,
msg = "修改信息成功"
}));
}
public ActionResult <IEnumerable <string> > Get()
{
#region 新增
//Province province = new Province
//{
// //int类型的ID默认为主键自增，所以不需要添加。
// name="北京",
// population=200000
//};
//Company company = new Company
//{
// Name = "腾讯",
// CreateTime = new DateTime(),
// LegalPerson = "小马哥"
//};
//_context.AddRange(province, company);
//_context.SaveChanges();
#endregion
#region 查询
//var province = _context.Provinces.Where(x => x.name == "北京").ToList();
#endregion
#region 修改
var province = _context.Provinces.FirstOrDefault();
if (province != null)
{
province.population += 100;
_context.Provinces.Add(new Province
{
name = "上海",
population = 200000
});
_context.SaveChanges();
}
#endregion
#region 除
//var province = _context.Provinces.FirstOrDefault();
//_context.Remove(province);
//_context.SaveChanges();
#endregion
return(new string[] { "value1", "value2" });
}
//Creating Employing Method *****************************************************
public void AddEmployeeData(Employee employee)
{
employee.TrackingNum = GetRandomNumb();
_dataDBContext.EmployeeTable.Add(employee);
_dataDBContext.SaveChanges();
}