private void Form1_Load(object sender, EventArgs e)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
var scales = db.Scale;
if (scales.Count() == 0)
{
var scale = new Scale
{
Name = "All",
Description = "All teriotory of Ukraine"
};
db.Scale.Add(scale);
MessageBox.Show("1 row(s) added");
db.SaveChanges();
var scale2 = new Scale
{
Name = "Kyiv",
Description = "All teriotory of Ukraine"
};
db.Scale.Add(scale2);
MessageBox.Show("1 row(s) added");
db.SaveChanges();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (radioGet.Checked)
{
if (checkBox1.Checked && !checkBox2.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
Regex r = new Regex("[0-9]$");
Match m = r.Match(IDBox.Text);
if (m.Success)
{
int id = int.Parse(IDBox.Text);
var company = db.Company.Where(u => u.ID == id);
dataGridView1.Visible = true;
dataGridView1.DataSource = company.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
if (checkBox1.Checked && checkBox2.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
Regex r = new Regex("^[0-9]$");
Match m1 = r.Match(IDBox.Text);
if (m1.Success && comboBox1.Text != "")
{
int id = int.Parse(IDBox.Text);
var scaletxt = comboBox1.Text;
var scale = db.Scale.FirstOrDefault(u => u.Name == scaletxt);
var company = db.Company.Where(u => u.ID == id && u.TradingScaleId == scale.ID);
dataGridView1.Visible = true;
dataGridView1.DataSource = company.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
if (!checkBox1.Checked && checkBox2.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
if (comboBox1.Text != "")
{
var scaletxt = comboBox1.Text;
var scale = db.Scale.FirstOrDefault(u => u.Name == scaletxt);
var company = db.Company.Where(u => u.TradingScaleId == scale.ID);
dataGridView1.Visible = true;
dataGridView1.DataSource = company.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
if (!checkBox1.Checked && !checkBox2.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
var company = db.Company.Join(db.Scale,
c => c.TradingScaleId,
s => s.ID,
(c, s) => new
{
Id = c.ID,
Name = c.Name,
Owner = c.Owner,
Shops = c.NumberOfShops,
HeadCity = c.HeadCity,
TradingScaleName = s.Name,
TradingScale = s.Description
});
dataGridView1.Visible = true;
dataGridView1.DataSource = company.ToList();
}
}
}
if (radioDelete.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
Regex r = new Regex("[0-9]$");
Match m = r.Match(IDBox.Text);
if (m.Success)
{
int id = int.Parse(IDBox.Text);
var cShow = db.Company.Where(c => c.ID == id);
dataGridView1.DataSource = cShow.ToList();
var company = db.Company.FirstOrDefault(c => c.ID == id);
db.Company.Remove(company);
db.SaveChanges();
MessageBox.Show("1 row(s) deleted");
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
if (radioAdd.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
var scaletxt = comboBox1.Text;
var scale = db.Scale.FirstOrDefault(u => u.Name == scaletxt);
Regex r = new Regex("[0-9]$");
if (scale != null && r.Match(scale.ID.ToString()).Success&& r.Match(ShopsBox.Text).Success &&
!String.IsNullOrWhiteSpace(NameBox.Text) &&
!String.IsNullOrWhiteSpace(OwnersBox.Text))
{
Company company = new Company
{
Name = NameBox.Text,
TradingScaleId = scale.ID,
HeadCity = CityBox.Text,
Owner = OwnersBox.Text,
NumberOfShops = int.Parse(ShopsBox.Text)
};
//dataGridView1.DataSource;
db.Company.Add(company);
MessageBox.Show("1 row(s) added");
db.SaveChanges();
var cShow = db.Company
.Where(u => u.Name == NameBox.Text && u.TradingScaleId == scale.ID &&
u.HeadCity == CityBox.Text && u.Owner == OwnersBox.Text);
dataGridView1.DataSource = cShow.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
if (radioPut.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
var scaletxt = comboBox1.Text;
var scale = db.Scale.FirstOrDefault(u => u.Name == scaletxt);
Regex r = new Regex("[0-9]$");
if (scale != null && r.Match(IDBox.Text).Success &&
r.Match(scale.ID.ToString()).Success &&
r.Match(ShopsBox.Text).Success &&
!String.IsNullOrWhiteSpace(NameBox.Text) &&
!String.IsNullOrWhiteSpace(OwnersBox.Text))
{
int id = int.Parse(IDBox.Text);
var comp = db.Company.FirstOrDefault(c => c.ID == id);
comp.Name = NameBox.Text;
comp.TradingScaleId = scale.ID;
comp.HeadCity = CityBox.Text;
comp.Owner = OwnersBox.Text;
comp.NumberOfShops = int.Parse(ShopsBox.Text);
db.SaveChanges();
var cShow = db.Company.Where(c => c.ID == id);
MessageBox.Show("1 row(s) updated");
dataGridView1.DataSource = cShow.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (radioButton1.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
var scales = db.Scale;
dataGridView1.Visible = true;
dataGridView1.DataSource = scales.ToList();
}
}
if (radioButton2.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
if (!String.IsNullOrWhiteSpace(textBox2.Text) && !String.IsNullOrWhiteSpace(textBox3.Text))
{
var scale = new Scale
{
Name = textBox2.Text,
Description = textBox3.Text
};
db.Scale.Add(scale);
MessageBox.Show("1 row(s) added");
db.SaveChanges();
var sShow = db.Scale.Where(u => u.Name == textBox2.Text && u.Description == textBox3.Text);
dataGridView1.DataSource = sShow.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
if (radioButton3.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
Regex r = new Regex("[0-9]$");
Match m = r.Match(textBox1.Text);
if (m.Success && !String.IsNullOrWhiteSpace(textBox2.Text) && !String.IsNullOrWhiteSpace(textBox3.Text))
{
var scaletxt = int.Parse(textBox1.Text);
var scale = db.Scale.FirstOrDefault(u => u.ID == scaletxt);
scale.Name = textBox2.Text;
scale.Description = textBox3.Text;
db.SaveChanges();
MessageBox.Show("1 row(s) updated");
var sShow = db.Scale.Where(u => u.ID == scaletxt);
dataGridView1.DataSource = sShow.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
if (radioButton4.Checked)
{
using (Trade_Of_UkraineEntities db = new Trade_Of_UkraineEntities())
{
Regex r = new Regex("[0-9]$");
Match m = r.Match(textBox1.Text);
if (m.Success)
{
int id = int.Parse(textBox1.Text);
var scale = db.Scale.FirstOrDefault(c => c.ID == id);
db.Scale.Remove(scale);
db.SaveChanges();
MessageBox.Show("1 row(s) deleted");
var sShow = db.Scale.Where(u => u.ID == id);
dataGridView1.DataSource = sShow.ToList();
}
else
{
MessageBox.Show("Wrong input!");
}
}
}
}