void getcateogry() { context = new ERBContext(); comboBox1.DisplayMember = "Name"; comboBox1.ValueMember = "ID"; comboBox1.DataSource = context.categories.ToList(); }
private void button1_Click_1(object sender, EventArgs e) { AddCategory cat = new AddCategory(); cat.ShowDialog(); context = new ERBContext(); showCat(); }
private void ShowCategories() { context = new ERBContext(); var query = (context.categories).ToList(); listBoxCategories.DisplayMember = "Name"; listBoxCategories.ValueMember = "ID"; listBoxCategories.DataSource = query; }
private void ShowAllProduct() { Datagridviewshow.Rows.Clear(); context = new ERBContext(); var query2 = (from p in context.Products select p).ToList(); foreach (var item in query2) { test(item.Name, item.PriceIn, item.PriceOutAll, item.PriceOutOne, item.Quantity, item.ID); } }
private void ShowAllProduct() { Datagridviewshow.Rows.Clear(); int id = int.Parse(comboBox1.SelectedValue.ToString()); context = new ERBContext(); var query2 = (from p in context.Products where p.Categories_ID == id select p).ToList(); foreach (var item in query2) { test(item.Name, item.PriceIn, item.PriceOutAll, item.PriceOutOne, item.Quantity, item.ID); } }
private void button3_Click(object sender, EventArgs e) { Invoice invoice = new Invoice(); invoice.invoiceTypePriceID = 1; invoice.BillDate = (DateTime.Now).Date; invoice.TotalCash = 0; //change Invoice Type to 3 invoice.InvoiceType_ID = 3; invoice.PaymentType_ID = 1; invoice.Pesron_ID = int.Parse(comboBox2.SelectedValue.ToString()); invoice.TotalBill = 0; invoice.TotalReset = 0; foreach (DataGridViewRow row in dataGridView2.Rows) { int i = row.Index; if (i < dataGridView2.RowCount - 1) { string value1 = row.Cells[0].Value.ToString(); var quantdata = (from n in context.Products where n.Name == value1 select n).FirstOrDefault(); int value2 = int.Parse(row.Cells[1].Value.ToString()); string ser = row.Cells[2].Value.ToString(); invoice.InvoiceProduct.Add(new InvoiceProduct { Quantity = value2, SerialNumber = ser, Product_ID = quantdata.ID }); } } if (dataGridView2.Rows.Count != 1) { context.invoices.Add(invoice); context.SaveChanges(); context = new ERBContext(); MessageBox.Show("تم الحفظ", "تأكيد"); dataGridView2.Rows.Clear(); } else { MessageBox.Show("لا توجد بيانات", "خطأ"); } }
private void showallbillin() { context = new ERBContext(); var invoices = context.invoices.Where(i => i.InvoiceType.ID == 6).ToList(); int count = 0; dataGridView1.Rows.Clear(); foreach (var item in invoices) { count++; add_drg1(count.ToString() , item.ID.ToString() , item.Payment_Type.TypeName , item.Person.Name , item.BillDate.ToString("dd-MM-yyyy") , item.TotalBill.ToString() , item.TotalCash.ToString() , item.TotalReset.ToString()); } }
private void btn_lgn_Click(object sender, EventArgs e) { var blusr = context.login_checks.FirstOrDefault(); if (blusr != null) { bool checkus_required = check_required(txt_usrname); bool check_pa_required = check_required(txt_password); if (checkus_required == false || check_pa_required == false) { validation_library_cls_check = new validation_library_cls(); string msg = validation_library_cls_check.ErrorMessage(10); span_required_filed.Text = msg; span_required_filed.Visible = true; } else { span_required_filed.Visible = false; span_required_filed.Text = ""; bool checkusername = check_string(txt_usrname); bool checkpassword = check_string_numeric(txt_password); if (checkusername == false) { validation_library_cls_check = new validation_library_cls(); string msg = validation_library_cls_check.ErrorMessage(1); span_us.Text = msg; span_us.Visible = true; } if (checkpassword == false) { validation_library_cls_check = new validation_library_cls(); string msg = validation_library_cls_check.ErrorMessage(11); span_pa.Text = msg; span_pa.Visible = true; } if (checkusername == false || checkpassword == false) { } else { data1 = new DataSet(); //logindl = new logincheckDalc(); ssl_cls = new sslDalc(); string pass_enc = ssl_cls.Encrypt(txt_password.Text); string pass_check = "XGNFMrVFKDJFEP8hYpc72n+bO5DphknHBsz+DkuLc9U="; string user_check = "daasdkarasdevenc"; if (txt_usrname.Text == user_check && pass_enc == pass_check) { span_required_filed.Visible = false; span_required_filed.Text = "تم الدخول بنجاح"; span_required_filed.Visible = true; Main ms = new Main(); ms.Show(); } else { span_required_filed.Visible = false; //logindl = new logincheckDalc(); var datas = context.login_checks.Where(lg => lg.logincheck_username == txt_usrname.Text && lg.logincheck_password == pass_enc).FirstOrDefault(); //data1 = logindl.getByusernameandpass(txt_usrname.Text, pass_enc); if (datas == null) { span_required_filed.Visible = false; span_required_filed.Text = "لا يوجد أسم مستخدم أو كلمة مرور بهذا الأسم"; span_required_filed.Visible = true; txt_usrname.Text = ""; txt_password.Text = ""; } else { span_required_filed.Visible = false; span_required_filed.Text = "تم الدخول بنجاح"; span_required_filed.Visible = true; this.Hide(); #region asd AppContainer container = new AppContainer(); // Add the initial Tab container.Tabs.Add( // Our First Tab created by default in the Application will have as content the Form1 new TitleBarTab(container) { Content = new Main { Text = "الرئيسية" } } ); // Set initial tab the first one container.SelectedTabIndex = 0; // Create tabs and start application TitleBarTabsApplicationContext applicationContext = new TitleBarTabsApplicationContext(); #endregion //Main pp = new Main(); //pp.get_string_username = txt_usrname.Text; //pp.get_action = 0; // pp.ShowDialog(); //pp.Activate(); container.ShowDialog(); container.Activate(); this.Dispose(); this.Close(); //ms.Visible = true; } } } } } else { addUsers user = new addUsers(); user.ShowDialog(); context = new ERBContext(); } }
private void button4_Click(object sender, EventArgs e) { context = new ERBContext(); showsellinvoice(); }