public AddFirmForm(string connectionString) { InitializeComponent(); context = new classroom_fundEntities(connectionString); submitButton.Text = "Добавить"; mode = true; }
public AddActOfRentingForm(string connectionString, long id) { InitializeComponent(); context = new classroom_fundEntities(connectionString); firmCB.DataSource = (from fr in context.firm select fr.name + ";" + fr.contact_phone_number + ";" + fr.contact_first_name + ";" + fr.contact_last_name + ";" + fr.contact_middle_name).ToList(); firmCB.SelectedItem = null; this.id = id; act_of_renting a = context.act_of_renting.Find(id); floorInput.Value = a.floor_number; startSateDTP.Value = a.start_date; endDateDTP.Value = a.end_date; sumInput.Value = a.sum_of_money; string f = (from fr in context.firm where fr.id == a.firm_id select fr.name + ";" + fr.contact_phone_number + ";" + fr.contact_first_name + ";" + fr.contact_last_name + ";" + fr.contact_middle_name).FirstOrDefault(); foreach (string item in firmCB.Items) { if (f == item) { firmCB.SelectedItem = item; } } submitButton.Text = "Изменить"; mode = false; }
private void enter_Click(object sender, EventArgs e) { try { string connectionString; if (windowsCheck.Checked) { connectionString = $"metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=\"data source={ServerInput.Text};initial catalog={DBInput.Text};integrated security=True;MultipleActiveResultSets=True;App=EntityFramework\""; } else { connectionString = $"metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=\"data source={ServerInput.Text};initial catalog={DBInput.Text};integrated security=False;User ID={loginInput.Text};Password={passwordInput.Text};MultipleActiveResultSets=True;App=EntityFramework\""; } try { using (classroom_fundEntities context = new classroom_fundEntities(connectionString)) { context.Database.Connection.Open(); context.Database.Connection.Close(); } } catch (SqlException) { MessageBox.Show("Ошибка подкючения"); return; } Form1 form = new Form1(connectionString); form.Show(); Close(); } catch (Exception) { MessageBox.Show("Ошибка подключения"); } }
public AddClassroomForm(string connectionString, long id) { InitializeComponent(); context = new classroom_fundEntities(connectionString); responsibleP.DataSource = (from p in context.person select p.first_name + ";" + p.last_name + ";" + p.middle_name + ";" + p.phone_number + ";" + p.address).ToList(); responsibleP.SelectedItem = null; this.id = id; classroom c = context.classroom.Find(id); floorInput.Value = c.floor_number; numberInput.Value = c.number; capacityInput.Value = c.capacity; safetyInput.Checked = c.compliance_with_safety_regulations; string pers = (from p in context.person where p.id == c.responsible_person_id select p.first_name + ";" + p.last_name + ";" + p.middle_name + ";" + p.phone_number + ";" + p.address).FirstOrDefault(); foreach (string item in responsibleP.Items) { if (pers == item) { responsibleP.SelectedItem = item; } } submitButton.Text = "Изменить"; mode = false; }
public Form1(string connectionString) { this.connectionString = connectionString; context = new classroom_fundEntities(connectionString); string a = context.Database.Connection.ConnectionString; InitializeComponent(); changeTable.SelectedIndex = 0; }
public AddActOfRentingForm(string connectionString) { InitializeComponent(); context = new classroom_fundEntities(connectionString); firmCB.DataSource = (from fr in context.firm select fr.name + ";" + fr.contact_phone_number + ";" + fr.contact_first_name + ";" + fr.contact_last_name + ";" + fr.contact_middle_name).ToList(); firmCB.SelectedItem = null; submitButton.Text = "Добавить"; mode = true; }
public AddClassroomForm(string connectionString) { InitializeComponent(); context = new classroom_fundEntities(connectionString); responsibleP.DataSource = (from p in context.person select p.first_name + ";" + p.last_name + ";" + p.middle_name + ";" + p.phone_number + ";" + p.address).ToList(); responsibleP.SelectedItem = null; submitButton.Text = "Добавить"; mode = true; }
public AddFirmForm(string connectionString, long id) { InitializeComponent(); context = new classroom_fundEntities(connectionString); this.id = id; firm f = context.firm.Find(id); nameInput.Text = f.name; PhoneInput.Text = f.contact_phone_number; contactFNInput.Text = f.contact_first_name; contactLNInput.Text = f.contact_last_name; contactMNInput.Text = f.contact_middle_name; submitButton.Text = "Изменить"; mode = false; }
public AddPersonForm(string connectionString, long id) { InitializeComponent(); context = new classroom_fundEntities(connectionString); this.id = id; person p = context.person.Find(id); nameInput.Text = p.first_name; lastNameInput.Text = p.last_name; middleNameInput.Text = p.middle_name; phoneNumberInput.Text = p.phone_number; addressInput.Text = p.address; submitButton.Text = "Изменить"; mode = false; }
public AddFloorForm(string connectionString, byte num) { InitializeComponent(); context = new classroom_fundEntities(connectionString); numberInput.Value = num; }
public AddFloorForm(string connectionString) { InitializeComponent(); context = new classroom_fundEntities(connectionString); }