private void trimite_info_cont_Click(object sender, EventArgs e)
{
if (trimite_info_cont.Enabled == false)
{
MessageBox.Show("Nu ati facut modificari");
}
else
{
try
{
var context = new Asociatie_ProprietariEntities();
var t_membrei = (from c in context.Membri_Asociatie
where c.ID.Equals(Id_Membru_asociatie)
select c).First();
t_membrei.Nume = nume_tb.Text;
t_membrei.Prenume = prenume_tb.Text;
t_membrei.Emai = prenume_tb.Text;
t_membrei.Numar_telefon = nrtel_tb.Text;
context.SaveChanges();
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Eroare");
}
MessageBox.Show("Succes!");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.All(Char.IsDigit) != true || textBox1.Text.Length == 0)
{
MessageBox.Show("CUI invalid!", "Avertisment", MessageBoxButtons.OK);
}
else
{
using (var context = new Asociatie_ProprietariEntities())
{
var furn = (from c in context.Furnizori
where c.CUI.ToString().Equals(textBox1.Text)
select c);
if (furn.ToList().Count != 0)
{
context.Furnizori.Remove(furn.ToList()[0]);
context.SaveChanges();
this.Close();
}
else
{
MessageBox.Show("CUI inexistent!", "Avertisment", MessageBoxButtons.OK);
}
}
}
}
private void Button_AddOk_Click(object sender, EventArgs e)
{
try
{
var context = new Asociatie_ProprietariEntities();
var newCategory = new Membri_Asociatie()
{
//Nume = _nume,
Prenume = _prenume,
Numar_telefon = _numar_telefon,
Emai = _email,
Functie = _functie,
Data_Inscriere = DateTime.Parse(_data_inscriere)
};
context.Membri_Asociatie.Add(newCategory);
context.SaveChanges();
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Eroare de contectare la server");
}
}
private void finishRegister()
{
try
{
var context = new Asociatie_ProprietariEntities();
context.Membri_Asociatie.Add(datePersonale);
context.Conturi_de_Utilizator.Add(contUtilizator);
for (int i = 0; i < nr_ap_detinute; i++)
{
ap_detinute[i].Numar_locatari = calculeazaNumarulLocatarilor(ap_detinute[i].Numar);
context.Apartamente.Add(ap_detinute[i]);
}
for (int i = 0; i < locatar_cur - 1; i++)
{
context.Locatari.Add(locatari[i]);
}
context.SaveChanges();
this.Close();
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Contacteaza dezvoltatorul!");
}
}
private void Button_AddOk_Click(object sender, EventArgs e)
{
Asociatie_ProprietariEntities context = new Asociatie_ProprietariEntities();
try
{
_ID = Int32.Parse(textBox_ID.Text);
var results = (from row in context.Membri_Asociatie
where row.ID.Equals(_ID)
select row).First();
context.Membri_Asociatie.Remove(results);
context.SaveChanges();
textBox_ID.Clear();
}
catch
{
textBox_ID.Clear();
MessageBox.Show("Incorrect ID");
}
}
private void button_cod_Click(object sender, EventArgs e)
{
using (var context = new Asociatie_ProprietariEntities())
{
var results = (from c in context.Coduri
where c.Cod.TrimEnd().Equals(textBox_cod.Text)
select c);
if (results.Count() != 0)
{
this.Hide();
foreach (var i in results)
{
context.Coduri.Remove(i);
}
context.SaveChanges();
Form reg = new registerForm();
reg.FormClosed += new FormClosedEventHandler(RegFormClosed);
reg.ShowDialog();
}
else
{
user_label.Show();
password_label.Show();
panel_cod.Hide();
MessageBox.Show("Cod invalid!", "Avertisment", MessageBoxButtons.OK);
}
}
}
private void adauga_card_button_Click(object sender, EventArgs e)
{
int _cvc;
try
{
var context = new Asociatie_ProprietariEntities();
var carduri = from c in context.Carduri
where c.Numar_Card.TrimEnd().Equals(nr_cont_textBox.Text) && c.IdMembru.Equals(Id_Membru_asociatie)
select c;
if (carduri.Count() != 0)
{
MessageBox.Show("Cardul deja exista");
}
else
{
if (nr_cont_textBox.Text.Length != 16)
{
nr_cont_textBox.Clear();
cvc_textBox.Clear();
dateexp_textBox.Clear();
MessageBox.Show("nr cont gresit");
}
else
{
if (Int32.TryParse(cvc_textBox.Text, out _cvc) && _cvc.ToString().Length != 3)
{
nr_cont_textBox.Clear();
cvc_textBox.Clear();
dateexp_textBox.Clear();
MessageBox.Show("cvc gresit");
}
else
{
var t_carduri = new Carduri();
{
t_carduri.CVC = Int32.Parse(cvc_textBox.Text);
t_carduri.Numar_Card = nr_cont_textBox.Text;
t_carduri.Data_Expirare = DateTime.Parse(dateexp_textBox.Text);
t_carduri.IdMembru = Id_Membru_asociatie;
};
context.Carduri.Add(t_carduri);
context.SaveChanges();
}
}
}
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Contacteaza dezvoltatorul!");
}
}
private void button_trimite_Click(object sender, EventArgs e)
{
DateTime d;
Int32.TryParse(ComBoxApartamente.Text, out Numar_Apartament);
if (textBox_contracte_inv.Text.Equals(""))
{
label_error.Show();
}
else
{
if (!DateTime.TryParse(textBox_contracte_inv.Text, out d))
{
textBox_contracte_inv.Clear();
label_error.Show();
}
else
{
try
{
var context = new Asociatie_ProprietariEntities();
var t_contracte = from c in context.Contracte_Individuale
where c.IdApartament.Equals(Numar_Apartament) && c.Serviciu.TrimEnd().Equals(comboBox_Servicii.Text)
select c;
if (t_contracte.Count() == 0)
{
context.Contracte_Individuale.Add(new Contracte_Individuale {
IdApartament = Numar_Apartament, Serviciu = comboBox_Servicii.Text, Data = DateTime.Parse(textBox_contracte_inv.Text)
});
context.SaveChanges();
}
else
{
MessageBox.Show("Contractul exista in baza de date");
}
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Nu s-a putut adauga contractul");
}
}
textBox_contracte_inv.Clear();
}
}
private void button_cod_Click(object sender, EventArgs e)
{
try
{
using (var context = new Asociatie_ProprietariEntities())
{
var results = (from c in context.Coduri
where c.Cod.TrimEnd().Equals(textBox_cod.Text)
select c);
if (results.Count() != 0)
{
this.Hide();
foreach (var i in results)
{
context.Coduri.Remove(i);
}
context.SaveChanges();
Form reg = new registerForm();
reg.FormClosed += new FormClosedEventHandler(RegFormClosed);
reg.ShowDialog();
}
else
{
user_label.Show();
password_label.Show();
panel_cod.Hide();
MessageBox.Show("Cod invalid!", "Avertisment", MessageBoxButtons.OK);
}
}
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Contacteaza dezvoltatorul!");
}
}
private void finishRegister()
{
var context = new Asociatie_ProprietariEntities();
context.Membri_Asociatie.Add(datePersonale);
context.Conturi_de_Utilizator.Add(contUtilizator);
for (int i = 0; i < nr_ap_detinute; i++)
{
ap_detinute[i].Numar_locatari = calculeazaNumarulLocatarilor(ap_detinute[i].Numar);
context.Apartamente.Add(ap_detinute[i]);
}
for (int i = 0; i < locatar_cur - 1; i++)
{
context.Locatari.Add(locatari[i]);
}
context.SaveChanges();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text.All(Char.IsDigit) != true || textBox1.Text.Length == 0)
{
MessageBox.Show("CUI invalid!", "Avertisment", MessageBoxButtons.OK);
}
else
{
using (var context = new Asociatie_ProprietariEntities())
{
var furn = (from c in context.Furnizori
where c.CUI.ToString().Equals(textBox1.Text)
select c);
if (furn.ToList().Count != 0)
{
context.Furnizori.Remove(furn.ToList()[0]);
context.SaveChanges();
this.Close();
}
else
{
MessageBox.Show("CUI inexistent!", "Avertisment", MessageBoxButtons.OK);
}
}
}
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Contacteaza dezvoltatorul!");
}
}
private void trimite_gaz_Click(object sender, EventArgs e)
{
int index;
decimal consum;
try
{
var context = new Asociatie_ProprietariEntities();
var t_gaz = (from c in context.Gaz
where c.IdApartament.Equals(Numar_Apartament)
orderby c.Data_Emitere descending
select c).Take(1);
if (!Int32.TryParse(textBox_index.Text, out index))
{
index_error_ac.Show();
textBox_index.Clear();
}
else
{
if (t_gaz.Count() != 0)
{
if (t_gaz.ToList()[0].Data_Emitere.Month.Equals(DateTime.Today.Month) && t_gaz.ToList()[0].Data_Emitere.Year.Equals(DateTime.Today.Year))
{
MessageBox.Show("Citire deja inregistrata pentru luna curenta");
textBox_index.Clear();
}
else
{
if (index < t_gaz.ToList()[0].Index_Nou)
{
MessageBox.Show("Indexul este gresit!");
textBox_index.Clear();
}
else
{
consum = index - t_gaz.ToList()[0].Index_Vechi;
var newEnry = new Gaz()
{
IdApartament = Numar_Apartament,
Consum = index - t_gaz.ToList()[0].Index_Nou,
Index_Vechi = t_gaz.ToList()[0].Index_Nou,
Index_Nou = index,
Suma_de_plata = t_gaz.ToList()[0].Pret_m_cub * consum,
Pret_m_cub = t_gaz.ToList()[0].Pret_m_cub,
Data_Emitere = DateTime.Today
};
context.Gaz.Add(newEnry);
context.SaveChanges();
}
}
}
else
{
if (t_gaz.Count() == 0)
{
var newEntry = new Gaz()
{
Index = 1,
IdApartament = Numar_Apartament,
Index_Vechi = 0,
Index_Nou = index,
Consum = index,
Pret_m_cub = 6,
Suma_de_plata = 6 * index,
Data_Emitere = DateTime.Today
};
context.Gaz.Add(newEntry);
context.SaveChanges();
}
}
}
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Contacteaza dezvoltatorul!");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
int canAdd = 1;
if (textBox1.ToString().Length != 0 && textBox1.Text.All(Char.IsDigit) != true)
{
canAdd = 0;
label_eroare.Text = "CUI-ul contine doar cifre!";
}
else
{
label_eroare.Text = "";
}
if (textBox2.ToString().Length != 0 && char.IsUpper(textBox2.Text.ToString().First()) != true)
{
canAdd = 0;
label_eroare.Text = "Numele pot incepe doar cu litera mare!";
}
else
{
label_eroare.Text = "";
}
if (textBox3.ToString().Length != 0 && Regex.Match(textBox3.Text, @"^(?!\.)(""([^""\r\\]|\\[""\r\\])*""|" +
@"([-a-z0-9!#$%&'*+/=?^_`{|}~]|(?<!\.)\.)*)(?<!\.)" +
@"@[a-z0-9][\w\.-]*[a-z0-9]\.[a-z][a-z\.]*[a-z]$").Success != true)
{
label_eroare.Text = "Format e-mail invalid!";
canAdd = 0;
}
else
{
label_eroare.Text = "";
}
if (textBox1.Text.Length == 0 || textBox2.Text.Length == 0 || textBox3.Text.Length == 0 || textBox4.Text.Length == 0)
{
label_eroare.Text = "Completeaza toate casetele!";
canAdd = 0;
}
else
{
label_eroare.Text = "";
}
if (canAdd == 1)
{
var context = new Asociatie_ProprietariEntities();
var furnizor_nou = new Furnizori()
{
CUI = System.Convert.ToDecimal(textBox1.Text),
Nume = textBox2.Text,
Email = textBox3.Text,
Serviciu = textBox4.Text,
Data_semnare_contract = DateTime.Today.AddYears(-1),
Data_expirare_contract = DateTime.Today.AddYears(+1)
};
context.Furnizori.Add(furnizor_nou);
context.SaveChanges();
this.Close();
}
}
catch (Exception ex)
{
File.AppendAllText("errors.txt", "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
string New = Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine;
File.AppendAllText("errors.txt", New);
MessageBox.Show("Contacteaza dezvoltatorul!");
}
}
private void button1_Click(object sender, EventArgs e)
{
int canAdd = 1;
if (textBox1.Text.All(Char.IsDigit) != true)
{
canAdd = 0;
label_eroare.Text = "CUI-ul contine doar cifre!";
}
else
{
label_eroare.Text = "";
}
if (char.IsUpper(textBox2.Text.ToString().First()) != true)
{
canAdd = 0;
label_eroare.Text = "Numele pot incepe doar cu litera mare!";
}
else
{
label_eroare.Text = "";
}
if (Regex.Match(textBox3.Text, @"^(?!\.)(""([^""\r\\]|\\[""\r\\])*""|" +
@"([-a-z0-9!#$%&'*+/=?^_`{|}~]|(?<!\.)\.)*)(?<!\.)" +
@"@[a-z0-9][\w\.-]*[a-z0-9]\.[a-z][a-z\.]*[a-z]$").Success != true)
{
label_eroare.Text = "Format e-mail invalid!";
canAdd = 0;
}
else
{
label_eroare.Text = "";
}
if (textBox1.Text.Length == 0 || textBox2.Text.Length == 0 || textBox3.Text.Length == 0 || textBox4.Text.Length == 0)
{
label_eroare.Text = "Completeaza toate casetele!";
canAdd = 0;
}
else
{
label_eroare.Text = "";
}
if (canAdd == 1)
{
var context = new Asociatie_ProprietariEntities();
var furnizor_nou = new Furnizori()
{
CUI = System.Convert.ToDecimal(textBox1.Text),
Nume = textBox2.Text,
Email = textBox3.Text,
Serviciu = textBox4.Text,
Data_semnare_contract = DateTime.Today.AddYears(-1),
Data_expirare_contract = DateTime.Today.AddYears(+1)
};
context.Furnizori.Add(furnizor_nou);
context.SaveChanges();
this.Close();
}
}
private void Button_ModifyOK_Click(object sender, EventArgs e)
{
Asociatie_ProprietariEntities context = new Asociatie_ProprietariEntities();
try
{
_ID = Int32.Parse(textBox_ID.Text);
_nume = textBox_Nume.Text;
_prenume = textBox_Prenume.Text;
_numar_telefon = textBox_NrTel.Text;
_email = textBox_Email.Text;
_functie = textBox_Functie.Text;
_data_inscriere = textBox_DataInscriere.Text;
var results = (from row in context.Membri_Asociatie
where row.ID.Equals(_ID)
select row).First();
if (_nume != "")
{
results.Nume = _nume;
}
if (_prenume != "")
{
results.Prenume = _prenume;
}
if (_numar_telefon != "")
{
results.Numar_telefon = _numar_telefon;
}
if (_email != "")
{
results.Emai = _email;
}
if (_functie != "")
{
results.Functie = _functie;
}
if (_data_inscriere != "")
{
results.Data_Inscriere = DateTime.Parse(_data_inscriere);
}
context.SaveChanges();
textBox_ID.Clear();
textBox_Nume.Clear();
textBox_Prenume.Clear();
textBox_NrTel.Clear();
textBox_Email.Clear();
textBox_Functie.Clear();
textBox_DataInscriere.Clear();
}
catch
{
textBox_ID.Clear();
textBox_Nume.Clear();
textBox_Prenume.Clear();
textBox_NrTel.Clear();
textBox_Email.Clear();
textBox_Functie.Clear();
textBox_DataInscriere.Clear();
MessageBox.Show("Incorrect ID");
}
}
