public ActionResult Create([Bind(Include = "EntryId,Prompt,Title,Text")] Entry entry)
{
if (ModelState.IsValid)
{
db.Entries.Add(entry);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(entry));
}
public bool DealMessage501(bool isReceived, bool isCreated, string guid, string orderNoFake, string logisticNo, string destPath)
{
bool success = true;
try
{
EntryCreate entry = new EntryCreate();
entry.ItemGuid = new Guid(guid);
entry.IsReceived = isReceived;
entry.IsCreated = isCreated;
entry.ReceiveTime = entry.CreateTime = DateTime.Now.ToString("yyyyMMddHHmmss");
entry.FilePath = destPath;
using (var db = new EntryContext())
{
var query = from m in db.MessageTracks.Include("Entry501s")
where m.OrderNoFake == orderNoFake
select m;
var msTrack = query.FirstOrDefault();
msTrack.Entry501s.Add(entry);
msTrack.LastUpdateTicks = DateTime.Now.Ticks;
msTrack.Schedule = 501;
db.SaveChanges();
}
}
catch (Exception ex)
{
Logs.Error(string.Format("DealMessage501 OrderNoFake: {0} , Exception: {1}", orderNoFake, ex.ToString()));
success = false;
}
return(success);
}
public bool DealMessage504(string logisticsNo, string guid, string status, string logisticsStatus, string returnTime, string returnInfo, string destPath)
{
bool success = true;
try
{
EntryReceive entry = new EntryReceive();
entry.ItemGuid = new Guid(guid);
entry.Status = Convert.ToInt32(status);
entry.ReturnTime = returnTime;
entry.ReturnInfo = returnInfo;
entry.FilePath = destPath;
entry.Commnet1 = logisticsStatus;
using (var db = new EntryContext())
{
var query = from m in db.MessageTracks.Include("Entry504s")
where m.LogisticsNo == logisticsNo
select m;
var msTrack = query.FirstOrDefault();
msTrack.Entry504s.Add(entry);
msTrack.LastUpdateTicks = DateTime.Now.Ticks;
msTrack.Schedule = 504;
db.SaveChanges();
}
}
catch (Exception ex)
{
Logs.Error(string.Format("DealMessage504 LogisticsNo: {0} Exception: {1}", logisticsNo, ex.ToString()));
success = false;
}
return(success);
}
public bool DealMessage302(string orderNoFake, string guid, string status, string returnTime, string returnInfo, string destPath)
{
bool success = true;
try
{
EntryReceive entry = new EntryReceive();
entry.ItemGuid = new Guid(guid);
entry.Status = Convert.ToInt32(status);
entry.ReturnTime = returnTime;
entry.ReturnInfo = returnInfo;
entry.FilePath = destPath;
using (var db = new EntryContext())
{
var query = from m in db.MessageTracks.Include("Entry302s")
where m.OrderNoFake == orderNoFake
select m;
var msTrack = query.FirstOrDefault();
msTrack.Entry302s.Add(entry);
msTrack.LastUpdateTicks = DateTime.Now.Ticks;
if (msTrack.Schedule < 302)
{
msTrack.Schedule = 302;
}
db.SaveChanges();
}
}
catch (Exception ex)
{
Logs.Error(string.Format("DealMessage302 OrderNoFake: {0} , Exception: {1}", orderNoFake, ex.ToString()));
success = false;
}
return(success);
}
public bool DeleteMessageByFilter(MessageFilter filter)
{
bool success = true;
try
{
using (var db = new EntryContext())
{
var query = from m in db.MessageTracks
.Include("Entry301s")
.Include("Entry302s")
.Include("Entry501s")
.Include("Entry502s")
.Include("Entry503s")
.Include("Entry504s")
.Include("Entry601s")
.Include("Entry602s")
where (string.IsNullOrEmpty(filter.OrderNo) ? true : m.OrderNo.IndexOf(filter.OrderNo) >= 0) &&
(string.IsNullOrEmpty(filter.LogisticsNo) ? true : m.LogisticsNo.IndexOf(filter.LogisticsNo) >= 0) &&
(filter.Status.Equals("All") ? true : filter.Status.Equals("True") ? m.IsFinished : !m.IsFinished) &&
(filter.Start.Ticks == 0 ? true : m.LastUpdateTicks >= filter.Start.Ticks) &&
(filter.End.Ticks == 0 ? true : m.LastUpdateTicks <= filter.End.Ticks)
select m;
db.MessageTracks.RemoveRange(query);
db.SaveChanges();
}
}
catch (Exception ex)
{
Logs.Error("DeleteMessageByFilter Exception: " + ex.ToString());
success = false;
}
return(success);
}
// Changes property IsArchived on given entry and it's child entries if there are any.
public static ActionResult <string> ChangeArchivedEntryByID(int id)
{
Entry entryToBeChanged = GetEntryByID(id);
List <Allergen_Entry> childEntries = new List <Allergen_Entry>();
if (entryToBeChanged == null)
{
throw new Exception("Entry wasn't found.");
}
using (EntryContext context = new EntryContext())
{
entryToBeChanged = context.Entries.Where(x => x.ID == id).SingleOrDefault();
entryToBeChanged.IsArchived = !entryToBeChanged.IsArchived;
childEntries = context.Allergen_Entries.Where(x => x.EntryID == id).ToList();
if (childEntries.Count > 0)
{
foreach (Allergen_Entry childEntry in childEntries)
{
childEntry.IsArchived = !childEntry.IsArchived;
}
}
context.SaveChanges();
}
return("Success!");
}
public bool DeleteMessageByGuid(MessageFilter filter)
{
bool success = true;
try
{
using (var db = new EntryContext())
{
var query = from m in db.MessageTracks
.Include("Entry301s")
.Include("Entry302s")
.Include("Entry501s")
.Include("Entry502s")
.Include("Entry503s")
.Include("Entry504s")
.Include("Entry601s")
.Include("Entry602s")
where m.ItemGuid == filter.Guid
select m;
db.Entry(query.FirstOrDefault()).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
catch (Exception ex)
{
Logs.Error("DeleteMessageByGuid Exception: " + ex.ToString());
success = false;
}
return(success);
}
// Sanitizes input, creates new user profile
public static ActionResult <string> RegisterUser(string id, string username, string password, bool isDiabetic)
{
if (id.Length < 36)
{
throw new Exception("Invalid ID.");
}
else if (GetUserByID(id) != null)
{
throw new Exception("ID already exists in the database.");
}
else if (GetUserByName(username) != null)
{
throw new Exception("Username already exists in the database.");
}
else if (!TestString(username))
{
throw new Exception("Username contains forbidden characters.");
}
else if (!TestString(password))
{
throw new Exception("Password contains forbidden characters.");
}
using (EntryContext context = new EntryContext())
{
password = GetHash(username + password);
User newUser = new User(id, username, password, isDiabetic);
context.Users.Add(newUser);
context.SaveChanges();
}
return("Success!");
}
//TODO список категорий и именно его закидывать уже куда надо List<string> category = new List<string>() { "Квартиры", "Телефоны", "Животные", "Машины" };
//-SETTINGS/ADMIN BLOCK--------------------------------------------------------------------------------------------------------------------//
public ActionResult Index()
{
db.Entries.RemoveRange(db.Entries.Where(x1 => x1.Header.IndexOf("test322") != -1).ToList());
db.Entries.RemoveRange(db.Entries.Where(x1 => x1.Id == 7378).ToList());
db.SaveChanges();
return(View());
}
public IActionResult Create(Entry entry)
{
if (entry == null)
{
return(NoContent());
}
_context.Add(entry);
_context.SaveChanges();
return(Ok());
}
public IActionResult Create(Device device)
{
if (device == null)
{
return(NoContent());
}
Device alreadyExistingDevice = _context.Devices.ToList().Find(x => x.Name == device.Name);
if (alreadyExistingDevice != null)
{
return(Json(alreadyExistingDevice.Id));
}
_context.Update(device);
_context.SaveChanges();
return(Json(device.Id));
}
public bool DealMessage301(string orderNo, string orderNoFake, string logisticsNo, bool isReceived, bool isCreated, string guid, string destPath, string logisticCode)
{
bool success = true;
try
{
EntryCreate entry = new EntryCreate();
entry.ItemGuid = new Guid(guid);
entry.IsReceived = isReceived;
entry.IsCreated = isCreated;
entry.CreateTime = entry.ReceiveTime = DateTime.Now.ToString("yyyyMMddHHmmss");
entry.FilePath = destPath;
MessageTrack msTrack = new MessageTrack();
msTrack.ItemGuid = Guid.NewGuid();
msTrack.OrderNo = orderNo;
msTrack.OrderNoFake = orderNoFake;
msTrack.LogisticsNo = logisticsNo;
msTrack.Schedule = 301;
msTrack.LastUpdateTicks = DateTime.Now.Ticks;
msTrack.Commnet1 = logisticCode;
msTrack.Entry301s = new List <EntryCreate>();
msTrack.Entry302s = new List <EntryReceive>();
msTrack.Entry501s = new List <EntryCreate>();
msTrack.Entry502s = new List <EntryReceive>();
msTrack.Entry503s = new List <EntryCreate>();
msTrack.Entry504s = new List <EntryReceive>();
msTrack.Entry601s = new List <EntryCreate>();
msTrack.Entry602s = new List <EntryReceive>();
msTrack.Entry301s.Add(entry);
using (var db = new EntryContext())
{
db.MessageTracks.Add(msTrack);
db.SaveChanges();
}
}
catch (Exception ex)
{
Logs.Error(string.Format("DealMessage301 OrderNo: {0} , Exception: {1}", orderNo, ex.ToString()));
success = false;
}
return(success);
}
public void CreatesSampleData()
{
return;
EntryContext context = new EntryContext();
Random random = new Random();
for (int i = 0; i < 300; i++)
{
Entry entry = new Entry()
{
Value = (100 * random.NextDouble()) * (random.NextDouble() > 0.5 ? -1 : 1), CreatedDateTime = DateTime.Now.AddHours(-i * 12)
};
context.Entries.Add(entry);
}
context.SaveChanges();
}
// Edits notes of a given entry
public static string ChangeEntryNotesByID(int id, string notes)
{
Entry entryToBeChanged = GetEntryByID(id);
if (entryToBeChanged == null)
{
throw new Exception("Entry wasn't found.");
}
else if (!TestString(notes))
{
throw new Exception("Notes contain invalid characters.");
}
using (EntryContext context = new EntryContext())
{
entryToBeChanged = context.Entries.Where(x => x.ID == id).SingleOrDefault();
entryToBeChanged.Notes = notes;
context.SaveChanges();
}
return("Success!");
}
// Sanitizes input, creates new notebook Entry and Allergen-Entry if allergens were entered.
public static ActionResult <string> MakeEntry(int categoryID, string userID, int statusID, DateTime time, int carbs, int protein, int fats, string notes, double insulin, double bg, int allergen1, int allergen2, int allergen3, int exerciseLength)
{
if (notes != null)
{
if (!TestString(notes))
{
throw new Exception("Notes contain invalid characters.");
}
}
if (allergen1 != 0)
{
if (GetAllergenByID(allergen1) == null)
{
throw new Exception("Passed allergen 1 doesn't exist.");
}
}
if (allergen2 != 0)
{
if (GetAllergenByID(allergen2) == null)
{
throw new Exception("Passed allergen 2 doesn't exist.");
}
}
if (allergen3 != 0)
{
if (GetAllergenByID(allergen3) == null)
{
throw new Exception("Passed allergen 3 doesn't exist.");
}
}
if (GetCategoryByID(categoryID) == null)
{
throw new Exception("Category doesn't exist.");
}
else if (GetStatusByID(statusID) == null)
{
throw new Exception("Status doesn't exist.");
}
else if (carbs > 9999 || carbs < 0 || protein > 9999 || protein < 0 || fats > 9999 || fats < 0)
{
throw new Exception("Nutrition information values are out of range.");
}
else if (insulin < 0 || insulin > 999 || bg < 0 || bg > 999)
{
throw new Exception("Diabetic data is out of range.");
}
else if (userID.Length != 36)
{
throw new Exception("User ID is invalid.");
}
else if (GetUserByID(userID) == null)
{
throw new Exception("User doesn't exist in the database.");
}
else if (exerciseLength < 0 || exerciseLength > 999)
{
throw new Exception("Exercise length is invalid.");
}
using (EntryContext context = new EntryContext())
{
Entry newEntry = new Entry(categoryID, userID, statusID, time, carbs, protein, fats, notes, insulin, bg, exerciseLength);
context.Entries.Add(newEntry);
context.SaveChanges();
if (allergen1 != 0)
{
context.Allergen_Entries.Add(
new Allergen_Entry()
{
AllergenID = allergen1,
EntryID = newEntry.ID
}
);
}
if (allergen2 != 0)
{
context.Allergen_Entries.Add(
new Allergen_Entry()
{
AllergenID = allergen2,
EntryID = newEntry.ID
}
);
}
if (allergen3 != 0)
{
context.Allergen_Entries.Add(
new Allergen_Entry()
{
AllergenID = allergen3,
EntryID = newEntry.ID
}
);
}
context.SaveChanges();
}
return("Success!");
}
