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