public void editItemU_M(string itemU_M, TextBox textBox_ItemU_M, DataGridView dataGridView_U_M)
{
model_t_ItemU_M.ItemU_M = itemU_M;
using (testDBEntities db = new testDBEntities())
{
db.Entry(model_t_ItemU_M).State = EntityState.Modified;
db.SaveChanges();
}
ClearDataGridView_t_ItemU_M(textBox_ItemU_M);
populateDataGridView_t_ItemU_M(dataGridView_U_M);
MessageBox.Show("Submitted Successfully");
}
/// <summary>
/// editng item on items table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonItemsEdit_Click(object sender, EventArgs e)
{
model_t_Items.ItemAmount = Convert.ToDecimal(textBoxItemsAmount.Text.Trim());
model_t_Items.ItemPrice = Convert.ToDecimal(textBoxItemsPrice.Text.Trim());
model_t_Items.ItemU_M = comboBoxMeasuremntUnit.Text.Trim();
model_t_Items.ItemDescription = richTextBoxItemsDesc.Text.Trim();
using (testDBEntities db = new testDBEntities())
{
db.Entry(model_t_Items).State = EntityState.Modified;
db.SaveChanges();
}
ClearDataGridView_t_Items();
populateDataGridViewItems();
MessageBox.Show("Submitted Successfully");
}
/// <summary>
/// editing order
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOrdersEdit_Click(object sender, EventArgs e)
{
model_t_Orders.OrderDate = Convert.ToDateTime(dateTimePickerOrders.Text.Trim());
model_t_Orders.CustomerName = textBoxOrders_CustName.Text.Trim();
model_t_Orders.CustomerAddress = textBoxOrdersCust_Adress.Text.Trim();
model_t_Orders.CustomerPhone = textBoxCustomerPhone.Text.Trim();
//model_t_Orders.TotalAmount = Convert.ToDecimal(textBoxOrdersToatl.Text.Trim());
model_t_Orders.RefaundAmount = Convert.ToDecimal(textBoxRefaundAmount.Text.Trim());
model_t_Orders.CustomerCity = textBoxOrdersCustomerCity.Text.Trim();
using (testDBEntities db = new testDBEntities())
{
db.Entry(model_t_Orders).State = EntityState.Modified;
db.SaveChanges();
}
populateDataGridView_t_Orders();
ClearDataGridView_t_Orders();
MessageBox.Show("Submitted Successfully");
}
/// <summary>
/// measurement unit editng , need double click on datagrid before to poplate text box's
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_U_M_Edit_Click(object sender, EventArgs e)
{
//ItemU_M_Helper um = new ItemU_M_Helper();
//um.editItemU_M(textBox_ItemU_M.Text.Trim(), textBox_ItemU_M, dataGridView_U_M);
model_t_ItemU_M.ItemU_M = textBox_ItemU_M.Text.Trim();
using (testDBEntities db = new testDBEntities())
{
db.Entry(model_t_ItemU_M).State = EntityState.Modified;
db.SaveChanges();
}
ItemU_M_Helper um = new ItemU_M_Helper();
um.ClearDataGridView_t_ItemU_M(textBox_ItemU_M);
um.populateDataGridView_t_ItemU_M(dataGridView_U_M);
//ClearDataGridView_t_ItemU_M();
//populateDataGridView_t_ItemU_M();
MessageBox.Show("Submitted Successfully");
}
/// <summary>
/// evaluting total amount in order after add/del item
/// </summary>
/// <param name="order_id"></param>
private void evalTotalAmount(long order_id)
{
using (testDBEntities db = new testDBEntities())
{
//MessageBox.Show(m_order_item.t_Orders.ID.ToString());
List <OrdersItem> all_OrdersItems = db.OrdersItems.Where(x => x.t_Orders.ID == order_id).ToList <OrdersItem>();
decimal total = 0;
foreach (OrdersItem order_item in all_OrdersItems)
{
total += (decimal)order_item.t_Items.ItemPrice;
}
t_Orders order = db.t_Orders.Where(x => x.ID == order_id).FirstOrDefault();
order.TotalAmount = total;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// delete item from db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonItemsDel_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are You Sure to Delete this Record ?", "EF CRUD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (testDBEntities db = new testDBEntities())
{
var entry = db.Entry(model_t_ItemU_M);
if (entry.State == EntityState.Detached)
{
db.t_Items.Attach(model_t_Items);
}
db.t_Items.Remove(model_t_Items);
db.SaveChanges();
populateDataGridViewItems();
ClearDataGridView_t_Items();
MessageBox.Show("Deleted Successfully");
}
}
}
public void Del_U_M_Record(t_ItemU_M model_t_ItemU_M, TextBox textBox_ItemU_M, DataGridView dataGridView_U_M)
{
if (MessageBox.Show("Are You Sure to Delete this Record ?", "EF CRUD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (testDBEntities db = new testDBEntities())
{
var entry = db.Entry(model_t_ItemU_M);
if (entry.State == EntityState.Detached)
{
db.t_ItemU_M.Attach(model_t_ItemU_M);
}
db.t_ItemU_M.Remove(model_t_ItemU_M);
db.SaveChanges();
ClearDataGridView_t_ItemU_M(textBox_ItemU_M);
populateDataGridView_t_ItemU_M(dataGridView_U_M);
MessageBox.Show("Deleted Successfully");
}
}
}