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