private void search_Click(object sender, EventArgs e) { DBHandler instance = DBHandler.getInstance(); if(byName.Checked){ string[] list= searchText.Text.Split('-'); string name = list[0]; string phone = list[1]; selectedClient = instance.getClient(name, phone); } else { selectedClient = instance.getClient(int.Parse(searchText.Text)); } clientsSelectElements(); clientToFields(); //fieldsToClient(); }
private void createClient_Click(object sender, EventArgs e) { DBHandler instance = DBHandler.getInstance(); selectedClient = new Client(); selectedReservation = new Reservation(); fieldsToClient(); fieldsToReservation(); //validations goes here bool valid = true; string msg = ""; //end validations if (valid) { instance.insertResrvation(selectedClient, trip, selectedReservation); if (hasGroup.Checked) { instance.insertClientGroup(selectedClient.ID, (int)grpIDs[grpIndex]); } if (hasBus.Checked) { instance.insertClientGroup(selectedClient.ID, (int)busesIDs[busIndex]); } Prompt.ShowWarningDialog("تم اضافة العميل بنجاح", "تم"); //updateAutoComplete(); tripToFields(); clientsDefaults(); } else { Prompt.ShowWarningDialog(msg, "تحذير"); } }
public bool insertClient(Client c) { DB.clients.Add(c); return DB.SaveChanges() > 0; }
public bool updateClient(Client c) { DB.clients.Attach(c); DB.Entry(c).State = EntityState.Modified; return DB.SaveChanges() > 0; }
public bool removeClient(Client c) { DB.clients.Remove(c); return DB.SaveChanges() > 0; }
public bool insertResrvation(Client c, Trip t, Reservation r) { insertClient(c); // Reservation r = new Reservation(); r.clientID = c.ID; r.tripID = t.ID; t.nextTicketID++; DB.trips.Attach(t); DB.Entry(t).State = EntityState.Modified; DB.reservations.Add(r); return DB.SaveChanges() > 0; }