/// <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();
}
}
/// <summary>
/// check if entering value is float
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void textBoxItemsPrice_TextChanged(object sender, EventArgs e)
// check if text box is float
{
MDSHelperClass.MdsAppisFloat(textBoxItemsPrice);
}
/// <summary>
/// check if entering value is float
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void textBoxItemsAmount_TextChanged(object sender, EventArgs e)
// check if text box is digit
{
//MDSHelperClass.MdsAppisDigit(textBoxItemsAmount);
MDSHelperClass.MdsAppisFloat(textBoxItemsPrice);
}
