public OrganizerModel GetById(int Id) { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); var command = con.CreateCommand(); command.CommandText = "SongNames_GetById"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@Id", Id); using (SqlDataReader reader = command.ExecuteReader()) { var result = new OrganizerModel(); while (reader.Read()) { result.Id = (int)reader["id"]; result.SongName = (string)reader["SongName"]; result.DateCreated = (DateTime)reader["DateCreated"]; result.DateModified = (DateTime)reader["DateModified"]; result.Lyrics = reader["Lyrics"] as string; } return(result); } } }
public void CloseOrg() { IsVisibileSavedWGrid = false; IsVisibileSavedRGrid = false; SavedRText = ""; SavedWText = ""; OrgGridIsVisible = false; SaveOrgGridIsVisible = false; DeleteOrgGridIsVisible = false; HacksIsVisibile = false; org = new OrganizerModel(); Organizers = OrganizerModel.GetOrgsList(); }
public void SaveSugOrgBtn() { string k = OrganizerModel.SetNextOrgs(SuggestedOrgs.ToList()); if (k.Equals("true")) { Organizers = OrganizerModel.GetOrgsList(); ShowNMessage("Organizers have been updated Successfuly", 'r'); } else { ShowNMessage($"Error: {k}", 'w'); } }
public List <OrganizerModel> GetAll() { //1 create and open a sql connection //2 create a sql command //3 execute the command which will give us a sqldatareader //4 we'll use the sql datareader to loop over all of the rows coming back from the query //1 using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); //2 var command = con.CreateCommand(); // 'var' is exactly the same as: SqlCommand command = con.CreateCommand(); command.CommandText = "SongNames_GetAll"; command.CommandType = System.Data.CommandType.StoredProcedure; //3 using (SqlDataReader reader = command.ExecuteReader()) { var results = new List <OrganizerModel>(); while (reader.Read()) { //this loop will happen once for every row coming out of the database var song = new OrganizerModel(); song.Id = (int)reader["id"]; song.SongName = (string)reader["SongName"]; song.DateCreated = (DateTime)reader["DateCreated"]; song.DateModified = (DateTime)reader["DateModified"]; song.Lyrics = reader["Lyrics"] as string; #region OTHER WAY TO DO IT //this is the exact same as above but uses C# 'object initializer" syntax //var car2 = new Car //{ //Id = (int)reader["id"] etc.... //} #endregion results.Add(song); } return(results); } } // no more con (thanks to the'using' }
public void DeleteBtn() { string message = OrganizerModel.DeleteOrg(org.Id); if (message.Equals("true")) { ShowMessage("Organizer has been Deleted Successfuly", 'r'); } else { ShowMessage($"Error: {message}", 'w'); } OrgGridIsVisible = true; }
public async Task <IActionResult> Create([Bind("UserModelId,Name,Surname,Address,DateOfBirth,Username,password")] RegisteredUserModel registeredUserModel, string password2) { ViewData["role"] = HttpContext.Session.GetString("role"); ViewData["id"] = HttpContext.Session.GetInt32("id"); if (ModelState.IsValid) { using (var db = new DatabaseContext()) { if (registeredUserModel.DateOfBirth.CompareTo(DateTime.Now) >= 0 || registeredUserModel.DateOfBirth.Year < 1900) { return(View()); } if (password2 != registeredUserModel.password) { return(View()); } RegisteredUserModel registered = db.Registrovani.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); UnregistredUserModel unregistred = db.Neregistrovani.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); OrganizerModel organizer = db.Oranizatori.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); LocalAdministratorModel local = db.Lokalni.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); MainAdministratorModel main = db.Glavni.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); if (!(registered == null && unregistred == null && organizer == null && local == null && main == null)) { return(View()); } _context.Add(registeredUserModel); await _context.SaveChangesAsync(); HttpContext.Session.SetString("role", "Registred"); HttpContext.Session.SetInt32("id", registeredUserModel.UserModelId); return(RedirectToAction("Index", "Home")); } } return(View(registeredUserModel)); }
public void ShowOrg(string name = "Nil Nil") { CloseOrg(); if (name.Equals("Nil Nil")) { New = false; OrgGridIsVisible = false; } else { New = false; org = OrganizerModel.GetOrg(name); OrgNameText = org.Name; OrgHacksText = org.Hack.ToString(); OrgGridIsVisible = true; HacksIsVisibile = true; SaveOrgGridIsVisible = true; DeleteOrgGridIsVisible = true; } }
public void SaveBtn() { if (New) { string message = OrganizerModel.AddOrg(OrgNameText); if (message.Equals("true")) { ShowMessage("Organizer has been Added Successfuly", 'r'); } else { ShowMessage($"Error: {message}", 'w'); } } else { try { string message = OrganizerModel.UpdateOrg(org.Id, OrgNameText, int.Parse(OrgHacksText)); if (message.Equals("true")) { ShowMessage("Organizer has been Updated Successfuly", 'r'); } else { if (message.Contains("Duplicate entry")) { message = $"{OrgNameText} is already there."; } ShowMessage($"Error: {message}", 'w'); } } catch (Exception e) { ShowMessage($"Error: Please Check the Fields", 'w'); } } OrgGridIsVisible = true; }
public OrganizersViewModel() { Organizers = OrganizerModel.GetOrgsList(); SuggestedOrgs = new BindableCollection <OrganizerModel>(Utils.NextOrgs(k)); k = 0; }
public async Task <IActionResult> Create([Bind("SpaceModelId,Name,Address,LocalAdministratorModelId")] SpaceModel spaceModel, string AdminName, string Surename, string Date, string AdminAddress, string Username, string Password, string Password2) { ViewData["role"] = HttpContext.Session.GetString("role"); ViewData["id"] = HttpContext.Session.GetInt32("id"); if (ModelState.IsValid) { if (DateTime.Parse(Date).CompareTo(DateTime.Now) >= 0 || DateTime.Parse(Date).Year < 1900) { return(View()); } if (Password != Password2) { return(View()); } RegisteredUserModel registered = _context.Registrovani.Where(e => e.Username == Username).FirstOrDefault(); UnregistredUserModel unregistred = _context.Neregistrovani.Where(e => e.Username == Username).FirstOrDefault(); OrganizerModel organizer = _context.Oranizatori.Where(e => e.Username == Username).FirstOrDefault(); LocalAdministratorModel local = _context.Lokalni.Where(e => e.Username == Username).FirstOrDefault(); MainAdministratorModel main = _context.Glavni.Where(e => e.Username == Username).FirstOrDefault(); if (!(registered == null && unregistred == null && organizer == null && local == null && main == null)) { return(View()); } if (SectionModels.Count == 0) { return(View()); } LocalAdministratorModel localAdministratorModel = new LocalAdministratorModel(); localAdministratorModel.Name = AdminName; localAdministratorModel.Surname = Surename; localAdministratorModel.Username = Username; localAdministratorModel.Password = Password; localAdministratorModel.Address = AdminAddress; localAdministratorModel.DateOfBirth = DateTime.Parse(Date); _context.Add(localAdministratorModel); await _context.SaveChangesAsync(); spaceModel.LocalAdministratorModelId = localAdministratorModel.AdministratorModelId; spaceModel.LocalAdministratorModel = localAdministratorModel; _context.Add(spaceModel); await _context.SaveChangesAsync(); foreach (SectionModel sectionModel in SectionModels) { sectionModel.SpaceModelId = spaceModel.SpaceModelId; _context.Add(sectionModel); await _context.SaveChangesAsync(); } SectionModels.Clear(); return(RedirectToAction("Index", "Home")); } ViewData["LocalAdministratorModelId"] = new SelectList(_context.Lokalni, "AdministratorModelId", "Discriminator", spaceModel.LocalAdministratorModelId); return(View(spaceModel)); }
public async Task <IActionResult> Edit(int id, [Bind("UserModelId,Name,Surname,Address,DateOfBirth,Username,password")] RegisteredUserModel registeredUserModel, string password2) { ViewData["role"] = HttpContext.Session.GetString("role"); ViewData["id"] = HttpContext.Session.GetInt32("id"); registeredUserModel.UserModelId = id; if (ModelState.IsValid) { using (var db = new DatabaseContext()) { if (registeredUserModel.DateOfBirth.CompareTo(DateTime.Now) >= 0 || registeredUserModel.DateOfBirth.Year < 1900) { return(View()); } if (!(password2 == null || password2.Length == 0) && (registeredUserModel.password == null || registeredUserModel.password.Length == 0)) { return(View()); } if ((password2 == null || password2.Length == 0) && !(registeredUserModel.password == null || registeredUserModel.password.Length == 0)) { return(View()); } if (!(password2 == null || password2.Length == 0) && !(registeredUserModel.password == null || registeredUserModel.password.Length == 0) && password2 != registeredUserModel.password) { return(View()); } RegisteredUserModel currentRegistered = db.Registrovani.Where(e => e.UserModelId == HttpContext.Session.GetInt32("id")).FirstOrDefault(); RegisteredUserModel registered = db.Registrovani.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); UnregistredUserModel unregistred = db.Neregistrovani.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); OrganizerModel organizer = db.Oranizatori.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); LocalAdministratorModel local = db.Lokalni.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); MainAdministratorModel main = db.Glavni.Where(e => e.Username == registeredUserModel.Username).FirstOrDefault(); if (!(registered == null && unregistred == null && organizer == null && local == null && main == null) && currentRegistered.Username != registeredUserModel.Username) { return(View()); } if (registeredUserModel.password == null || registeredUserModel.password.Length == 0) { registeredUserModel.password = currentRegistered.password; } } try { _context.Update(registeredUserModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RegisteredUserModelExists(registeredUserModel.UserModelId)) { return(NotFound()); } throw; } return(RedirectToAction("Index", "Home")); } return(View(registeredUserModel)); }