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));
}
