public ActionResult Map() { if (!Logged()) { return(RedirectToAction("Index", "Login")); } szmalDBEvents db = new szmalDBEvents(); UserLoginModel userLoginModel = new UserLoginModel(); var bigmodel = new BigModel() { EventToShowModel = db.zgloszenies.Select(s => s), UserLoginModel = null }; return(View("~/Views/Home/Map.cshtml", bigmodel)); }
public async Task Test_Execute_WithColumnBindingToProperty() { BigModel model1 = new BigModel() { Value = 1, Value2 = "banana" }; BigModel model2 = new BigModel() { Value = 1, Value2 = "banana" }; ITuple tuple1 = DatabaseHelper.Default.Relation(model1, "Value", "Value2").Row(); ITuple tuple2 = DatabaseHelper.Default.Relation(model2, "Value", "Value2").Row(); CommandData command1 = new CommandData() { CommandText = @"SELECT 2 AS B1, 'apple' AS B2;", Bindings = new ICommandBinding[] { new ColumnBinding("B1", tuple1[0]), new ColumnBinding("B2", tuple1[1]), } }; CommandData command2 = new CommandData() { CommandText = @"SELECT 2 AS B1, 'apple' AS B2;", Bindings = new ICommandBinding[] { new ColumnBinding("B1", tuple2[0]), new ColumnBinding("B2", tuple2[1]), } }; DatabaseHelper.Default.Execute(command1); await DatabaseHelper.Default.ExecuteAsync(command2); tuple1[0].Value.ShouldBe(2); tuple2[0].Value.ShouldBe(2); model1.Value.ShouldBe(2); model2.Value.ShouldBe(2); tuple1[1].Value.ShouldBe("apple"); tuple2[1].Value.ShouldBe("apple"); model1.Value2.ShouldBe("apple"); model2.Value2.ShouldBe("apple"); }
public async Task Test_Execute_WithColumnBindingToMissingValue_Throws() { BigModel model = new BigModel(); IField field = DatabaseHelper.Default.Relation(model, "OneToOne.Value").Scalar(); CommandData command = new CommandData() { CommandText = @"SELECT 12 AS B1", Bindings = new ICommandBinding[] { new ColumnBinding("B1", field), } }; Should.Throw <Relations.BindingException>(() => DatabaseHelper.Default.Execute(command)); await Should.ThrowAsync <Relations.BindingException>(async() => await DatabaseHelper.Default.ExecuteAsync(command)); }
// GET: Logins public ActionResult Index() { szmalDBEvents db = new szmalDBEvents(); UserLoginModel userLoginModel = new UserLoginModel(); if (Session["UserID"] != null) { return(RedirectToAction("Yours", "User")); } var bigmodel = new BigModel() { EventToShowModel = db.zgloszenies.Select(s => s), UserLoginModel = null }; return(View("Index", bigmodel)); }
public ActionResult ProfileEditor() { var userProf = new Profile(); userProf = ReturnProfile(Session["Username"].ToString()); ViewBag.Current = userProf; //------TAGS-----\\ List <ProfileTags> list = new List <ProfileTags>(); using (var cn = new SqlConnection(Constants.ConnString)) { string _sql = @"SELECT * FROM Tags"; var cmd = new SqlCommand(_sql, cn); cn.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { ProfileTags t = new ProfileTags { TagID = (int)reader["Id"], TagName = (string)reader["TagName"] }; list.Add(t); } cn.Close(); } var DBModel = new ProfileTagsList() { DBTags = list }; var BigModel = new BigModel { ProfileTagsList = DBModel }; //-----END TAGS-----\\ return(View(BigModel)); }
// GET: Posts/5 public async Task <IActionResult> Post(int?id) { BigModel bm = new BigModel(); if (id == null) { return(NotFound()); } var post = await _context.Posts .SingleOrDefaultAsync(m => m.PostID == id); if (post == null) { return(NotFound()); } post.Comments = await _context.Comments.ToListAsync(); post.Comments = post.Comments.Where(c => c.PostID == post.PostID).ToList(); bm.post = post; bm.comment = new Comment(); return(View(bm)); }
public ActionResult LoginUser(BigModel objUser) { using (szmaldbEntities db = new szmaldbEntities()) { var obj = db.uzytkowniks.Where(a => a.login.Equals(objUser.UserLoginModel.Login) && a.haslo.Equals(objUser.UserLoginModel.Password)).FirstOrDefault(); if (obj == null) { ModelState.AddModelError("Login", "Niepoprawna nazwa użytkownika lub hasło"); ModelState.AddModelError("Password", ""); ViewResult result = View("~/Views/Index.cshtml", objUser); return(result); } else if (ModelState.IsValid) { Session["UserID"] = obj; return(RedirectToAction("Yours", "User")); } return(View(this)); } }
public ActionResult RegisterUser(BigModel objUser) { if (ModelState.IsValid) { using (szmaldbEntities db = new szmaldbEntities()) { var obj = db.uzytkowniks.Where(a => a.imie.Equals(objUser.UserLoginModel.Login) && a.haslo.Equals(objUser.UserLoginModel.Password)).FirstOrDefault(); if (obj == null) { uzytkownik u = new uzytkownik(); u.login = objUser.UserLoginModel.Login; u.haslo = objUser.UserLoginModel.Password; u.email = objUser.UserLoginModel.Email; db.uzytkowniks.Add(u); db.SaveChanges(); } } } else { return(PartialView("Index", objUser)); } return(View("~/Views/Index.cshtml")); }
public ActionResult Create(BigModel bigModels) { // Loop and insert records. foreach (var allSurvey in bigModels.AllSurvey) { allSurvey.Status = SurveyStatus.NOT_HAPPENNING_YET; allSurvey.CreateDate = DateTime.Now; allSurvey.UpdateDate = DateTime.Now.AddDays(7); db.Surveys.Add(allSurvey); db.SaveChanges(); int newIdSurvey = db.Surveys.Max(s => s.SurveyId); int newIdQuest = 0; string titleTemp; int sttQuest = 0; for (int i = 0; i < bigModels.Question.Count; i++) { bigModels.Question[i].SurveyId = newIdSurvey; db.Questions.Add(bigModels.Question[i]); db.SaveChanges(); if (i == 0) { newIdQuest = db.Questions.Max(q => q.Id); } if (bigModels.Question[i].Type == 3) { QaTemp q = new QaTemp(); q.Answer = "Other"; q.Title = bigModels.Question[i].Title; bigModels.QaTemps.Add(q); } if (bigModels.Question[i].Type == 4) { QaTemp q = new QaTemp(); q.Answer = "Essay"; q.Title = bigModels.Question[i].Title; bigModels.QaTemps.Add(q); } if (i == bigModels.Question.Count - 1) { titleTemp = bigModels.Question[sttQuest].Title; foreach (var qaTemp in bigModels.QaTemps) { QuestionAnswer questionAnswer = new QuestionAnswer(); if (!qaTemp.Title.Equals(titleTemp)) { titleTemp = qaTemp.Title; newIdQuest++; sttQuest++; } questionAnswer.Answer = qaTemp.Answer; questionAnswer.QuestionId = newIdQuest; questionAnswer.Answer = qaTemp.Answer; db.Question_answers.Add(questionAnswer); //bigModels.QaTemps.Remove(qaTemp); } } } } db.SaveChanges(); return(RedirectToAction("Index")); }