private void button1_Click(object sender, EventArgs e)
{
PharmacyDataContext db = new PharmacyDataContext();
try
{
// int columnIndex = Convert.ToInt32(dataGridView1.CurrentRow.Cells[1].Value.ToString());
//var itemDrug = (from x in db.Warehouse where x.Id == columnIndex select x).First();
// var itemOrder = (from x in db.Order where x.Id == Convert.ToInt32(dataGridView2.CurrentRow.Cells[0].Value.ToString()) select x).First();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1[4, i].Value != null)// && dataGridView1[4, i].Value>)
{
int itemId = Convert.ToInt32(dataGridView1[0, i].Value.ToString());
var itemDrug = (from x in db.Warehouse where x.Id == itemId select x).First();
if (itemDrug.Count > Convert.ToInt32(dataGridView1[4, i].Value.ToString()))
{
Order order = new Order
{
Date = DateTime.Now,
IdDrug = Convert.ToInt32(dataGridView1[0, i].Value),
IdStatus = 2,
Count = Convert.ToInt32(dataGridView1[4, i].Value)
};
db.Order.InsertOnSubmit(order);
db.SubmitChanges();
}
else
{
MessageBox.Show("Count in order more than count in warehouse");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally { Dispose(); }
}
public PharmaciesController(PharmacyDataContext context)
{
_context = context;
}
public UserLoginController(IConfiguration config, IJWTService jwtservice, PharmacyDataContext context)
{
_config = config;
_context = context;
_jwtService = jwtservice;
}
public OrdersController(PharmacyDataContext context, IWebHostEnvironment hostEnvironment)
{
_context = context;
this._hostEnvironment = hostEnvironment;
}
public CustomersController(PharmacyDataContext context)
{
_context = context;
}
public LoginsController(PharmacyDataContext context)
{
_context = context;
}
public MessagesController(PharmacyDataContext context)
{
_context = context;
}
public OrdersController(PharmacyDataContext context, IOrderService imageService)
{
_context = context;
_iorderService = imageService;
}
public JWTService(IConfiguration config, PharmacyDataContext context)
{
_config = config;
_context = context;
}
public OrdersController(PharmacyDataContext context)
{
_context = context;
}
