private void saveContrButton_Click(object sender, EventArgs e)
{
connectionString = @"Data Source=.\SQLEXPRESS; Initial Catalog = D:\НАСТЯ\ДИПЛОМ\ACCOUNT_GRAIN.MDF; Integrated Security = True";
if (contr == null)
{
contr = new Contractor(nameContrTextBox.Text, subTextBox.Text, yurAdressTextBox.Text, factAdressTextBox.Text, Convert.ToInt32(indexTextBox.Text), phoneTextBox.Text, innTextBox.Text);
string sql = "Insert into Сontractor (name_contractor,subdivision,jur_address,fact_address,mail_index,phone,inn) values (@name_contractor, @subdivision, @jur_address, @fact_address, @mail_index, @phone, @inn)";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
cmd.Parameters.AddWithValue("@name_contractor", contr.Name);
cmd.Parameters.AddWithValue("@subdivision", contr.Sub);
cmd.Parameters.AddWithValue("@jur_address", contr.YurAdress);
cmd.Parameters.AddWithValue("@fact_address", contr.FactAdress);
cmd.Parameters.AddWithValue("@mail_index", contr.Index);
cmd.Parameters.AddWithValue("@phone", contr.Phone);
cmd.Parameters.AddWithValue("@inn", contr.Inn);
cmd.ExecuteNonQuery();
connection.Close();
}
}
else
{
contr.Name = nameContrTextBox.Text;
contr.Sub = subTextBox.Text;
contr.YurAdress = yurAdressTextBox.Text;
contr.FactAdress = factAdressTextBox.Text;
contr.Index = Convert.ToInt32(indexTextBox.Text);
contr.Phone = phoneTextBox.Text;
contr.Inn = innTextBox.Text;
string sql = string.Format("Update Сontractor Set name_contractor='{0}',subdivision='{1}', jur_address='{2}', fact_address='{3}', mail_index='{4}', phone='{5}', inn='{6}' where id_contractor='{7}'",
contr.Name, contr.Sub, contr.YurAdress, contr.FactAdress, contr.Index, contr.Phone, contr.Inn, contr.Id);
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
}
this.Close();
}
private void removeContagentButton_Click(object sender, EventArgs e)
{
try
{
DataGridViewRow row = dataGridView1.SelectedRows[0];
DialogResult dr = MessageBox.Show("Вы действительно хотите удалить запись?",
"Удаление", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (dr == DialogResult.OK)
{
Contractor contr = new Contractor(Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value));
string sql = string.Format("Delete from Сontractor where id_contractor='{0}'", contr.Id);
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
this.сontractorTableAdapter.Fill(this.account_grainDataSet.Сontractor);
}
}
catch (System.ArgumentOutOfRangeException) { MessageBox.Show("Выберите контрагента!", "Удаление", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
public void AddContractor(String name, String address, String landLine, String mobile, String employeeID, String email)
{
// Open database (or create if not exits)
using (var db = new LiteDatabase(@"IQIncorporated.db"))
{
// Get contractors collection
var contractors = db.GetCollection <Contractor>("contractors");
// Create your new contractor instance
var contractor = new Contractor
{
Name = name,
Address = address,
LandLine = landLine,
Mobile = mobile,
EmployeeID = employeeID,
Email = email
};
// Insert new customer document (Id will be auto-incremented)
contractors.Insert(contractor);
}
}
private void CompleteSave_Click(object sender, EventArgs e)
{
//checks if the cost and description are empty
if (CompleteCost.Text != "" && CompleteDescription.Text != "")
{
Job jobTable = new Job();
Contractor contractorTable = new Contractor();
Client clientTable = new Client();
//Updates job with new information
if (JobListView.SelectedIndices.Count > 0)
{
jobTable.UpdateJob(Int32.Parse(JobListView.Items[JobListView.SelectedIndices[0]].SubItems[4].Text.Trim()), CompleteCost.Text, CompleteDescription.Text, FinishedCheck.Checked);
}
else
{
MessageBox.Show("Please reselect the current job");
}
}
else
{
MessageBox.Show("Please add the price and/or the description and/or select a valid job");
}
}
