private void buttonSave_MouseClick(object sender, MouseEventArgs e)
{
try
{
if (comboBoxMenuItems.Text.Trim() != "" && textBoxAvailableStock.Text.Trim() != "")
{
if (buttonSave.Text == "Save")
{
Stock_Tbl obj = new Stock_Tbl();
obj.CategoryName = comboBoxCategory.Text;
obj.ItemName = comboBoxMenuItems.Text;
obj.Date = dateTimePickerStock.Value;
obj.Quantity = Convert.ToInt32(textBoxAvailableStock.Text);
using (RMSDBEntities db = new RMSDBEntities())
{
db.Stock_Tbl.Add(obj);
db.SaveChanges();
MessageBox.Show("Data Added Seccessfully.");
clearStock();
LoadAllTables();
}
}
else if (buttonSave.Text == "Update")
{
using (RMSDBEntities db = new RMSDBEntities())
{
Stock_Tbl RowinDb = db.Stock_Tbl.Where(d => d.Id == IdforUpdate).SingleOrDefault();
RowinDb.CategoryName = comboBoxCategory.Text;
RowinDb.ItemName = comboBoxMenuItems.Text;
RowinDb.Date = dateTimePickerStock.Value;
RowinDb.Quantity = Convert.ToInt32(textBoxAvailableStock.Text);
db.SaveChanges();
MessageBox.Show("Data Updated Seccessfully.");
clearStock();
LoadAllTables();
}
}
}
else
{
MessageBox.Show("Incomplete Form", "Please Fill Complete Form.!");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, "Error Message");
}
}
private void dataGridView2_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
if (e.ColumnIndex == 0)
{
IdforUpdate = Convert.ToInt32(dataGridView2.Rows[e.RowIndex].Cells[2].Value);
comboBoxCategory.SelectedIndex = comboBoxCategory.FindString(dataGridView2.Rows[e.RowIndex].Cells[3].Value.ToString());
comboBoxMenuItems.SelectedIndex = comboBoxMenuItems.FindString(dataGridView2.Rows[e.RowIndex].Cells[4].Value.ToString());
dateTimePickerStock.Value = DateTime.Parse(dataGridView2.Rows[e.RowIndex].Cells[5].Value.ToString());
textBoxAvailableStock.Text = dataGridView2.Rows[e.RowIndex].Cells[6].Value.ToString();
buttonSave.Text = "Update";
}
else if (e.ColumnIndex == 1)
{
DeleteDialogBox obj = new DeleteDialogBox();
obj.ShowDialog();
if (DeleteDialogBox.delete == 1)
{
using (RMSDBEntities db = new RMSDBEntities())
{
IdforUpdate = Convert.ToInt32(dataGridView2.Rows[e.RowIndex].Cells[2].Value.ToString());
Stock_Tbl RowinDb = db.Stock_Tbl.Where(d => d.Id == IdforUpdate).SingleOrDefault();
if (RowinDb != null)
{
db.Stock_Tbl.Remove(RowinDb);
db.SaveChanges();
MessageBox.Show("Deleted Successfully!");
LoadAllTables();
}
}
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, "Exception Error");
}
}
