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