private void pbSaveClient_Click(object sender, EventArgs e)
{
if (newClient)
{
Clientss client = new Clientss();
GetDataFromControls(client);
if (txtName.Text == "")
{
MessageBox.Show("Complete at least Client Name!", "Atention!", MessageBoxButtons.OK);
}
else
{
try
{
Tables.TblClients.InsertOnSubmit(client);
Exacta.Menu.db.SubmitChanges();
}
catch (Exception err)
{
MessageBox.Show("There was an error. " + err);
}
newClient = false;
}
}
else
{
if (dgvClients.Rows.Count == 0)
{
return;
}
var dialog = MessageBox.Show("Do you want to update Client?", "Client update", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialog == DialogResult.No)
{
return;
}
Clientss client = Exacta.Menu.db.GetTable <Clientss>().SingleOrDefault(cl => cl.Id.ToString() == selectedClient);
try
{
Articole art = Exacta.Menu.db.GetTable <Articole>().SingleOrDefault(ar => ar.Client == client.Name);
if (art != null)
{
art.Client = txtName.Text;
}
GetDataFromControls(client);
Exacta.Menu.db.SubmitChanges();
}
catch (Exception err)
{
MessageBox.Show("There was an error. " + err);
}
}
LoadClients();
dgvClients.Enabled = true;
Additional.FillTheFilter(dgvClients, cbClient, 1);
}
private void GetDataFromControls(Clientss c)
{
c.Name = txtName.Text;
c.Address = txtAddress.Text;
c.Country = txtCountry.Text;
c.Mail = txtMail.Text;
c.Telephone = txtTelephone.Text;
c.Bank = txtBank.Text;
c.VATNumber = txtVat.Text;
}
private void Save_Click(object sender, EventArgs e)
{
this.donevalue = 0;
try
{
if (clientNametextbox.Text == "")
{
MessageBox.Show("من فضلك ادخل اسم العميل", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (Convert.ToDouble(RemainingMonytextbox.Text) != (Convert.ToDouble(AllMonytextBox.Text) - Convert.ToDouble(PaiedMonytextpox.Text)))
{
MessageBox.Show("القيمة المتبقية من الاموال غير مستحقة", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
PaiedMonytextpox.Text = "0";
RemainingMonytextbox.Text = "0";
return;
}
var clientifexist = context.clientLaterPaymentinfos.FirstOrDefault(c => c.Name == clientNametextbox.Text);
var clientexistinmainclienttable = context.clients.FirstOrDefault(c => c.Name == clientNametextbox.Text);
if (firstPhonetextbox.Text != "")
{
clientifexistusingphone1 = context.clientLaterPaymentinfos.FirstOrDefault(c => (c.FirstPhoneNumner == firstPhonetextbox.Text) || (c.SecondPhoneNumner == firstPhonetextbox.Text));
clientifexistusingphone1inclienttable = context.clients.FirstOrDefault(c => (c.FirstPhoneNumner == firstPhonetextbox.Text) || (c.SecondPhoneNumner == firstPhonetextbox.Text));
}
if (seceondPhoneTextbox.Text != "")
{
clientifexistusingphone2 = context.clientLaterPaymentinfos.FirstOrDefault(c => (c.FirstPhoneNumner == seceondPhoneTextbox.Text) || (c.SecondPhoneNumner == seceondPhoneTextbox.Text));
clientifexistusingphone2inclienttable = context.clients.FirstOrDefault(c => (c.FirstPhoneNumner == seceondPhoneTextbox.Text) || (c.SecondPhoneNumner == seceondPhoneTextbox.Text));
}
if (clientifexist != null)
{
DialogResult dialog = MessageBox.Show("هذا الاسم موجود بافعل لا يمكنك اضافتة مرة اخرى", "المريض موجود", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dialog == DialogResult.OK)
{
FormClearName();
clientifexist = null;
return;
}
}
if (clientexistinmainclienttable != null)
{
DialogResult dialog = MessageBox.Show("هذا الاسم موجود بافعل فى قائمة العملاء يمكنك اضافة دفع اجل له من هناك", "المريض موجود", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dialog == DialogResult.OK)
{
FormClearName();
clientifexist = null;
return;
}
}
if (clientifexistusingphone1 != null || clientifexistusingphone2 != null)
{
DialogResult dialog = MessageBox.Show("رقم الهاتف موجود بافعل لا يمكنك اضافتة مرة اخرى ", "المريض موجود", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dialog == DialogResult.OK)
{
FormClearphone();
clientifexistusingphone1 = null;
clientifexistusingphone2 = null;
return;
}
}
if (clientifexistusingphone1inclienttable != null || clientifexistusingphone2inclienttable != null)
{
DialogResult dialog = MessageBox.Show("رقم الهاتف لهذا العميل موجود بافعل فى قائمة العملاء يمكنك اضافة دفع اجل له من هناك", "المريض موجود", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dialog == DialogResult.OK)
{
FormClearphone();
clientifexistusingphone1inclienttable = null;
clientifexistusingphone2inclienttable = null;
return;
}
}
ClientLaterPaymentinfo newclient = new ClientLaterPaymentinfo()
{
Name = clientNametextbox.Text,
Address = clientAddresstextbox.Text,
FirstPhoneNumner = firstPhonetextbox.Text,
SecondPhoneNumner = seceondPhoneTextbox.Text,
Nots = NotstextBox.Text,
DelevaryService = Convert.ToDouble(serviceNumeric.Value),
};
context.clientLaterPaymentinfos.Add(newclient);
context.SaveChanges();
Clientss newclientt = new Clientss()
{
Name = clientNametextbox.Text,
Address = clientAddresstextbox.Text,
FirstPhoneNumner = firstPhonetextbox.Text,
SecondPhoneNumner = seceondPhoneTextbox.Text,
Nots = NotstextBox.Text,
DelevaryService = Convert.ToDouble(serviceNumeric.Value),
DateAdded = AddeddateTimePicker.Value,
LaterClientID = newclient.Id
};
context.clients.Add(newclientt);
context.SaveChanges();
var curentclientid = context.clientLaterPaymentinfos.FirstOrDefault(
c => c.Name == clientNametextbox.Text &&
c.Address == clientAddresstextbox.Text &&
c.FirstPhoneNumner == firstPhonetextbox.Text &&
c.SecondPhoneNumner == seceondPhoneTextbox.Text &&
c.Nots == NotstextBox.Text
);
OrderMoneAndDate newduration = new OrderMoneAndDate
{
DateAdded = AddeddateTimePicker.Value,
allMony = Convert.ToDouble(AllMonytextBox.Text),
paidOrderMony = Convert.ToDouble(PaiedMonytextpox.Text),
RemaningOrderMony = Convert.ToDouble(RemainingMonytextbox.Text),
clientid = curentclientid.Id,
orderid = this.ordeid
};
context.OrderMoneAndDates.Add(newduration);
context.SaveChanges();
MessageBox.Show("تم الاضافة بنجاح", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormClear();
this.donevalue = 1;
this.DialogResult = DialogResult.OK;
this.Close();
}
catch {
DialogResult dialog = MessageBox.Show("من فضلك اكمل بيانات الدفع", "المريض موجود", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
