public Nalozi CheckLogin(string username, string password)
{
using (dataContext connection = new dataContext())
{
return(connection.Nalozi.Where(x => x.Email.Trim() == username.Trim() && x.Lozinka == password).FirstOrDefault());
}
}
public List <Gradovi> GetGradovi()
{
using (dataContext connection = new dataContext())
{
return(connection.Gradovi.ToList());
}
}
public List <TerminViewModel> GetSveTermine()
{
using (dataContext connection = new dataContext())
{
List <TerminViewModel> plivaciTermini = connection.PlivaciTermin.Select(x => new TerminViewModel
{
Id = x.Id,
Bazen = x.Termin.Bazen,
Grupa = x.Termin.Grupa,
Datum = x.Termin.Datum,
Trener = x.Termin.Trener,
VrijemeDo = x.Termin.VrijemeDo,
VrijemeOd = x.Termin.VrijemeDo
}).ToList();
List <TerminViewModel> rekreativciTermini = connection.RekreativciTermin.Select(x => new TerminViewModel
{
Id = x.Id,
Bazen = x.Termin.Bazen,
Grupa = x.Termin.Grupa,
Datum = x.Termin.Datum,
Trener = x.Termin.Trener,
VrijemeDo = x.Termin.VrijemeDo,
VrijemeOd = x.Termin.VrijemeDo
}).ToList();
List <TerminViewModel> sviRezultati = new List <TerminViewModel>();
sviRezultati.AddRange(plivaciTermini);
sviRezultati.AddRange(rekreativciTermini);
return(sviRezultati);
}
}
public List <TerminViewModel> GetTermine(int klijentId, bool isPlivac)
{
using (dataContext connection = new dataContext())
{
if (isPlivac)
{
return(connection.PlivaciTermin.Where(x => x.PlivaciId == klijentId).Select(x => new TerminViewModel
{
Id = x.Termin.Id,
Bazen = x.Termin.Bazen,
Trener = x.Termin.Trener,
VrijemeDo = x.Termin.VrijemeDo,
VrijemeOd = x.Termin.VrijemeOd,
Datum = x.Termin.Datum
}).ToList());
}
else
{
return(connection.RekreativciTermin.Where(x => x.RekreativacId == klijentId).Select(x => new TerminViewModel
{
Id = x.Termin.Id,
Bazen = x.Termin.Bazen,
Trener = x.Termin.Trener,
VrijemeDo = x.Termin.VrijemeDo,
VrijemeOd = x.Termin.VrijemeOd,
Datum = x.Termin.Datum
}).ToList());
}
}
}
public Nalozi RegisterNewRekreativac(RegisterViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Nalozi nalog = new Nalozi();
nalog.Email = model.Email;
nalog.Ime = model.Firstname;
nalog.Prezime = model.Lastname;
nalog.Lozinka = model.Password;
nalog.IsRekreativac = true;
nalog.IsAdministrator = false;
nalog.IsPlivac = false;
nalog.IsTrener = false;
nalog.Aktivan = true;
connection.Nalozi.Add(nalog);
connection.SaveChanges();
Rekreativci rekreativac = new Rekreativci();
rekreativac.Email = model.Email;
rekreativac.Ime = model.Firstname;
rekreativac.Prezime = model.Lastname;
rekreativac.NalogId = nalog.Id;
connection.Rekreativci.Add(rekreativac);
connection.SaveChanges();
return(nalog);
}
}
catch (Exception)
{
return(null);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, dataContext db)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseAuthentication();
app.UseRouting();
app.UseAuthorization();
//app.UseAuthorization();
//db.Database.EnsureCreated();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
}
static void Main(string[] args)
{
var db = new dataContext();
var payments = db.Payments
.Where(y => y.Department.Name == "C-Commercial and Operations");
Console.WriteLine(payments.Count());
}
public ActionResult About()
{
ViewBag.Message = "Your application description page.";
var context = new dataContext();
IEnumerable <category> list = context.Set <category>();
return(View(list.ToList()));
}
static void Main(string[] args)
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: false, reloadOnChange: true);
Configuration = builder.Build();
context = new dataContext();
MainAsync().GetAwaiter().GetResult();
}
public void CanUseContext()
{
using (var ctx = new dataContext())
{
ctx.Todos.Add(new Todos {
Id = 1
});
ctx.SaveChanges();
Assert.AreEqual(1, ctx.Todos.ToList().Count());
}
}
#pragma warning disable 4014
public static void OnStart(DiscordClient discord, IConfiguration configuration)
{
discord.MessageReactionAdded += async(client, args) =>
{
Task.Run(async() =>
{
try
{
var message = await args.Channel.GetMessageAsync(args.Message.Id);
if (args.Emoji != DiscordEmoji.FromUnicode("📌") || message.Pinned)
{
return;
}
var context = new dataContext();
var validPinners = context.Pinners.Where(r => r.Guild == args.Guild.Id.ToString()).Select(r => r.Roleid);
if ((args.User as DiscordMember).Roles.Any(r => validPinners.Contains(r.Id.ToString())))
{
// TODO: Delete pinned by ModBot message
await message.PinAsync();
var lastMessage = (await message.Channel.GetMessagesAsync()).FirstOrDefault(m => m.MessageType == MessageType.ChannelPinnedMessage);
if (lastMessage != null)
{
await lastMessage.DeleteAsync();
}
await args.Channel.SendMessageAsync(embed: new DiscordEmbedBuilder()
.WithDescription($"{args.User.Mention} pinned [a message]({args.Message.JumpLink}) to this channel"));
}
}
catch
{
await args.Channel.SendMessageAsync(embed: Embeds.Error.WithDescription("Failed to pin. There might be too many messages pinned already"));
}
});
};
discord.MessageReactionRemoved += async(client, args) =>
{
Task.Run(async() =>
{
var message = await args.Channel.GetMessageAsync(args.Message.Id);
if (args.Emoji != DiscordEmoji.FromUnicode("📌") || !message.Pinned)
{
return;
}
var context = new dataContext();
var validPinners = context.Pinners.Where(r => r.Guild == args.Guild.Id.ToString()).Select(r => r.Roleid);
if ((args.User as DiscordMember).Roles.Any(r => validPinners.Contains(r.Id.ToString())))
{
await message.UnpinAsync();
await args.Channel.SendMessageAsync(embed: new DiscordEmbedBuilder()
.WithDescription($"{args.User.Mention} unpinned [a message]({args.Message.JumpLink}) from this channel"));
}
});
};
}
public bool DodajNovogKlijenta(KlijentViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Nalozi nalog = new Nalozi();
nalog.Email = model.Email;
nalog.Ime = model.Ime;
nalog.Prezime = model.Prezime;
nalog.Lozinka = model.DatumRodjenja.Value.ToString("ddMMyyyy");
nalog.IsRekreativac = model.IsRekreativac ? true : false;
nalog.IsAdministrator = false;
nalog.IsPlivac = model.IsPlivac ? true : false;
nalog.IsTrener = false;
nalog.Aktivan = true;
connection.Nalozi.Add(nalog);
connection.SaveChanges();
if (model.IsPlivac)
{
Plivaci plivac = new Plivaci();
plivac.Email = model.Email;
plivac.Ime = model.Ime;
plivac.Prezime = model.Prezime;
plivac.DatumRodjenja = model.DatumRodjenja;
plivac.Spol = model.Spol;
plivac.Telefon = model.Telefon;
plivac.NalogId = nalog.Id;
connection.Plivaci.Add(plivac);
connection.SaveChanges();
}
else
{
Rekreativci rekreativac = new Rekreativci();
rekreativac.Email = model.Email;
rekreativac.Ime = model.Ime;
rekreativac.Prezime = model.Prezime;
rekreativac.DatumRodjenja = model.DatumRodjenja;
rekreativac.Spol = model.Spol;
rekreativac.Telefon = model.Telefon;
rekreativac.NalogId = nalog.Id;
connection.Rekreativci.Add(rekreativac);
connection.SaveChanges();
}
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public List <GrupaViewModel> GetGrupe()
{
using (dataContext connection = new dataContext())
{
return(connection.Grupe.Select(x => new GrupaViewModel
{
Id = x.Id,
Vrsta = x.Vrsta,
Uzrast = x.Uzrast,
BrojKlijenata = x.Plivaci.Count()
}).ToList());
}
}
public List <TakmicenjeViewModel> GetTakmicenjaFromPlivac(int klijentId)
{
using (dataContext connection = new dataContext())
{
return(connection.TakmicenjaPlivaci.Where(x => x.PlivacId == klijentId).Select(x => new TakmicenjeViewModel
{
Id = x.TakmicenjeId,
Naziv = x.Takmicenje.Naziv,
Grad = x.Takmicenje.Grad.Naziv,
Datum = x.Takmicenje.Datum,
OsvojenaMjesta = x.Takmicenje.OsvojenaMjesta
}).ToList());
}
}
public List <TakmicenjeViewModel> GetTakmicenja()
{
using (dataContext connection = new dataContext())
{
return(connection.Takmicenja.Select(x => new TakmicenjeViewModel
{
Id = x.Id,
Naziv = x.Naziv,
Grad = x.Grad.Naziv,
GradId = x.GradId,
Datum = x.Datum,
OsvojenaMjesta = x.OsvojenaMjesta
}).ToList());
}
}
public List <BazenViewModel> GetBazeni()
{
using (dataContext connection = new dataContext())
{
return(connection.Bazeni.Select(x => new BazenViewModel {
Id = x.Id,
Opis = x.Opis,
Naziv = x.Naziv,
Dimenzije = x.Dimenzije,
Grad = x.Grad.Naziv,
GradId = x.GradId,
SlikaUrl = x.Slika
}).ToList());
}
}
public ActionResult Contact()
{
ViewBag.Message = "Your contact page.";
string password = "******";
MD5 md5 = new MD5CryptoServiceProvider();
UTF8Encoding encoder = new UTF8Encoding();
Byte[] originalBytes = encoder.GetBytes(password);
Byte[] encodedBytes = md5.ComputeHash(originalBytes);
password = BitConverter.ToString(encodedBytes).Replace("-", "");
var result = password.ToLower();
Guid g = Guid.NewGuid();
//int g = 123456;
dataContext context = new dataContext();
context.Users.Add(new user()
{
email = "*****@*****.**", userName = "******", password = result, confirmCode = g.ToString()
});
context.SaveChanges();
try
{
SmtpClient client = new SmtpClient("smtp.yandex.com", 587);
client.EnableSsl = true;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.Credentials = new NetworkCredential("*****@*****.**", "sifre84info");
MailAddress from = new MailAddress("*****@*****.**", "Hüseyin");
MailAddress to = new MailAddress("*****@*****.**");
MailMessage message = new MailMessage(from, to);
message.Body = "body" + g;
message.IsBodyHtml = true;
message.Subject = "subject";
message.SubjectEncoding = System.Text.Encoding.UTF8;
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls;
client.Send(message);
}
catch (Exception ex)
{
throw ex;
}
return(View());
}
public List <TrenerViewModel> GetTreneri()
{
using (dataContext connection = new dataContext())
{
return(connection.Treneri.Select(x => new TrenerViewModel
{
Id = x.Id,
Ime = x.Ime,
Prezime = x.Prezime,
Email = x.Email,
DatumRodjenja = x.DatumRodjenja,
Spol = x.Spol,
Telefon = x.Kontakt,
Zvanje = x.Zvanje
}).ToList());
}
}
private void buttonAddUser_Click(object sender, EventArgs e)
{
try {
dataContext data = new dataContext();
User newUser = new User()
{
_name = boxName.Text,
_userName = boxUserName.Text,
_password = boxPassword.Text
};
data.Users.Add(newUser);
data.SaveChanges();
new Message("Saved", 1);
}
catch {
new Message("Wrong Hapen :(", 2);
}
}
public bool DodajGrupu(GrupaViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Grupe grupa = new Grupe();
grupa.Uzrast = model.Uzrast;
grupa.Vrsta = model.Vrsta;
connection.Grupe.Add(grupa);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool DodajPlivacaNaTakmicenje(int takmicenjeId, int plivacId)
{
try
{
using (dataContext connection = new dataContext())
{
TakmicenjaPlivaci takmicenjePlivac = new TakmicenjaPlivaci();
takmicenjePlivac.PlivacId = plivacId;
takmicenjePlivac.TakmicenjeId = takmicenjeId;
connection.TakmicenjaPlivaci.Add(takmicenjePlivac);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
#pragma warning disable 4014
new public static void OnStart(DiscordClient discord, IConfiguration configuration)
{
var context = new dataContext();
discord.MessageCreated += async(client, args) =>
{
Task.Run(async() =>
{
if (!args.Message.Content.StartsWith("\\") && // Not escaped
context.Anonchannels.Any(c => c.Id == args.Channel.Id.ToString()) && // In an anon channel
!args.Author.IsBot && // Not a bot
!context.AnonBans.AsNoTracking().AsEnumerable().Any(u => u.User == args.Author.Id.ToString() && // AsNoTracking used to avoid cache
u.Server == args.Guild.Id.ToString() &&
(u.ExpiresAt == (ulong)0 || u.ExpiresAt > (ulong)DateTimeOffset.Now.ToUnixTimeSeconds()))) // Not anonbanned
{
if (args.Message.Attachments.Count == 0)
{
try { await args.Message.DeleteAsync(); } catch { }
}
// TODO: Work around rate limit here
var webhook = await args.Channel.CreateWebhookAsync("Anon");
var msg = new DiscordWebhookBuilder().WithContent(args.Message.Content.CleanPings(args.Guild));
foreach (var attachment in args.Message.Attachments)
{
var fileStream = WebRequest.Create(attachment.ProxyUrl).GetResponse().GetResponseStream();
msg.AddFile(attachment.FileName, fileStream);
}
var anonMessage = await webhook.ExecuteAsync(msg);
await webhook.DeleteAsync();
try { await args.Message.DeleteAsync(); } catch { }
await context.Anonmessages.AddAsync(new Anonmessage
{
Id = anonMessage.Id.ToString(),
Server = anonMessage.Channel.GuildId.ToString(),
User = args.Author.Id.ToString()
});
await context.SaveChangesAsync();
}
}
);
};
}
public bool DodajBazen(BazenViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Bazeni bazen = new Bazeni();
bazen.Dimenzije = model.Dimenzije;
bazen.Naziv = model.Naziv;
bazen.Opis = model.Opis;
bazen.GradId = model.GradId;
if (model.Slika != null)
{
string pic = System.IO.Path.GetFileName(model.Slika.FileName);
string path = System.IO.Path.Combine(
System.Web.HttpContext.Current.Server.MapPath("~/assets/image/bazeni"), pic);
// file is uploaded
model.Slika.SaveAs(path);
// save the image path path to the database or you can send image
// directly to database
// in-case if you want to store byte[] ie. for DB
using (MemoryStream ms = new MemoryStream())
{
model.Slika.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
}
bazen.Slika = pic;
}
connection.Bazeni.Add(bazen);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool DodajNovoTakmicenje(TakmicenjeViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Takmicenja takmicenje = new Takmicenja();
takmicenje.Datum = model.Datum;
takmicenje.GradId = model.GradId;
takmicenje.Naziv = model.Naziv;
takmicenje.OsvojenaMjesta = model.OsvojenaMjesta;
connection.Takmicenja.Add(takmicenje);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public List <KlijentViewModel> GetRekreativce()
{
using (dataContext connection = new dataContext())
{
List <KlijentViewModel> rekreativci = connection.Rekreativci.Select(x => new KlijentViewModel
{
Id = x.Id,
Ime = x.Ime,
Prezime = x.Prezime,
ImePrezime = x.Ime + " " + x.Prezime,
Email = x.Email,
DatumRodjenja = x.DatumRodjenja,
Spol = x.Spol,
Telefon = x.Telefon,
IsRekreativac = true,
IsPlivac = false
}).ToList();
return(rekreativci);
}
}
public async static Task OnReactionChange(DiscordClient BaseDiscordClient, DiscordMessage reactionMsg, IConfiguration Configuration)
{
var context = new dataContext();
try
{
var mediaGen = new MediaGen(Configuration["MediaGen"]);
if (context.Polls.SingleOrDefault(p => p.Message == reactionMsg.Id.ToString()) != null)
{
var msg = await reactionMsg.Channel.GetMessageAsync(reactionMsg.Id);
var up = msg.Reactions.FirstOrDefault(r => r.Emoji == DiscordEmoji.FromUnicode("👍"));
var down = msg.Reactions.FirstOrDefault(r => r.Emoji == DiscordEmoji.FromUnicode("👎"));
await msg.ModifyAsync(embed : new DiscordEmbedBuilder(msg.Embeds[0])
.WithImageUrl(mediaGen.GeneratePollURL(up == null ? 0 : up.Count - 1, down == null ? 0 : down.Count - 1)).Build());
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public PartialViewResult Menu()
{
var context = new dataContext();
//List<RoleValue> roleValues = (List<RoleValue>)Session["MagentyRoleValues"];
//List<RoleValue> menuList = new List<RoleValue>();
//menuList = roleValues.Where(x => x.MenuOrAction == "M" && x.IsPermission == true).ToList();
//return PartialView("_Menu", menuList);
List <category> categoryList = new List <category>();
categoryList = context.Set <category>().ToList();
//List<List<category>> orderedList = new List<List<category>>();
//foreach (var item in categoryList)
//{
// List<category> itemCat = new List<category>();
// if (item.topCategoryId == 0)
// {
// itemCat.Add(item);
// foreach (var itemList in categoryList)
// {
// if (item.id == itemList.topCategoryId)
// {
// itemCat.Add(itemList);
// }
// }
// }
// orderedList.Add(itemCat);
//}
return(PartialView("_Menu", categoryList));
}
public bool DodajNovogTrenera(TrenerViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Nalozi nalog = new Nalozi();
nalog.Email = model.Email;
nalog.Ime = model.Ime;
nalog.Prezime = model.Prezime;
nalog.Lozinka = model.DatumRodjenja.Value.ToString("ddMMyyyy");
nalog.IsRekreativac = false;
nalog.IsAdministrator = false;
nalog.IsPlivac = false;
nalog.IsTrener = true;
nalog.Aktivan = true;
connection.Nalozi.Add(nalog);
connection.SaveChanges();
Treneri trener = new Treneri();
trener.Email = model.Email;
trener.Ime = model.Ime;
trener.Prezime = model.Prezime;
trener.DatumRodjenja = model.DatumRodjenja;
trener.Zvanje = model.Zvanje;
trener.Spol = model.Spol;
trener.Kontakt = model.Telefon;
trener.NalogId = nalog.Id;
connection.Treneri.Add(trener);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool DodajTermin(TerminViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Termini termin = new Termini();
termin.TrenerId = model.TrenerId;
termin.GrupaId = model.GrupaId;
termin.BazenId = model.BazenId;
termin.VrijemeDo = model.VrijemeDo;
termin.VrijemeOd = model.VrijemeOd;
connection.Termin.Add(termin);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private void buttonSignIN_Click(object sender, EventArgs e)
{
// remember to erase
new Home().ShowDialog();
return;
////////////////////
dataContext data = new dataContext();
bool findUser = false;
try {
findUser = data.Users.FirstOrDefault(u => u._userName == boxUserName.Text)._password == boxPassword.Text;
if (findUser == false)
{
throw new Exception();
}
}
catch {
new Message("No Such User & Password", 1).ShowDialog();
return;
}
new Home().ShowDialog();
}
