public ActionResult Create(PocoClasses.Entries.Team newTeam, int entryId)
{
Mapper.Initialize(cfg => cfg.CreateMap <PocoClasses.Entries.Team, Team>());
Team team = Mapper.Map <Team>(newTeam);
team.EntryId = entryId;
if (ModelState.IsValid)
{
using (var context = new TeamContext())
{
var service = new TeamService(context);
service.Add(team);
}
using (var context = new RaceEntryContext())
{
var service = new RaceEntryService(context);
service.Add(team.Id, newTeam.EventId);
}
Entry entry;
using (var context = new EntryContext())
{
var service = new EntryService(new RosContext <Entry>());
entry = service.GetById(entryId);
}
return(RedirectToAction("Index", entry));
}
return(View(team));
}
public static Allergen GetAllergenByID(int allergenID)
{
using (EntryContext context = new EntryContext())
{
return(context.Allergens.Where(x => x.ID == allergenID).SingleOrDefault());
}
}
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);
}
public MessageTrack GetMessageTrackByGuid(MessageFilter Filter)
{
MessageTrack result = null;
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;
result = query.FirstOrDefault();
}
}
catch (Exception ex)
{
Logs.Error("GetMessageTrackByGuid Exception: " + ex.ToString());
}
return(result);
}
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);
}
// 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 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);
}
// 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!");
}
public static Entry GetEntryByID(int id)
{
using (EntryContext context = new EntryContext())
{
return(context.Entries.Where(x => x.ID == id).SingleOrDefault());
}
}
public static ActionResult <List <Allergen> > GetAllergens()
{
using (EntryContext context = new EntryContext())
{
return(context.Allergens.OrderBy(x => x.Name).ToList());
}
}
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 List <MessageTrack> GetMessageTracksByFilter(MessageFilter filter)
{
List <MessageTrack> result = null;
try
{
Logs.Debug("GetMessageTracksByFilter Start! Filter:" + JsonConvert.SerializeObject(filter));
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)
orderby m.LastUpdateTicks descending
select m;
result = query.ToList();
}
Logs.Debug("GetMessageTracksByFilter End! Result Count:" + result.Count);
}
catch (Exception ex)
{
Logs.Error("GetAllMessageTracks Exception: " + ex.ToString());
}
return(result);
}
public static ActionResult <List <Status> > GetStatuses()
{
using (EntryContext context = new EntryContext())
{
return(context.Statuses.OrderBy(x => x.Name).ToList());
}
}
public List <MessageTrack> GetAllMessageTracks()
{
var start = DateTime.Now.AddDays(-10);
List <MessageTrack> result = null;
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.IsFinished && m.LastUpdateTicks >= start.Ticks
orderby m.LastUpdateTicks descending
select m;
result = query.ToList();
}
}
catch (Exception ex)
{
Logs.Error("GetAllMessageTracks Exception: " + ex.ToString());
}
return(result);
}
static void Main()
{
var context = new EntryContext();
context.Database.EnsureCreated();
var controller = new Controller(context);
controller.Run();
}
public static Status GetStatusByID(int id)
{
Status status;
using (EntryContext context = new EntryContext())
{
status = context.Statuses.Where(x => x.ID == id).SingleOrDefault();
}
return(status);
}
public static User GetUserByName(string username)
{
User user;
using (EntryContext context = new EntryContext())
{
user = context.Users.Where(x => x.Username == username).SingleOrDefault();
}
return(user);
}
public static User GetUserByID(string id)
{
User user;
using (EntryContext context = new EntryContext())
{
user = context.Users.Where(x => x.ID == id).SingleOrDefault();
}
return(user);
}
public static Category GetCategoryByID(int id)
{
Category category;
using (EntryContext context = new EntryContext())
{
category = context.Categories.Where(x => x.ID == id).SingleOrDefault();
}
return(category);
}
public EntryService(IOptions <Settings> options, IMapper mapper, ICommentService commentService, IUserService userService)
{
if (options is null)
{
throw new ArgumentNullException(nameof(options));
}
context = new EntryContext(options);
this.mapper = mapper ?? throw new ArgumentNullException(nameof(mapper));
this.commentService = commentService ?? throw new ArgumentNullException(nameof(commentService));
this.userService = userService ?? throw new ArgumentNullException(nameof(userService));
}
public static ActionResult <List <Category> > GetCategories(bool diabetic = false)
{
using (EntryContext context = new EntryContext())
{
if (diabetic)
{
return(context.Categories.ToList());
}
else
{
return(context.Categories.Where(x => x.IsDiabetic == false).ToList());
}
}
}
public override bool Sync(IEnumerable <Guid> remove, IEnumerable <Entry> add)
{
var ancestorDb = new AncestorContext();
var entryDb = new EntryContext();
try
{
entryDb.Database.BeginTransaction();
var now = DateTime.UtcNow;
if (add != null)
{
foreach (var entry in add)
{
entryDb.Write(entry.Key, entry.Id, entry.Map, now);
ancestorDb.Write(entry.Id, entry.Key, now);
foreach (var ancestor in entry.Ancestors)
{
ancestorDb.Write(ancestor, entry.Key, now);
}
}
}
if (remove != null)
{
foreach (var guid in remove)
{
ancestorDb.Delete(guid, now);
entryDb.Delete(guid, now);
}
}
entryDb.Database.CompleteTransaction();
return(true);
}
catch (Exception ex)
{
LogHelper.Error <SqlIndexer>($"Error trying to sync content with indexer", ex);
}
try
{
entryDb.Database.AbortTransaction();
}
catch (Exception)
{
// Just swallow the error, as the previous catch above would have logged it
}
return(false);
}
public override void Up()
{
try
{
// Create tables
_schemaHelper.CreateTable <Dto.Entry.Entry100>();
_schemaHelper.CreateTable <Dto.Ancestor.Ancestor100>();
// Scrape all existing content and place into the index
var ancestorDb = new AncestorContext();
var entryDb = new EntryContext();
var now = DateTime.UtcNow;
var contents = new Stack <Umbraco.Core.Models.IContent>();
var contentService = ApplicationContext.Current.Services.ContentService;
foreach (var content in contentService.GetChildren(Umbraco.Core.Constants.System.Root))
{
if (content.Published)
{
contents.Push(content);
}
}
while (contents.Count != 0)
{
var content = contents.Pop();
foreach (var child in contentService.GetChildren(content.Id))
{
if (child.Published)
{
contents.Push(child);
}
}
foreach (var entry in new ContentService().Entries(new Umbraco.Core.Models.IContent[] { content }))
{
entryDb.Write(entry.Key, entry.Id, entry.Map, now);
ancestorDb.Write(entry.Id, entry.Key, now);
foreach (var ancestor in entry.Ancestors)
{
ancestorDb.Write(ancestor, entry.Key, now);
}
}
System.Threading.Thread.Sleep(50);
}
}
catch (Exception ex)
{
LogHelper.Error <SqlIndexer>($"Error trying to create content with indexer", ex);
}
}
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();
}
public string GetLogisticCodeByLogisticsNo(string logisticsNo)
{
string result = null;
try
{
using (var db = new EntryContext())
{
var query = from m in db.MessageTracks
where m.LogisticsNo.Equals(logisticsNo)
select m.Commnet1;
result = query.FirstOrDefault().ToString();
}
}
catch (Exception ex)
{
Logs.Error(string.Format("GetLogisticCodeByLogisticsNo OrderNoFake: {0} , Exception: {1}", logisticsNo, ex.ToString()));
}
return(result);
}
public EntryContext entry()
{
EntryContext _localctx = new EntryContext(Context, State);
EnterRule(_localctx, 2, RULE_entry);
int _la;
try {
EnterOuterAlt(_localctx, 1);
{
State = 15;
ErrorHandler.Sync(this);
_la = TokenStream.LA(1);
if (_la == DASH)
{
{
State = 14;
Match(DASH);
}
}
State = 17;
_localctx.k = key();
State = 18;
Match(EQUALS);
State = 19;
_localctx.v = value();
}
}
catch (RecognitionException re) {
_localctx.exception = re;
ErrorHandler.ReportError(this, re);
ErrorHandler.Recover(this, re);
}
finally {
ExitRule();
}
return(_localctx);
}
public ActionResult Join(JoinEntry joinEntry)
{
try
{
int entryId;
using (var context = new EntryContext())
{
var entryLogicService = new EntryService();
entryId = entryLogicService.GetByEntryNumber(int.Parse(joinEntry.EntryNumber)).Id;
}
using (var context = new RegisteredUserContext())
{
var regUserService = new RegisteredUserService(context);
regUserService.JoinEntry(int.Parse(User.Identity.Name), entryId);
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw new Exception("EF broke... Ask robin");
}
return(View());
}
// Checkes if combination of username and password exist in database using hashed password, validates user
public static List <string> ValidateUser(string username, string password)
{
List <string> validateReturn = new List <string>();
if (GetUserByName(username) == null)
{
throw new Exception("Wrong username or password.");
}
else if (!TestString(username))
{
throw new Exception("Username contains forbidden characters.");
}
else if (!TestString(password))
{
throw new Exception("Password contains forbidden characters.");
}
User user;
password = GetHash(username + password);
using (EntryContext context = new EntryContext())
{
user = context.Users.Where(x => x.Username == username && x.Password == password).SingleOrDefault();
}
if (user == null)
{
throw new Exception("Wrong username or password.");
}
else
{
validateReturn.Add("Success!");
validateReturn.Add(user.ID);
validateReturn.Add(user.IsDiabetic.ToString().ToLower());
return(validateReturn);
}
}
