public ActionResult Create([Bind(Include = "userID,is_public,optIn,showEthnicity,showAge,showCountry,showGender,description,profileImgUrl")] UserProfile userProfile)
{
if (ModelState.IsValid)
{
db.UserProfiles.Add(userProfile);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userID = new SelectList(db.AspNetUsers, "Id", "Email", userProfile.userID);
return(View(userProfile));
}
public ActionResult Create([Bind(Include = "listID,userID,listName")] UserList userList)
{
userList.userID = User.Identity.GetUserId();
if (ModelState.IsValid)
{
db.UserLists.Add(userList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userList));
}
//[ValidateAntiForgeryToken]
public ContentResult Create(int usdaFoodID, int listID, string brandOwner, string upc, string description)
{
if (User.Identity.GetUserId() != null)
{
SavedFood savedFood = new SavedFood(usdaFoodID, listID, brandOwner, upc, description);
try
{
db.SavedFoods.Add(savedFood);
db.SaveChanges();
var jsonData = new
{
success = true,
message = "Food has been saved.",
redirect = false
};
var result = JObject.FromObject(jsonData);
return(Content(result.ToString(), "Application/json"));
}
catch
{
var jsonData2 = new
{
success = false,
message = "Food has already been saved.",
redirect = false
};
var result2 = JObject.FromObject(jsonData2);
return(Content(result2.ToString(), "Application/json"));
}
}
var jsonData3 = new
{
success = false,
message = "User not logged in.",
redirect = true
};
var result3 = JObject.FromObject(jsonData3);
return(Content(result3.ToString(), "Application/json"));
}
public ActionResult AddFodmap([Bind(Include = "Name,Aliases")] FODMAPIngredient newIngredient, string previousAction)
{
if (ModelState.IsValid)
{
if (db.FODMAPIngredients.FirstOrDefault(x => x.Name.Contains(newIngredient.Name)) != null ||
db.FODMAPIngredients.FirstOrDefault(x => x.Aliases.Contains(newIngredient.Name)) != null)
{
return(RedirectToAction(previousAction, new { Message = Message.FodmapExists }));
}
db.FODMAPIngredients.Add(newIngredient);
db.SaveChanges();
return(RedirectToAction(previousAction, new { Message = Message.AddFodmapSuccess }));
}
return(RedirectToAction("AddFodmap", new { Message = Message.AddFodmapFailure }));
}
public IHttpActionResult Create([FromBody] SavedFoodRequest request)
{
using (FFDBContext db = new FFDBContext())
{
if (User.Identity.GetUserId() != null)
{
SavedFood savedFood = new SavedFood(request.UsdaFoodID, request.ListID, request.BrandOwner, request.Upc, request.Description);
try
{
db.SavedFoods.Add(savedFood);
db.SaveChanges();
var jsonData = new JsonResponse
{
success = true,
message = "Food has been saved.",
redirect = false
};
return(Ok(jsonData));
}
catch
{
var jsonData2 = new JsonResponse
{
success = false,
message = "Food has already been saved.",
redirect = false
};
return(Ok(jsonData2));
}
}
var jsonData3 = new JsonResponse
{
success = false,
message = "User not logged in.",
redirect = true
};
return(Ok(jsonData3));
}
}
public bool AddCompany(string companyName, string companyCode)
{
using (FFDBContext context = new FFDBContext())
{
try
{
context.Companies.Add(new Company()
{
Code = companyCode,
Name = companyName
});
context.SaveChanges();
return true;
}
catch (Exception ex)
{
Logger.Error("添加货代公司失败", ex);
return false;
}
}
}
public bool AddRegCode(string machineCode, string regCode, int companyId)
{
using (FFDBContext context = new FFDBContext())
{
try
{
context.RegisterCodes.Add(new RegisterCode()
{
MachineCode = machineCode,
RegCode = regCode,
CompanyId = companyId,
CreatedDate = DateTime.Now,
State = (int)RegCodeStates.Actived
});
context.SaveChanges();
return true;
}
catch (Exception ex)
{
Logger.Error("添加注册码失败", ex);
return false;
}
}
}
public IHttpActionResult Create([FromBody] LabelIngredientRequest req)
{
var ingredientName = req.IngredientName;
var assignLabel = req.AssignLabel;
using (FFDBContext db = new FFDBContext())
{
string userID = User.Identity.GetUserId();
if (userID != null)
{
int ingredientID = db.LabelledIngredients.Where(s => s.Name == ingredientName).Select(s => s.ID).FirstOrDefault();
if (ingredientID == 0)
{
LabelledIngredient labelIngredient = new LabelledIngredient {
Name = ingredientName
};
try
{
db.LabelledIngredients.Add(labelIngredient);
db.SaveChanges();
ingredientID = labelIngredient.ID;
}
catch
{
var jsonData_failed_ingredient_add = new JsonResponse
{
success = false,
message = "Ingredient not added to database",
redirect = false
};
return(Ok(jsonData_failed_ingredient_add));
}
}
if (db.UserIngredients.Where(s => s.LabelledIngredientID == ingredientID && s.userID == userID).Count() > 0)
{
var existingRecord = db.UserIngredients.FirstOrDefault(s => s.LabelledIngredientID == ingredientID && s.userID == userID);
existingRecord.Label = assignLabel;
db.SaveChanges();
var jsonData_edit_record = new JsonResponse
{
success = true,
message = "Label has been changed in the record",
redirect = false
};
return(Ok(jsonData_edit_record));
}
else
{
UserIngredient userIng = new UserIngredient(userID, assignLabel, ingredientID);
try
{
db.UserIngredients.Add(userIng);
db.SaveChanges();
var jsonData_success = new JsonResponse
{
success = true,
message = "Label has been saved.",
redirect = false
};
return(Ok(jsonData_success));
}
catch (Exception e)
{
var jsonData_fail = new JsonResponse
{
success = false,
message = $"Something went wrong: {e.InnerException.InnerException.Message}",
redirect = false
};
return(Ok(jsonData_fail));
}
}
}
var jsonData3 = new JsonResponse
{
success = false,
message = "User not logged in.",
redirect = true
};
return(Ok(jsonData3));
}
}
//[ValidateAntiForgeryToken]
public ContentResult Create(string assignLabel, string ingredientName)
{
string userID = User.Identity.GetUserId();
if (userID != null)
{
int ingredientID = db.LabelledIngredients.Where(s => s.Name == ingredientName).Select(s => s.ID).FirstOrDefault();
if (ingredientID == 0)
{
LabelledIngredient labelIngredient = new LabelledIngredient();
labelIngredient.Name = ingredientName;
try
{
db.LabelledIngredients.Add(labelIngredient);
db.SaveChanges();
ingredientID = labelIngredient.ID;
}
catch
{
var jsonData_failed_ingredient_add = new
{
success = false,
message = "Ingredient not added to database",
redirect = false
};
var result = JObject.FromObject(jsonData_failed_ingredient_add);
return(Content(result.ToString(), "Application/json"));
}
}
if (db.UserIngredients.Where(s => s.LabelledIngredientID == ingredientID && s.userID == userID).Count() > 0)
{
var existingRecord = db.UserIngredients.FirstOrDefault(s => s.LabelledIngredientID == ingredientID && s.userID == userID);
existingRecord.Label = assignLabel;
db.SaveChanges();
var jsonData_edit_record = new
{
success = true,
message = "Label has been changed in the record",
redirect = false
};
var result = JObject.FromObject(jsonData_edit_record);
return(Content(result.ToString(), "Application/json"));
}
else
{
UserIngredient userIng = new UserIngredient(userID, assignLabel, ingredientID);
try
{
db.UserIngredients.Add(userIng);
db.SaveChanges();
var jsonData_success = new
{
success = true,
message = "Label has been saved.",
redirect = false
};
var result = JObject.FromObject(jsonData_success);
return(Content(result.ToString(), "Application/json"));
}
catch
{
var jsonData_fail = new
{
success = false,
message = "Something went wrong",
redirect = false
};
var result2 = JObject.FromObject(jsonData_fail);
return(Content(result2.ToString(), "Application/json"));
}
}
}
var jsonData3 = new
{
success = false,
message = "User not logged in.",
redirect = true
};
var result3 = JObject.FromObject(jsonData3);
return(Content(result3.ToString(), "Application/json"));
}
public bool AddRouteInformationItems(IEnumerable<RouteInformationItem> rlist)
{
using (FFDBContext context = new FFDBContext())
{
try
{
foreach (RouteInformationItem item in rlist)
{
context.RouteItems.Add(item);
}
context.SaveChanges();
return true;
}
catch (Exception ex)
{
Logger.Error("向数据库中添加新纪录失败", ex);
return false;
}
}
}
public bool ImportRouteInformationItems(IEnumerable<RouteInformationItem> importlist)
{
// insert列表
IList<RouteInformationItem> insertlist = importlist.Where(ri => ri.Id == 0).ToList();
// update列表
IList<RouteInformationItem> updatelist = importlist.Where(ri => ri.Id != 0).ToList();
using (FFDBContext context = new FFDBContext())
{
//设置的时间是300秒，即五分钟
context.Database.CommandTimeout = 300;
DbTransaction tran = null;
try
{
using (DbConnection conn = ((IObjectContextAdapter)context).ObjectContext.Connection)
{
conn.Open();
using (tran = conn.BeginTransaction())
{
// insert
foreach (RouteInformationItem item in insertlist)
{
item.CreateDate = DateTime.Now;
item.UpdateDate = DateTime.Now;
item.IsDeleted = false;
context.RouteItems.Add(item);
}
// 要更新的所有记录ID
int[] idInFiles = importlist.Where(ri => ri.Id != 0).Select(ri => ri.Id).ToArray();
// 数据库中要更新的数据
IEnumerable<RouteInformationItem> db_updatelist = context.RouteItems.Where(ri => idInFiles.Contains(ri.Id)).ToList();
foreach (RouteInformationItem item in updatelist)
{
RouteInformationItem dbitem = db_updatelist.Single(ri => ri.Id == item.Id);
dbitem.ShipName = item.ShipName;
dbitem.StartPort = item.StartPort;
dbitem.DestinationPort = item.DestinationPort;
dbitem.StartDay = item.StartDay;
dbitem.Price_20GP = item.Price_20GP;
dbitem.Price_40GP = item.Price_40GP;
dbitem.Price_40HQ = item.Price_40HQ;
dbitem.Nonstop = item.Nonstop;
dbitem.SailDayLength = item.SailDayLength;
dbitem.ValidDate = item.ValidDate;
dbitem.Remarks = item.Remarks;
dbitem.IsSingleContainer = item.IsSingleContainer;
dbitem.UpdateDate = DateTime.Now;
}
// 参与重新导入的所有企业ID
int[] companyIDs = importlist.Select(ri => ri.CompanyId).Distinct().ToArray<int>();
// 数据库中现存的所有要参与重新导入企业的旧的信息
int[] oldDestinationIDs = context.RouteItems.Where(ri => companyIDs.Contains<int>(ri.CompanyId)).Select(ri => ri.Id).ToArray<int>();
// 要删除的 数据库ID
int[] deleteIDs = oldDestinationIDs.Except(idInFiles).ToArray();
IEnumerable<RouteInformationItem> deletelist = context.RouteItems.Where(ri => deleteIDs.Contains(ri.Id)).ToList();
// delete
foreach (RouteInformationItem item in deletelist)
{
// context.RouteItems.Remove(item);
item.IsDeleted = true;
item.DeleteDate = DateTime.Now;
}
context.SaveChanges();
// 提交事务
tran.Commit();
}
}
return true;
}
catch (Exception ex)
{
// 回滚事务
tran.Rollback();
Logger.Error("批量更新数据失败", ex);
return false;
}
}
}
public bool DeletePackage(int pid)
{
using (FFDBContext context = new FFDBContext())
{
try
{
var package = context.UpgradePackages.SingleOrDefault(p=>p.Id == pid);
if (package != null) {
context.UpgradePackages.Remove(package);
context.SaveChanges();
return true;
}
return false;
}
catch (Exception ex)
{
throw ex;
}
}
}
public bool AssociatMachineAndRegCode(string machineCode, string regcode, int companyId)
{
using (FFDBContext context = new FFDBContext())
{
try
{
RegisterCode entity = context.RegisterCodes.Where(rc => rc.MachineCode.ToLower().Equals(machineCode.ToLower())).FirstOrDefault();
if (entity != null)
{
entity.RegCode = regcode;
entity.CompanyId = companyId;
entity.State = (int)RegCodeStates.Actived;
context.SaveChanges();
return true;
}
return false;
}
catch (Exception ex)
{
Logger.Error("服务端关联公司ID和机器码失败", ex);
return false;
}
}
}
public bool AddUpgradePackage(UpgradePackage entity)
{
using (FFDBContext context = new FFDBContext())
{
try
{
context.UpgradePackages.Add(entity);
context.SaveChanges();
return true;
}
catch (Exception ex)
{
throw ex;
}
}
}
