public decimal GetResult(int questionIndex, int answerIndex)
{
// Logging
using (var context = new LoggerContext())
{
var log = context.UserAnswerLogs.Where(q => q.QuestionNumber == questionIndex).FirstOrDefault();
if (log == null)
{
log = new UserAnswerLog()
{
QuestionNumber = questionIndex, FirstAnswerCount = 0, SecondAnswerCount = 0, ThirdAnswerCount = 0, FourthAnswerCount = 0
};
log = context.UserAnswerLogs.Add(log);
context.SaveChanges();
}
if (answerIndex == 0)
{
log.FirstAnswerCount++;
}
if (answerIndex == 1)
{
log.SecondAnswerCount++;
}
if (answerIndex == 2)
{
log.ThirdAnswerCount++;
}
if (answerIndex == 3)
{
log.FourthAnswerCount++;
}
context.SaveChanges();
}
using (var xmlReader = XmlReader.Create(_xmlUrl))
{
var questions = new XmlQuestionRepository(xmlReader).GetAll();
if (questions[questionIndex].CorrectAnswer == questions[questionIndex].Answers.ElementAt(answerIndex))
{
if (questionIndex != questions.Count - 1)
{
// Game still on
return(-1);
}
else
{
// Player wins
return(questions[questionIndex].Price);
}
}
else
{
// Calculating prize as first guaranteed question
return(CalculateResult(questionIndex));
}
}
}
public ActionResult Index(FormCollection form)
{
form["Title"] = form["Title"].Trim();
form["Text"] = form["Text"].Trim();
if (String.IsNullOrEmpty(form["Title"]))
{
loggerDb.ExceptionDetails.Add(new ExceptionDetail()
{
Date = DateTime.Now, ActionName = "Index", ControllerName = "CreateArticle", ExceptionMessage = "Title of article is empty"
});
loggerDb.SaveChanges();
}
if (String.IsNullOrEmpty(form["Text"]))
{
loggerDb.ExceptionDetails.Add(new ExceptionDetail()
{
Date = DateTime.Now, ActionName = "Index", ControllerName = "CreateArticle", ExceptionMessage = "Content of article is empty"
});
loggerDb.SaveChanges();
}
if (String.IsNullOrEmpty(form["Title"]))
{
ModelState.AddModelError("Title", "Please enter title.");
}
else if (form["Title"].Length < 3 || form["Title"].Length > 30)
{
ModelState.AddModelError("Title", "Title must be 3-30 characters in length.");
}
else if (!Regex.Match(form["Title"], "^[A-Za-zА-Яа-яЁёІі1-9\\s]+$").Success)
{
ModelState.AddModelError("Title", "Invalid title.");
}
if (String.IsNullOrEmpty(form["Text"]))
{
ModelState.AddModelError("Text", "Please enter your article.");
}
else if (form["Text"].Length < 3 || form["Text"].Length > 1000)
{
ModelState.AddModelError("Text", "Article must be 3-300 characters in length.");
}
if (ModelState.IsValid)
{
articleService.AddItem(new ArticleDto()
{
Title = form["Title"], Date = DateTime.Now, Text = form["Text"]
});
return(RedirectToAction("Index", "Home"));
}
return(Index());
}
public void AddLog(string type, string message)
{
_context.Logs.Add(new Log {
Date = DateTime.Now, Type = type, Messege = message
});
_context.SaveChanges();
}
public IActionResult ClearLog()
{
var logs = _context.EventLog;
_context.RemoveRange(logs);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
private bool Save()
{
try
{
_dbContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
_logger.LogError("Db Error: ", ex.ToString());
return(false);
}
}
public void Log <TState>(LogLevel logLevel, EventId eventId, TState state, Exception exception, Func <TState, Exception, string> formatter)
{
using (var context = new LoggerContext(options.LoggerConnectionString))
{
context.Database.EnsureCreated();
var log = new LogModel("Error", state.ToString(), exception.GetType().ToString(), exception.StackTrace)
{
EventId = eventId.Id
};
context.Set <LogModel>().Add(log);
context.SaveChanges();
//context.Set<LogModel>().Add()
}
}
private void LogToDatabase(string mode, string message, string exceptionMessage)
{
Log DbLogger = new Log()
{
LogDate = DateTime.Now.Date,
LogTime = DateTime.Now.TimeOfDay,
Logger = Logger,
LogMode = mode,
LogMessage = message,
ExceptionMessage = exceptionMessage
};
Context.Logs.Add(DbLogger);
Context.SaveChanges();
}
public IActionResult DeleteById(int id, [FromHeader] string UserRole)
{
var deletedLogItem = _context.LogItems.Find(id);
if (deletedLogItem == null)
{
return(StatusCode(StatusCodes.Status404NotFound));
}
if (UserRole != "Admin")
{
return(StatusCode(StatusCodes.Status403Forbidden));
}
_context.LogItems.Remove(deletedLogItem);
var success = _context.SaveChanges();
if (success < 1)
{
return(StatusCode(StatusCodes.Status400BadRequest));
}
return(StatusCode(StatusCodes.Status202Accepted, new JsonResult(deletedLogItem)));
}
void IExceptionFilter.OnException(ExceptionContext filterContext)
{
ExceptionDetail exceptionDetail = new ExceptionDetail()
{
ExceptionMessage = filterContext.Exception.Message,
StackTrace = filterContext.Exception.StackTrace,
ControllerName = filterContext.RouteData.Values["controller"].ToString(),
ActionName = filterContext.RouteData.Values["action"].ToString(),
Date = DateTime.Now
};
using (LoggerContext db = new LoggerContext())
{
db.ExceptionDetails.Add(exceptionDetail);
db.SaveChanges();
}
}
public void Log <TState>(LogLevel logLevel, EventId eventId, TState state, Exception exception, Func <TState, Exception, string> formatter)
{
if (!IsEnabled(logLevel))
{
return;
}
if (_selfException)
{
_selfException = false;
return;
}
_selfException = true;
if (formatter == null)
{
throw new ArgumentNullException(nameof(formatter));
}
var message = formatter(state, exception);
if (string.IsNullOrEmpty(message))
{
return;
}
if (exception != null)
{
message += "\n" + exception.ToString();
}
try
{
var maxMessageLength = GetMaxMessageLength();
message = maxMessageLength != null && message.Length > maxMessageLength?message.Substring(0, (int)maxMessageLength) : message;
_context.EventLogs.Add(new EventLog {
Message = message, EventId = eventId.Id, LogLevel = logLevel.ToString(), CreatedTime = DateTime.UtcNow
});
_context.SaveChanges();
_selfException = false;
}
catch (Exception ex)
{
var test = ex;
}
}
public void OnException(ExceptionContext filterContext)
{
Database.SetInitializer <LoggerContext>(new DropCreateDatabaseIfModelChanges <LoggerContext>());
ExceptionDetail exceptionDetail = new ExceptionDetail()
{
ExceptionMessage = filterContext.Exception.Message,
StackTrace = filterContext.Exception.StackTrace,
ControllerName = filterContext.RouteData.Values["controller"].ToString(),
ActionName = filterContext.RouteData.Values["action"].ToString(),
Date = DateTime.Now
};
using (LoggerContext db = new LoggerContext())
{
db.ExceptionDetails.Add(exceptionDetail);
db.SaveChanges();
}
filterContext.ExceptionHandled = true;
}
public void OnActionExecuted(ActionExecutedContext filterContext)
{
log4net.ILog logger = log4net.LogManager.GetLogger(typeof(HomeController)); //Declaring Log4Net
Database.SetInitializer <LoggerContext>(new DropCreateDatabaseIfModelChanges <LoggerContext>());
ReauesDetail reauesDetail = new ReauesDetail()
{
Requesttime = filterContext.HttpContext.Request.TimedOutToken.ToString(),
RequestURI = filterContext.HttpContext.Request.Url.ToString(),
Querystring = filterContext.HttpContext.Handler.ToString(),
StatusCode = filterContext.HttpContext.Response.StatusCode.ToString()
};
using (LoggerContext db = new LoggerContext())
{
db.ReauesDetails.Add(reauesDetail);
db.SaveChanges();
logger.Info(reauesDetail);
}
filterContext.ExceptionHandled = true;
}
public void Log(TideLog log)
{
_context.Add(log);
_context.SaveChanges();
}
public void Log(TideLog log)
{
log.DateTime = DateTime.Now;
_context.Add(log);
_context.SaveChanges();
}
public void SaveChanges()
{
_context.SaveChanges();
}
public void Commit()
{
db.SaveChanges();
}
public IEnumerable <Resource> UpdateList(IEnumerable <Resource> resources)
{
var createdVehicles = new List <Resource>();
var updatedVehicles = new List <Resource>();
var createdPersonnel = new List <Resource>();
var updatedPersonnel = new List <Resource>();
foreach (var resource in resources)
{
var entity = GetById(resource.ResourceId);
if (entity == null)
{
if (resource.Type == Enums.ResourceType.Personnel)
{
createdPersonnel.Add(resource);
}
else
{
createdVehicles.Add(resource);
}
_context.Database.OpenConnection();
_context.Resource.Add(resource);
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Resource ON");
_context.SaveChanges();
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Resource OFF");
}
else
{
if (!(entity.Available.Equals(resource.Available) && entity.Location.Equals(resource.Location) && entity.Type.Equals(resource.Type) && entity.CertificationLevel.Equals(resource.CertificationLevel) && entity.VehicleType.Equals(resource.VehicleType)))
{
if (resource.Type == Enums.ResourceType.Personnel)
{
updatedPersonnel.Add(resource);
}
else
{
updatedVehicles.Add(resource);
}
entity.Available = resource.Available;
entity.Location = resource.Location;
entity.Type = resource.Type;
entity.CertificationLevel = resource.CertificationLevel;
entity.VehicleType = resource.VehicleType;
_context.Resource.Update(entity);
_context.Database.OpenConnection();
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Resource ON");
_context.SaveChanges();
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Resource OFF");
}
}
}
if (updatedPersonnel.Count > 0)
{
var eventLog = new EventLog();
eventLog.LogLevel = "Update";
eventLog.CreatedTime = DateTime.Now;
eventLog.EventId = (int)LoggingEvent.UPDATE_ITEM;
eventLog.Message = ("Just updated " + NumberToWords(updatedPersonnel.Count) + " Marine's Information");
_logger.EventLog.Add(eventLog);
_logger.SaveChanges();
}
if (updatedVehicles.Count > 0)
{
var eventLog = new EventLog();
eventLog.LogLevel = "Update";
eventLog.CreatedTime = DateTime.Now;
eventLog.EventId = (int)LoggingEvent.UPDATE_ITEM;
eventLog.Message = ("Just updated " + NumberToWords(updatedVehicles.Count) + " Vehicle's Information");
_logger.EventLog.Add(eventLog);
_logger.SaveChanges();
}
if (createdVehicles.Count > 0)
{
var eventLog = new EventLog();
eventLog.CreatedTime = DateTime.Now;
eventLog.LogLevel = "Creation";
eventLog.EventId = (int)LoggingEvent.CREATE_ITEM;
eventLog.Message = ("Just created " + NumberToWords(createdVehicles.Count) + " Vehicle's Information");
_logger.EventLog.Add(eventLog);
_logger.SaveChanges();
}
if (createdPersonnel.Count > 0)
{
var eventLog = new EventLog();
eventLog.CreatedTime = DateTime.Now;
eventLog.LogLevel = "Creation";
eventLog.EventId = (int)LoggingEvent.CREATE_ITEM;
eventLog.Message = ("Just created " + NumberToWords(createdPersonnel.Count) + " Marine's Information");
_logger.EventLog.Add(eventLog);
_logger.SaveChanges();
}
return(resources);
}
public void Add(PlayerStatistic playerStatistic)
{
_context.PlayerStatistics.Add(playerStatistic);
_context.SaveChanges();
}
