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