/// <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();
}
}
/// <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>
/// desc ordering of measurement unit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_U_M_Desc_Click(object sender, EventArgs e)
{
using (testDBEntities db = new testDBEntities())
{
dataGridView_U_M.DataSource = db.t_ItemU_M.OrderByDescending(x => x.ItemU_M).ToList <t_ItemU_M>();
}
}
/// <summary>
/// Items Desc by combo box value
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonItemsDesc_Click(object sender, EventArgs e)
{
// model_t_Items.ItemPrice
using (testDBEntities db = new testDBEntities())
{
if (comboBoxItemsSorting.Text == "Items ID")
{
dataGridViewItems.DataSource = db.t_Items.OrderByDescending(x => x.ItemID).ToList <t_Items>();
}
else if (comboBoxItemsSorting.Text == "Item Amount")
{
dataGridViewItems.DataSource = db.t_Items.OrderByDescending(x => x.ItemAmount).ToList <t_Items>();
}
else if (comboBoxItemsSorting.Text == "Unit")
{
dataGridViewItems.DataSource = db.t_Items.OrderByDescending(x => x.ItemU_M).ToList <t_Items>();
}
else if (comboBoxItemsSorting.Text == "Item Description")
{
dataGridViewItems.DataSource = db.t_Items.OrderByDescending(x => x.ItemDescription).ToList <t_Items>();
}
else
{
MessageBox.Show("choose Column to filter");
}
}
}
/// <summary>
/// search measurement unit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_U_M_Search_Click(object sender, EventArgs e)
{
using (testDBEntities db = new testDBEntities())
{
dataGridView_U_M.DataSource = db.t_ItemU_M.Where(x => x.ItemU_M.Contains(textBox_ItemU_M.Text)).ToList <t_ItemU_M>();
}
}
/// <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>
/// order search by diffrents fields
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOrdersSearch_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(textBoxRefaundAmount.Text))
{
model_t_Orders.RefaundAmount = Convert.ToDecimal(textBoxRefaundAmount.Text.Trim());
}
if (!String.IsNullOrEmpty(textBoxOrdersToatl.Text))
{
model_t_Orders.TotalAmount = Convert.ToDecimal(textBoxOrdersToatl.Text.Trim());
}
using (testDBEntities db = new testDBEntities())
{
//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.CustomerCity = textBoxOrdersCustomerCity.Text.Trim();
dataGridViewItems.DataSource = db.t_Orders
.Where(x => x.CustomerName.Contains(model_t_Orders.CustomerName) || x.CustomerAddress.Contains(textBoxOrdersCust_Adress.Text.Trim()) ||
(x.CustomerPhone.Contains(textBoxCustomerPhone.Text.Trim())) || (x.TotalAmount == model_t_Orders.TotalAmount) ||
(x.RefaundAmount == model_t_Orders.RefaundAmount) || x.CustomerCity.Contains(model_t_Orders.CustomerCity)
).ToList <t_Orders>();
}
}
public void populateDataGridView_t_ItemU_M(DataGridView dataGridView_U_M)
{
using (testDBEntities db = new testDBEntities())
{
//SortableBindingList<t_ItemU_M> va = db.t_ItemU_M.ToList<t_ItemU_M>();
dataGridView_U_M.DataSource = db.t_ItemU_M.ToList <t_ItemU_M>();
}
}
/// <summary>
/// asc ordering of measurement unit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_U_M_Asc_Click(object sender, EventArgs e)
{
//dv= "ID desc";
//dataGridView_U_M.Sort(dataGridView_U_M.Columns[1], ListSortDirection.Ascending); putting error - why????
using (testDBEntities db = new testDBEntities())
{
dataGridView_U_M.DataSource = db.t_ItemU_M.OrderBy(x => x.ItemU_M).ToList <t_ItemU_M>();
}
}
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>
/// inserting values to textbox by clicking on datagris
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridView_U_M_DoubleClick(object sender, EventArgs e)
// poplate text box when data grid being pressed
{
if (dataGridView_U_M.CurrentRow.Index != -1)
{
model_t_ItemU_M.ID = Convert.ToInt32(dataGridView_U_M.CurrentRow.Cells["M_U_ID"].Value);
using (testDBEntities db = new testDBEntities())
{
model_t_ItemU_M = db.t_ItemU_M.Where(x => x.ID == model_t_ItemU_M.ID).FirstOrDefault();
textBox_ItemU_M.Text = model_t_ItemU_M.ItemU_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>
/// insering value to textbos depending on double click on datagrid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridViewItems_DoubleClick(object sender, EventArgs e)
// poplate text box when data grid being pressed
{
if (dataGridViewItems.CurrentRow.Index != -1)
{
model_t_Items.ID = Convert.ToInt32(dataGridViewItems.CurrentRow.Cells["ID"].Value);
using (testDBEntities db = new testDBEntities())
{
model_t_Items = db.t_Items.Where(x => x.ID == model_t_Items.ID).FirstOrDefault();
textBoxItemsAmount.Text = model_t_Items.ItemAmount.ToString();
textBoxItemsPrice.Text = model_t_Items.ItemPrice.ToString();
comboBoxMeasuremntUnit.Text = model_t_Items.ItemU_M.ToString();
richTextBoxItemsDesc.Text = model_t_Items.ItemDescription.ToString();
}
}
}
/// <summary>
/// desc order by combobox value
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonOrderDesc_Click(object sender, EventArgs e)
{
using (testDBEntities db = new testDBEntities())
{
if (comboBoxOrdersSorting.Text == "Order Date")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.OrderDate).ToList <t_Orders>();
}
else if (comboBoxOrdersSorting.Text == "Customer Name")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.CustomerName).ToList <t_Orders>();
}
else if (comboBoxOrdersSorting.Text == "Customer Adress")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.CustomerAddress).ToList <t_Orders>();
}
else if (comboBoxOrdersSorting.Text == "Customer Phone")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.CustomerPhone).ToList <t_Orders>();
}
else if (comboBoxOrdersSorting.Text == "Total Amount")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.TotalAmount).ToList <t_Orders>();
}
else if (comboBoxOrdersSorting.Text == "Refaund Amount")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.RefaundAmount).ToList <t_Orders>();
}
else if (comboBoxOrdersSorting.Text == "Customer City")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.CustomerCity).ToList <t_Orders>();
}
else if (comboBoxOrdersSorting.Text == "Order Number")
{
dataGridViewOrders.DataSource = db.t_Orders.OrderByDescending(x => x.OrderNumber).ToList <t_Orders>();
}
else
{
MessageBox.Show("choose Column to filter");
}
}
}
/// <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");
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////
// items functions
////////////////////////////////////////////////////////////////////////////////////////////////////////////
void populateDataGridViewItems()
{
using (testDBEntities db = new testDBEntities())
{
//SortableBindingList<t_ItemU_M> va = db.t_ItemU_M.ToList<t_ItemU_M>();
dataGridViewItems.DataSource = db.t_Items.ToList <t_Items>();
List <t_ItemU_M> items_u_m = db.t_ItemU_M.ToList <t_ItemU_M>();
comboBoxMeasuremntUnit.DataSource = items_u_m;
comboBoxMeasuremntUnit.ValueMember = "ID";
comboBoxMeasuremntUnit.DisplayMember = "ItemU_M";
comboBoxItemsSorting.Items.Add("Items ID");
comboBoxItemsSorting.Items.Add("Item Amount");
comboBoxItemsSorting.Items.Add("Unit");
comboBoxItemsSorting.Items.Add("Item Description");
}
}
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");
}
}
}
/// <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");
}
}
}
/// <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>
/// search for items by diffrent fields depend on combobox val
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonItemsSearch_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(textBoxItemsAmount.Text))
{
model_t_Items.ItemAmount = Convert.ToDecimal(textBoxItemsAmount.Text.Trim());
}
if (!String.IsNullOrEmpty(textBoxItemsPrice.Text))
{
model_t_Items.ItemPrice = Convert.ToDecimal(textBoxItemsPrice.Text.Trim());
}
using (testDBEntities db = new testDBEntities())
{
dataGridViewItems.DataSource = db.t_Items
.Where(x => x.ItemAmount == model_t_Items.ItemAmount || x.ItemDescription.Contains(richTextBoxItemsDesc.Text.Trim()) ||
x.ItemPrice == model_t_Items.ItemPrice || x.ItemU_M.Equals(comboBoxMeasuremntUnit.Text.Trim()))
.ToList <t_Items>();
}
}
/// <summary>
/// insert data to textbox's by clicking on row of datagridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridViewOrders_DoubleClick(object sender, EventArgs e)
{
if (dataGridViewOrders.CurrentRow.Index != -1)
{
model_t_Orders.ID = Convert.ToInt32(dataGridViewOrders.CurrentRow.Cells["_ID"].Value);
using (testDBEntities db = new testDBEntities())
{
model_t_Orders = db.t_Orders.Where(x => x.ID == model_t_Orders.ID).FirstOrDefault();
textBoxRefaundAmount.Text = model_t_Orders.RefaundAmount.ToString();
textBoxOrders_CustName.Text = model_t_Orders.CustomerName;
textBoxOrdersCust_Adress.Text = model_t_Orders.CustomerAddress;
textBoxCustomerPhone.Text = model_t_Orders.CustomerPhone;
textBoxOrdersToatl.Text = model_t_Orders.TotalAmount.ToString();
dateTimePickerOrders.Text = model_t_Orders.OrderDate.ToString();
textBoxOrdersCustomerCity.Text = model_t_Orders.CustomerCity;
textBoxOrderNumberInOrderTab.Text = model_t_Orders.OrderNumber;
}
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////
// orders functions
///////////////////////////////////////////////////////////////////////////////////////////////////////////
void populateDataGridView_t_Orders()
{
using (testDBEntities db = new testDBEntities())
{
//SortableBindingList<t_ItemU_M> va = db.t_ItemU_M.ToList<t_ItemU_M>();
dataGridViewOrders.DataSource = db.t_Orders.ToList <t_Orders>();
comboBoxOrdersSorting.Items.Clear();
comboBoxOrdersSorting.Items.Add("Order Number");
comboBoxOrdersSorting.Items.Add("Customer Name");
comboBoxOrdersSorting.Items.Add("Customer Phone");
comboBoxOrdersSorting.Items.Add("Total Amount");
comboBoxOrdersSorting.Items.Add("Refaund Amount");
comboBoxOrdersSorting.Items.Add("Customer City");
comboBoxOrdersSorting.Items.Add("Customer Adress");
comboBoxOrdersSorting.Items.Add("Order Date");
comboBoxOrderItemsInAddOrderTab.Items.Clear();
List <t_Items> all_t_Items = db.t_Items.ToList <t_Items>();
foreach (t_Items item in all_t_Items)
{
comboBoxOrderItemsInAddOrderTab.Items.Add(item.ItemDescription.Trim());
}
comboBoxOrderitemsInListDel.Items.Clear();
List <OrdersItem> all_OrdersItems = db.OrdersItems.ToList <OrdersItem>();
foreach (OrdersItem order_item in all_OrdersItems)
{
comboBoxOrderitemsInListDel.Items.Add(order_item.t_Items.ItemDescription.Trim());
}
}
}
