/// <summary>
/// adding item to order
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOrderItemsInOrderTab_Click(object sender, EventArgs e)
{
if (textBoxOrderNumberInOrderTab.Text == "" || !(comboBoxOrderItemsInAddOrderTab.SelectedIndex > -1))
{
MessageBox.Show("please enter value by double click on the order \n Or choosing product");
}
else
{
using (testDBEntities db = new testDBEntities())
{
t_Items item = db.t_Items.Where(x => x.ItemDescription.Equals(comboBoxOrderItemsInAddOrderTab.Text)).FirstOrDefault();
model_OrdersItem.t_Items = item;
t_Orders order = db.t_Orders.Where(x => x.ID == model_t_Orders.ID).FirstOrDefault();
long order_id = order.ID;
model_OrdersItem.t_Orders = order;
db.OrdersItems.Add(model_OrdersItem);
db.SaveChanges();
evalTotalAmount(order_id);
ClearDataGridView_t_Orders();
populateDataGridView_t_Orders();
MessageBox.Show("Added Successfully");
}
}
}
/// <summary>
/// del item from order
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOrderitemsInListDel_Click(object sender, EventArgs e)
{
if (textBoxOrderNumberInOrderTab.Text == "" || !(comboBoxOrderitemsInListDel.SelectedIndex > -1))
{
MessageBox.Show("please enter value by double click on the order \n Or choosing product");
//dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.OrderDate).ToList<t_Orders>();
}
else
{
using (testDBEntities db = new testDBEntities())
{
model_OrdersItem = db.OrdersItems.Where(x => x.t_Items.ItemDescription.Equals(comboBoxOrderitemsInListDel.Text)).FirstOrDefault();
long order_id = model_OrdersItem.t_Orders.ID;
var entry = db.Entry(model_OrdersItem);
if (entry.State == EntityState.Detached)
{
db.OrdersItems.Attach(model_OrdersItem);
}
db.OrdersItems.Remove(model_OrdersItem);
db.SaveChanges();
evalTotalAmount(order_id);
ClearDataGridView_t_Orders();
populateDataGridView_t_Orders();
MessageBox.Show("Deleted Successfully");
}
}
}
/// <summary>
/// saving new order
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOrdersAdd_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 = 0; //Convert.ToDecimal(textBoxOrdersToatl.Text.Trim());
model_t_Orders.RefaundAmount = Convert.ToDecimal(textBoxRefaundAmount.Text.Trim());
model_t_Orders.CustomerCity = textBoxOrdersCustomerCity.Text.Trim();
long r = MDSHelperClass.LongRandom(10, 100000000000000050, new Random());
//MessageBox.Show(textBoxOrdersCustomerCity.Text.Trim());
model_t_Orders.OrderNumber = r.ToString();; /// Convert.ToInt64(guid.ToString());
//MessageBox.Show(model_t_Orders.OrderNumber.ToString());
using (testDBEntities db = new testDBEntities())
{
db.t_Orders.Add(model_t_Orders);
//MessageBox.Show(db.GetValidationErrors().ToString());
//db.GetValidationErrors();
//db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [test].[dbo].[t_Orders] ON");
db.SaveChanges();
ClearDataGridView_t_Orders();
populateDataGridView_t_Orders();
}
}
/// <summary>
/// adding item to items table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonItemsAdd_Click(object sender, EventArgs e)
{
model_t_Items.ItemAmount = Convert.ToDecimal(textBoxItemsAmount.Text.Trim());
model_t_Items.ItemPrice = (decimal?)Convert.ToDouble(textBoxItemsPrice.Text.Trim());
model_t_Items.ItemU_M = comboBoxMeasuremntUnit.Text.Trim();
model_t_Items.ItemDescription = richTextBoxItemsDesc.Text.Trim();
long r = MDSHelperClass.LongRandom(10, 100000000000000050, new Random());
//MessageBox.Show(guid);
//DbSet
//DbSet dbs = (DbSet)model_t_Items;
DbHelper dbh = new DbHelper();
dbh.insertToDb();
model_t_Items.ItemID = r;; /// Convert.ToInt64(guid.ToString());
MessageBox.Show(model_t_Items.ItemID.ToString());
using (testDBEntities db = new testDBEntities())
{
db.t_Items.Add(model_t_Items);
db.SaveChanges();
ClearDataGridView_t_Items();
populateDataGridViewItems();
}
}
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");
}
t_ItemU_M model_t_ItemU_M = new t_ItemU_M(); // Kg, gram, etc ..
public void addItemU_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.t_ItemU_M.Add(model_t_ItemU_M);
db.SaveChanges();
ClearDataGridView_t_ItemU_M(textBox_ItemU_M);
populateDataGridView_t_ItemU_M(dataGridView_U_M);
}
}
/// <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");
}
}
}
