示例#1
0
 public async static Task Dodaj(Klient klient)
 {
     using (var db = new KlientContext())
     {
         db.Klients.Add(klient);
         await db.SaveChangesAsync();
     }
 }
示例#2
0
 public static async Task Wyswietl(DataTable table)
 {
     using (var db = new KlientContext())
     {
         var klienci = await(from klient in db.Klients orderby klient.KlientID select klient).ToListAsync();
         table.Clear();
         foreach (var klient in klienci)
         {
             table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
         }
     }
 }
示例#3
0
 public async static Task Usun(Klient klient)
 {
     using (var db = new KlientContext())
     {
         var result = db.Klients.SingleOrDefault(b => b.KlientID == klient.KlientID);
         if (result != null)
         {
             Klient k = db.Klients.First(id => id.KlientID == klient.KlientID);
             db.Entry(k).State = EntityState.Deleted;
             await db.SaveChangesAsync();
         }
     }
 }
示例#4
0
 public async static Task Edytuj(Klient klient)
 {
     using (var db = new KlientContext())
     {
         var result = db.Klients.SingleOrDefault(k => k.KlientID == klient.KlientID);
         if (result != null)
         {
             Klient k = db.Klients.First(id => id.KlientID == klient.KlientID);
             k.Imie            = klient.Imie;
             k.Nazwisko        = klient.Nazwisko;
             k.Adres           = klient.Adres;
             k.Telefon         = klient.Telefon;
             k.Email           = klient.Email;
             k.Status          = klient.Status;
             db.Entry(k).State = EntityState.Modified;
             await db.SaveChangesAsync();
         }
     }
 }
示例#5
0
        public async static Task Wyszukaj(string ciag, string kolumna, DataTable table)
        {
            using (var db = new KlientContext())
            {
                table.Clear();
                switch (kolumna)
                {
                case "ID":
                    int id      = Convert.ToInt32(ciag);
                    var klienci = await(from klient in db.Klients where id == klient.KlientID orderby klient.KlientID select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                case "Imię":
                    klienci = await(from klient in db.Klients where ciag == klient.Imie orderby klient.KlientID select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                case "Nazwisko":
                    klienci = await(from klient in db.Klients where ciag == klient.Nazwisko orderby klient.KlientID select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                case "Adres":
                    klienci = await(from klient in db.Klients where ciag == klient.Adres orderby klient.KlientID select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                case "Telefon":
                    klienci = await(from klient in db.Klients where ciag == klient.Telefon orderby klient.KlientID select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                case "Email":
                    klienci = await(from klient in db.Klients where ciag == klient.Email orderby klient.KlientID select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                case "Status":
                    klienci = await(from klient in db.Klients where ciag == klient.Status orderby klient.KlientID select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                case "Bez telefonu i emailu":
                    klienci = await(from klient in db.Klients where (ciag == klient.Imie || ciag == klient.Nazwisko || ciag == klient.Adres ||
                                                                     ciag == klient.Status) && klient.Telefon == "" && klient.Email == "" orderby klient.KlientID
                                    select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;

                default:
                    klienci = await(from klient in db.Klients where ciag == klient.Imie || ciag == klient.Nazwisko || ciag == klient.Adres ||
                                    ciag == klient.Telefon || ciag == klient.Email || ciag == klient.Status orderby klient.KlientID
                                    select klient).ToListAsync();
                    foreach (var klient in klienci)
                    {
                        table.Rows.Add(klient.KlientID, klient.Imie, klient.Nazwisko, klient.Adres, klient.Telefon, klient.Email, klient.Status);
                    }
                    break;
                }
            }
        }