private void New_Click(object sender, EventArgs e)
{
Company_ProjectEntities company_Project = new Company_ProjectEntities();
try
{
string manf = dateTimePicker1.Value.ToShortDateString();
string exp = dateTimePicker2.Value.ToShortDateString();
var itNAme = (from i in company_Project.items
where i.name == comboBox2.Text && i.size == textBox3.Text &&
i.ManifuctureDate == manf && i.expireDate == exp
select i).First();
Storage_item si = new Storage_item();
si.amount = int.Parse(textBox4.Text);
si.Item_ID = int.Parse(textBox1.Text);
var st = (from i in company_Project.Storages
where i.name == comboBox1.Text
select i).First();
si.Storage_ID = st.ID_storage;
company_Project.Storage_item.Add(si);
company_Project.SaveChanges();
MessageBox.Show($"New {comboBox2.Text} added in {comboBox1.Text}.");
}
catch
{
item it = new item();
Random rnd = new Random();
textBox1.Text = rnd.Next().ToString();
it.ID_item = int.Parse(textBox1.Text);
try
{
var itNAme = (from i in company_Project.items where i.name == comboBox2.Text select i).First();
MessageBox.Show("this name is exist.");
}
catch
{
it.name = comboBox2.Text;
it.size = textBox3.Text;
it.ManifuctureDate = dateTimePicker1.Value.ToShortDateString();
it.expireDate = dateTimePicker2.Value.ToShortDateString();
Storage_item si = new Storage_item();
if (textBox4.Text == String.Empty)
{
MessageBox.Show("item have to have ammount");
}
else
{
si.amount = int.Parse(textBox4.Text);
}
si.Item_ID = int.Parse(textBox1.Text);
var st = (from i in company_Project.Storages
where i.name == comboBox1.Text
select i).First();
si.Storage_ID = st.ID_storage;
company_Project.Storage_item.Add(si);
company_Project.items.Add(it);
company_Project.SaveChanges();
MessageBox.Show($"New {comboBox2.Text} added in {comboBox1.Text}.");
}
}
}
private void Save_Recipt_Click(object sender, EventArgs e)
{
Company_ProjectEntities company_Project = new Company_ProjectEntities();
for (int a = 0; a < dt.Rows.Count; a++)
{
Permission per = new Permission();
per.permission_ID = int.Parse(textBox1.Text);
per.typePermission = "rec";
per.Date_permission = dateTimePicker1.Value.ToShortDateString();
string st_name = dt.Rows[a][0].ToString();
var st = (from i in company_Project.Storages where i.name == st_name select i).First();
per.stroage_id = st.ID_storage;
string it_name = dt.Rows[a][1].ToString();
var it = (from i in company_Project.items where i.name == it_name select i).First();
per.item_id = it.ID_item;
per.amount_item = int.Parse(dt.Rows[a][2].ToString());
if (listBox1.SelectedItem == null)
{
MessageBox.Show("select supplier"); break;
}
else
{
string newper = listBox1.SelectedItem.ToString();
var sup = (from q in company_Project.Customers_Suppliers
where q.name == newper && q.type == "Sup" select q).First();
per.name_id = sup.ID;
}
per.expireDate = dateTimePicker4.Value.ToShortDateString();
per.Comment = textBox4.Text;
company_Project.Permissions.Add(per);
company_Project.SaveChanges();
try
{
var check = (from i in company_Project.Storage_item
where i.Storage_ID == st.ID_storage && i.Item_ID == it.ID_item
select i).First();
check.amount += int.Parse(dt.Rows[a][2].ToString());
}
catch
{
Storage_item st_it = new Storage_item();
st_it.Storage_ID = st.ID_storage;
st_it.Item_ID = it.ID_item;
st_it.amount = int.Parse(dt.Rows[a][2].ToString());
company_Project.Storage_item.Add(st_it);
}
company_Project.SaveChanges();
}
MessageBox.Show("items added");
}