public ActionResult Edit(int id, UsersEdit form)
{
using (db = new MainDBContext())
{
var user = db.Users.Find(id);
if (user == null)
{
return(HttpNotFound());
}
SyncRoles(form.Roles, user.Roles);
if (db.Users.Any(u => u.Username == form.Username && u.UserId != id))
{
ModelState.AddModelError("Username", "Username must be unique!");
}
if (!ModelState.IsValid)
{
return(View(form));
}
user.Username = form.Username;
user.Email = form.Email;
db.SaveChanges();
return(RedirectToAction("index"));
}
}
public JobMgr(ILogger <JobMgr> logger, MainDBContext mainDBContext,
OldDBContext oldDBContext)
{
_logger = logger;
_mainDBContext = mainDBContext;
_oldDBContext = oldDBContext;
}
public ActionResult Show(string idAndSlug)
{
var parts = SepreateIdAndSlug(idAndSlug);
if (parts == null)
{
return(HttpNotFound());
}
using (db = new MainDBContext())
{
var post = db.Posts.Find(parts.Item1);
if (post == null || post.IsDeleted)
{
return(HttpNotFound());
}
if (!post.Slug.Equals(parts.Item2, StringComparison.CurrentCultureIgnoreCase))
{
return(RedirectToRoutePermanent("Post", new { id = parts.Item1, slug = post.Slug }));
}
var newPost = new PostsShow
{
Post = post
};
newPost.Post.Tags = post.Tags.ToList();
return(View(newPost));
}
}
public ActionResult Edit(int id)
{
using (db = new MainDBContext())
{
var user = db.Users.Find(id);
if (user == null)
{
return(HttpNotFound());
}
var userEdit = new UsersEdit();
userEdit.Username = user.Username; // user.Roles.Contains(role)
userEdit.Email = user.Email;
var userRoles = user.Roles;
//var dbRoles = db.Roles.ToList();
// was stuck here for hours - all I had to do was put the db.Roles into a list becuase it was of type dbset wich aparently is not a primitive type
userEdit.Roles = db.Roles.ToList().Select(role => new RoleCheckBox
{
Id = role.RoleId,
IsChecked = user.Roles.Contains(role),
Name = role.Name
}).ToList();
return(View(userEdit));
}
}
public JObject Login([FromBody] UserModel userModel)
{
if (!ModelState.IsValid)
{
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet
{
ResultCode = ResultCode.Error,
Message = string.Join("\n", ModelState.Values.Select(x => x.Errors).SelectMany(x => x).Select(x => x.ErrorMessage))
})));
}
MainDBContext mainDBContext = new MainDBContext();
var user = mainDBContext.Users.FirstOrDefault(x => x.Nickname == userModel.Login);
if (user != null)
{
if (CryptService.GetMd5Hash(userModel.Password) == user.PasswordHash)
{
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet
{
ResultCode = ResultCode.Success,
WorkID = user.ID,
IsTestWork = mainDBContext.Statisics.Where(x => x.User == user).Count() > 0
})));
}
}
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet {
ResultCode = ResultCode.ErrorLoginPassword
})));
}
public ActionResult Edit(int id)
{
using (db = new MainDBContext())
{
var post = db.Posts.Find(id);
if (post == null)
{
return(HttpNotFound());
}
return(View("Form", new PostsForm
{
IsNew = false,
PostId = id,
Content = post.Content,
Slug = post.Slug,
Title = post.Title,
Tags = db.Tags.ToList().Select(tag => new TagCheckBox
{
Id = tag.TagId,
Name = tag.Name,
IsChecked = post.Tags.Contains(tag)
}).ToList()
}));
}
}
public BLLService(MainDBContext dBContext)
{
unit = new UnitOfWork(dBContext);
var mapConfig = new MapperConfiguration(c =>
{
c.CreateMap <Flight, FlightDTO>().ReverseMap();
c.CreateMap <Departure, DepartureDTO>().ReverseMap();
c.CreateMap <Ticket, TicketDTO>().ReverseMap();
c.CreateMap <Crew, CrewDTO>().ReverseMap();
c.CreateMap <Pilot, PilotDTO>().ForMember(e => e.StartedIn, opt => opt.Ignore());
c.CreateMap <PilotDTO, Pilot>().ForMember(e => e.Experience, opt => opt.MapFrom(src => (DateTime.Today.Subtract(src.StartedIn))))
.ForMember(e => e.TimeTicks, opt => opt.Ignore());
c.CreateMap <Plane, PlaneDTO>().ForMember(e => e.ExpiryDate, opt => opt.Ignore());
c.CreateMap <PlaneDTO, Plane>().ForMember(e => e.OperationLife, opt => opt.MapFrom(src => (src.ExpiryDate.Subtract(src.ReleaseDate))))
.ForMember(e => e.TimeTicks, opt => opt.Ignore());
c.CreateMap <Stewardess, StewardessDTO>().ReverseMap();
c.CreateMap <PlaneType, PlaneTypeDTO>().ReverseMap();
});
mapConfig.AssertConfigurationIsValid();
if (mapper == null)
{
mapper = mapConfig.CreateMapper();
}
}
public ActionResult NewPost(PostsForm form)
{
using (db = new MainDBContext())
{
var post = new Post();
var user = db.Users.Find(1);
var selectedTags = ReconsileTags(form.Tags).ToList();
if (!ModelState.IsValid)
{
return(View(form));
}
;
post.CreatedAt = DateTime.UtcNow;
post.User = db.Users.ToList()
.FirstOrDefault(u => u.Username == System.Web.HttpContext.Current.User.Identity.Name);
foreach (var tag in selectedTags)
{
post.Tags.Add(tag);
}
;
db.Posts.Add(post);
db.SaveChanges();
return(RedirectToAction("index"));
}
}
public AdminOrderRepository(ApplicationDbContext adb, MainDBContext mdb, UserManager <AppUser> usrM, Cart cart)
{
appDbContext = adb;
mDbContext = mdb;
userManager = usrM;
this.cart = cart;
}
public JObject StartTest([FromBody] IntegerInput user)
{
MainDBContext mainDBContext = new MainDBContext();
var countQuestions = mainDBContext.Questions.Count();
var prevTest = mainDBContext.Statisics.Where(x => x.UserID == user.Value)
.Select(x => x.TestResult).FirstOrDefault(x => x.UserAnswers.Count() != countQuestions);
if (prevTest != null)
{
return(JObject.Parse(JsonConvert.SerializeObject(new StartActionNet {
IsStartPrev = true, PrevID = prevTest.ID, ResultCode = ResultCode.Success, WorkID = user.Value
})));
}
var testResult = new TestResult {
DateTime = DateTime.Now
};
var statistics = new Statisics {
TestResult = testResult, UserID = user.Value
};
mainDBContext.Entry(testResult).State = Microsoft.EntityFrameworkCore.EntityState.Added;
mainDBContext.Entry(statistics).State = Microsoft.EntityFrameworkCore.EntityState.Added;
mainDBContext.SaveChanges();
return(JObject.Parse(JsonConvert.SerializeObject(new StartActionNet {
IsStartPrev = false, WorkID = user.Value, ResultCode = ResultCode.Success, PrevID = testResult.ID
})));
}
public ActionResult New(UsersNew form)
{
using (db = new MainDBContext())
{
var user = new User();
SyncRoles(form.Roles, user.Roles);
if (db.Users.Any(u => u.Username == form.Username))
{
ModelState.AddModelError("Username", "Username must be unique!");
}
if (!ModelState.IsValid)
{
return(View(form));
}
;
user.Email = form.Email;
user.Username = form.Username;
user.SetPassword(form.Password);
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("index"));
}
}
public JObject FinishTest([FromBody] FinishTestInput integer)
{
MainDBContext mainDBContext = new MainDBContext();
if (integer.Timeout)
{
mainDBContext.Remove(mainDBContext.TestResults.Find(integer.Value));
mainDBContext.SaveChanges();
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet
{
ResultCode = integer.Timeout ? ResultCode.Success : ResultCode.Error,
WorkID = integer.Value
})));
}
var userAnswers = mainDBContext.UserAnswers.Where(x => x.TestResultID == integer.Value).Select(x => x.Question);
bool isEnd = false;
if (userAnswers.Count() > 0)
{
var type = userAnswers.First().TicketNum;
isEnd = mainDBContext.Questions.Where(x => x.TicketNum == type).Count() == userAnswers.Count();
}
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet
{
ResultCode = isEnd ? ResultCode.Success : ResultCode.Error,
WorkID = integer.Value
})));
}
// GET: Home
public ActionResult Index(int page = 1)
{
#region create pass when no user passhash exists in db
// this is used for creating a pass when there is none in the DB to begin with
//var user = new User() { Username = "******" };
//user.SetPassword("test");
//ViewBag.hash = "Hash for test= " + user.PasswordHash;
#endregion
using (db = new MainDBContext())
{
var baseQuery = db.Posts.Where(t => t.DeletedAt == null).OrderByDescending(t => t.CreatedAt);
var totalPostCount = baseQuery.Count();
//var postIds = baseQuery.Skip((page - 1) * PostsPerPage).Take(PostsPerPage).Select(t => t.PostId).ToList();
//var posts = baseQuery.Include("User").Include("Tags").Where(t => postIds.Contains(t.PostId)).F(t => t.Tags).Select(t => t.).ToList();
var posts = baseQuery
.Include("User")
.Include("Tags")
.Skip((page - 1) * PostsPerPage)
.Take(PostsPerPage)
.ToList();
return(View(new PostsIndex
{
Posts = new PageData <Post>(posts, totalPostCount, page, PostsPerPage)
}));
}
}
public ActionResult Registration(Introconduit1.Models.UserModel user)
{
if (ModelState.IsValid == false)
{
using (var db = new MainDBContext())
{
var crypto = new SimpleCrypto.PBKDF2();
var encrpPass = crypto.Compute(user.Password);
var sysUser = db.SystemUsers.Create();
sysUser.Email = user.Email;
sysUser.Password = encrpPass;
sysUser.PasswordSalt = crypto.Salt;
sysUser.UserId = Guid.NewGuid();
db.SystemUsers.Add(sysUser);
db.SaveChanges();
return RedirectToAction("Index", "Home");
}
}
else
{
ModelState.AddModelError("", "Login data is incorrect");
}
return View(user);
}
public JObject IsStartTest([FromBody] IsStartTest isStartTest)
{
MainDBContext mainDBContext = new MainDBContext();
if (!isStartTest.IsStart)
{
var test = mainDBContext.TestResults.Find(isStartTest.TestID);
mainDBContext.Statisics.Remove(mainDBContext.Statisics.FirstOrDefault(x => x.TestResult == test));
mainDBContext.TestResults.Remove(test);
mainDBContext.SaveChanges();
}
int resID = 0;
if (isStartTest.IsStart)
{
resID = isStartTest.TestID;
}
else
{
resID = JsonConvert.DeserializeObject <StartActionNet>(StartTest(
new IntegerInput
{
Value = isStartTest.UserID
}).ToString()).PrevID;
}
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet
{
ResultCode = isStartTest.IsStart ? ResultCode.Success : ResultCode.Error,
WorkID = resID
})));
}
public JObject Answer([FromBody] UserAnswerInputNet userAnswer)
{
MainDBContext mainDBContext = new MainDBContext();
var rightQuestion = mainDBContext.RightQuestions.FirstOrDefault(x => x.QuestionID == userAnswer.QuestionID);
var isAnswered = mainDBContext.UserAnswers
.FirstOrDefault(x => x.QuestionID == userAnswer.QuestionID &&
x.TestResultID == userAnswer.TestResult);
if (isAnswered == null)
{
mainDBContext.UserAnswers.Add(new UserAnswer
{
AnswerID = userAnswer.AnswerID,
QuestionID = userAnswer.QuestionID,
TestResultID = userAnswer.TestResult
});
}
else
{
isAnswered.AnswerID = userAnswer.AnswerID;
mainDBContext.Entry(isAnswered).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
mainDBContext.SaveChanges();
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet
{
ResultCode = rightQuestion.AnswerID == userAnswer.AnswerID ? ResultCode.Right : ResultCode.Wrong,
WorkID = userAnswer.UserID
})));
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Вы действительно хотите сохранить изменения?", "Сохранить изменения", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
using (MainDBContext mainDB = new MainDBContext())
{
///
AccessMatrix accessMatrix = mainDB.BPs.FirstOrDefault(s => s.Name == access[0].БП).AccessMatrix;
string userId = (dataGrid1.SelectedItem as UserDTO).Логин;
foreach (var a in access)
{
accessMatrix.Matrix[userId][a.Этап] = a.Доступ;
}
var bp = mainDB.BPs.FirstOrDefault(s => s.Name == access[0].БП);
bp.AccessMatrix = null;
mainDB.SaveChanges();
bp = mainDB.BPs.FirstOrDefault(s => s.Name == access[0].БП);
bp.AccessMatrix = accessMatrix;
mainDB.SaveChanges();
///
}
}
}
public ActionResult Form(PostsForm form)
{
form.IsNew = form.PostId == null;
if (!ModelState.IsValid)
{
return(View(form));
}
using (db = new MainDBContext())
{
var selectedTags = ReconsileTags(form.Tags).ToList();
var post = new Post();
if (form.IsNew)
{
post.CreatedAt = DateTime.UtcNow;
post.User = db.Users
.FirstOrDefault(u => u.Username == System.Web.HttpContext.Current.User.Identity.Name);
foreach (var tag in selectedTags)
{
post.Tags.Add(tag);
}
;
db.Posts.Add(post);
}
else
{
post = db.Posts.Find(form.PostId);
if (post == null)
{
return(HttpNotFound());
}
post.UpdatedAt = DateTime.UtcNow;
foreach (var toAdd in selectedTags.Where(t => !post.Tags.Contains(t)))
{
post.Tags.Add(toAdd);
}
foreach (var toRemove in post.Tags.Where(t => !selectedTags.Contains(t)).ToList())
{
post.Tags.Remove(toRemove);
}
}
post.Title = form.Title;
post.Slug = form.Slug;
post.Content = form.Content;
db.SaveChanges();
return(RedirectToAction("index"));
}
}
// GET: Home
public ActionResult Index()
{
using (var db = new MainDBContext())
{
string username = Session["username"].ToString();
var userItems = db.dataFile.Where(x => x.pengguna == username).ToList();
return(View(userItems));
}
}
public JObject GetStatistics([FromBody] IntegerInput user)
{
MainDBContext mainDBContext = new MainDBContext();
var testResults = mainDBContext.Statisics.Where(x => x.UserID == user.Value).Select(x => x.TestResultID);
var tmpTestRes = new List <int>();
foreach (var testResult in testResults)
{
var ticket = mainDBContext.UserAnswers.Where(x => x.TestResultID == testResult)
.Select(x => x.Question.TicketNum).FirstOrDefault();
var userCounts = mainDBContext.UserAnswers.Where(x => x.TestResultID == testResult).Count();
if (mainDBContext.Questions.Where(x => x.TicketNum == ticket).Count() == userCounts)
{
tmpTestRes.Add(testResult);
}
}
testResults = tmpTestRes.AsQueryable();
var statisticsList = mainDBContext.TestResults.Where(x => testResults.Contains(x.ID))
.Select(x => new StatisticResult
{
ResultCode = ResultCode.Success,
WorkID = x.ID,
DateTime = x.DateTime.ToLongDateString()
}).ToList();
for (int i = 0; i < statisticsList.Count; i++)
{
statisticsList[i].Ticket = mainDBContext.UserAnswers.Where(x => x.TestResultID == statisticsList[i].WorkID)
.Select(x => x.Question.TicketNum).FirstOrDefault();
int ticketCount = mainDBContext.Questions.Where(x => x.TicketNum == statisticsList[i].Ticket).Count();
var userAnswers = mainDBContext.UserAnswers.Where(x => x.TestResultID == statisticsList[i].WorkID);
int usersRight = 0;
foreach (var userAnswer in userAnswers)
{
if (mainDBContext.RightQuestions.FirstOrDefault(x => x.AnswerID == userAnswer.AnswerID &&
x.QuestionID == userAnswer.QuestionID) != null)
{
usersRight++;
}
}
if (usersRight == 0)
{
statisticsList[i].Result = 0;
}
else
{
statisticsList[i].Result = usersRight * 100 / ticketCount;
}
}
return(JObject.Parse(JsonConvert.SerializeObject(new StatisticsList
{
ResultCode = statisticsList.Count() > 0 ? ResultCode.Success : ResultCode.Error,
WorkID = user.Value,
staticticResults = statisticsList.ToList()
})));
}
public UnitOfWork()
{
if (this._context == null)
{
this._context = new MainDBContext();
this._context.Configuration.LazyLoadingEnabled = true;
this._context.Configuration.ProxyCreationEnabled = true;
}
}
public FileResult Download(int id)
{
using (var db = new MainDBContext())
{
var berkas = db.dataFile.First(x => x.Id == id);
berkas.terunduh += 1;
db.SaveChanges();
return(File(berkas.file_path, System.Net.Mime.MediaTypeNames.Application.Octet, berkas.nama_file));
}
}
public AdminController(UserManager <AppUser> usrMgr, IUserValidator <AppUser> userValid, IPasswordValidator <AppUser> passValid, IPasswordHasher <AppUser> passwordНash, MainDBContext mdb, ApplicationDbContext adb)
{
userManager = usrMgr;
userValidator = userValid;
passwordValidator = passValid;
passwordHasher = passwordНash;
mainDBContext = mdb;
applicationDbContext = adb;
}
protected void Dispose(bool disposing)
{
if (disposing)
{
if (dbContext != null)
{
dbContext.Dispose();
dbContext = null;
}
}
}
private static async Task Seed(MainDBContext context, IServiceScope serviceScope)
{
if (!await context.Roles.AnyAsync())
{
var roleManager = serviceScope.ServiceProvider.GetService <RoleManager <IdentityRole <int> > >();
var role = new IdentityRole <int> {
Name = "Admins"
};
await roleManager.CreateAsync(role);
}
if (!await context.Users.AnyAsync())
{
var userManager = serviceScope.ServiceProvider.GetService <UserManager <IdentityUser <int> > >();
string user = "******";
string password = "******";
IdentityUser <int> currUser = null;
var result = await userManager.CreateAsync(currUser = new IdentityUser <int> {
UserName = user, Email = "*****@*****.**", EmailConfirmed = true
}, password);
await userManager.AddToRoleAsync(currUser, "Admins");
}
if (!await context.Destinations.AnyAsync())
{
var firstDestination = new Destination
{
Name = "Florence",
Country = "Italy",
Packages = new List <Package>()
{
new Package
{
Name = "Summer in Florence",
StartValidityDate = new DateTime(2019, 6, 1),
EndValidityDate = new DateTime(2019, 10, 1),
DuratioInDays = 7,
Price = 1000,
EntityVersion = 1
},
new Package
{
Name = "Winter in Florence",
StartValidityDate = new DateTime(2019, 12, 1),
EndValidityDate = new DateTime(2020, 2, 1),
DuratioInDays = 7,
Price = 500,
EntityVersion = 1
}
}
};
context.Destinations.Add(firstDestination);
await context.SaveChangesAsync();
}
}
public JObject GetStatistics([FromBody] IntegerInput user)
{
MainDBContext mainDBContext = new MainDBContext();
List <StatisticResult> statisticResults = new List <StatisticResult>();
var testResults = mainDBContext.Statisics.Where(x => x.UserID == user.Value).Select(x => x.TestResult).ToList();
var questionsCount = mainDBContext.Questions.Count();
var groupResults = mainDBContext.FinalQueries.GroupBy(x => x.Ticket);
var testInterpretations = mainDBContext.TestInterpretations.GroupBy(x => x.Type);
foreach (var testResult in testResults)
{
var usersAnswer = mainDBContext.TestResultUsers.Where(x => x.TestResult == testResult)
.Select(x => x.TestFinal).ToList();
if (usersAnswer.Count > 0)
{
var userGroups = usersAnswer.GroupBy(x => x.Type).ToDictionary(x => x.Key, x => x.Sum(y => y.Mark));
foreach (var testInter in testInterpretations)
{
if (!userGroups.TryGetValue(testInter.Key, out var val))
{
userGroups.Add(testInter.Key, 0);
}
}
var testPresent = mainDBContext.TestInterpretations.Where(x => userGroups.Keys.Contains(x.Type) &&
userGroups[x.Type] > x.MarkMin && userGroups[x.Type] <= x.MarkMax).ToList();
string res = string.Empty;
foreach (var group in groupResults)
{
if (group.Select(x => x.TestPresentation).ToList().Compare(testPresent.Select(x => x.ID).ToList()))
{
res += group.FirstOrDefault().Result;
}
}
if (!string.IsNullOrEmpty(res))
{
statisticResults.Add(new StatisticResult
{
DateTime = testResult.DateTime.ToShortDateString(),
Result = res,
ResultCode = ResultCode.Success,
WorkID = testResult.ID
});
}
}
}
return(JObject.Parse(JsonConvert.SerializeObject(new StatisticsList
{
ResultCode = statisticResults.Count() > 0 ? ResultCode.Success : ResultCode.Error,
WorkID = user.Value,
staticticResults = statisticResults
})));
}
public JObject GetTickets()
{
MainDBContext mainDBContext = new MainDBContext();
var questionNums = mainDBContext.Questions.GroupBy(x => x.TicketNum).Select(x => x.Key);
return(JObject.Parse(JsonConvert.SerializeObject(new TicketsNet
{
ResultCode = ResultCode.Success,
Tickets = questionNums.ToList(),
WorkID = 0
})));
}
// GET: Admin/Users
public ActionResult Index()
{
using (var db = new MainDBContext())
{
var ui = new UsersIndex
{
Users = db.Users.Include("Roles")
.ToList()
};
return(View(ui));
}
}
public JObject ProfileUserInfo([FromBody] IntegerInput id)
{
MainDBContext mainDBContext = new MainDBContext();
var user = mainDBContext.Users.Find(id.Value);
return(JObject.Parse(JsonConvert.SerializeObject(new UserProfileNet
{
Nickname = user.Nickname,
ResultCode = ResultCode.Success,
WorkID = user.ID
})));
}
public static void EnsureSeedData(this MainDBContext db)
{
if (!db.Products.Any())
{
var product = new Product
{
Name = "R2-D2"
};
db.Products.Add(product);
db.SaveChanges();
}
}
public JObject GetQuestions([FromBody] PrestartInfo id)
{
MainDBContext mainDBContext = new MainDBContext();
var questions = mainDBContext.UserAnswers.Where(x => x.TestResultID == id.UserID).ToList();
var quesionsList = mainDBContext.Questions.Where(x => x.TicketNum == id.Ticket).ToList();
return(JObject.Parse(JsonConvert.SerializeObject(new QuestionListActionNet
{
ResultCode = quesionsList.Count > 0 ? ResultCode.Error : ResultCode.Success,
WorkID = id.UserID,
QuestionActionNets = quesionsList.Select(x => GetQuestionActionNet(x, mainDBContext, questions)).ToList()
})));
}
public JObject SaveUser([FromBody] UserSave userSave)
{
MainDBContext mainDBContext = new MainDBContext();
var user = mainDBContext.Users.Find(userSave.Id);
user.Nickname = userSave.nickname;
mainDBContext.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
mainDBContext.SaveChanges();
return(JObject.Parse(JsonConvert.SerializeObject(new UniversalActionNet
{
ResultCode = ResultCode.Success
})));
}
private bool IsValid(string Email, string Password)
{
var crypto = new SimpleCrypto.PBKDF2();
bool IsValid = false;
using (var db = new MainDBContext())
{
var user = db.SystemUsers.FirstOrDefault(u => u.Email == Email);
if (user != null)
{
if (user.Password == crypto.Compute(Password, user.PasswordSalt))
{
IsValid = true;
}
}
return IsValid;
}
}
