private void dataGridVendor_MouseDoubleClick(object sender, MouseButtonEventArgs e) { cc.OpenConnection(); try { if (MainWindow.userName == "admin") { if (checkBoxGST.IsChecked == true) { vendorId = ((DataRowView)dataGridVendor.SelectedItem).Row["Vid"].ToString(); if (cc.BillPreview("select Count(*) from TransactionDetails where Vid=@vid and BillType='GST'", "@vid", vendorId, vidExist) > 0) { VendorPurchases vp = new VendorPurchases(); vp.ShowDialog(); } else { MessageBox.Show("Transaction not found"); } } else { vendorId = ((DataRowView)dataGridVendor.SelectedItem).Row["Vid"].ToString(); if (cc.BillPreview("select Count(*) from TransactionDetails where Vid=@vid and BillType='NON_GST'", "@vid", vendorId, vidExist) > 0) { VendorPurchases vp = new VendorPurchases(); vp.ShowDialog(); } else { MessageBox.Show("Transaction not found"); } } } else { vendorId = ((DataRowView)dataGridVendor.SelectedItem).Row["Vid"].ToString(); if (cc.BillPreview("select Count(*) from TransactionDetails where Vid=@vid and BillType='GST'", "@vid", vendorId, vidExist) > 0) { VendorPurchases vp = new VendorPurchases(); vp.ShowDialog(); } else { MessageBox.Show("Transaction not found"); } } } catch (Exception) { MessageBox.Show("Click on the Vendor"); } cc.CloseConnection(); }
private void comboBoxCustomerName_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { comboName = comboBoxCustomerName.SelectedItem.ToString(); customerPhone = Regex.Split(comboName, " "); cc.OpenConnection(); if (MainWindow.userName == "admin") { if (cc.BillPreview("select count(*) from CustomerTransactions where CustomerPhone=@phone", "@phone", customerPhone[1], count) > 0) { calculateBillAmount(); calculateTotalPayment(); calculateSpecialDiscount(); balanceAmount = (billAmount - paymentAmount) - specialDiscount; txtBalance.Text = Convert.ToString(balanceAmount); txtPayment.Text = ""; } else { MessageBox.Show("No transactions with " + comboName); } } else { if (cc.BillPreview("select count(*) from CustomerTransactions where CustomerPhone=@phone and BillType='GST'", "@phone", customerPhone[1], count) > 0) { calculateBillAmount(); calculateTotalPayment(); calculateSpecialDiscount(); balanceAmount = (billAmount - paymentAmount) - specialDiscount; txtBalance.Text = Convert.ToString(balanceAmount); txtPayment.Text = ""; } else { MessageBox.Show("No transactions with " + comboName); } } } catch { comboBoxCustomerName.SelectedItem = null; } cc.CloseConnection(); comboBoxCustomerName.IsDropDownOpen = true; txtPayment.Focus(); }
private void comboBoxVendorName_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { cc.OpenConnection(); if (MainWindow.userName == "admin") { if (cc.BillPreview("select Count(*) from TransactionDetails where Vname=@vname", "@vname", comboBoxVendorName.SelectedItem.ToString(), vidExist) > 0) { calculateBillAmount(); calculateTotalPayment(); balanceAmount = billAmount - paymentAmount; txtBalance.Text = Convert.ToString(balanceAmount); txtPayment.Text = ""; } else { MessageBox.Show("No transaction with " + comboBoxVendorName.SelectedItem.ToString()); } } else { if (cc.BillPreview("select Count(*) from TransactionDetails where Vname=@vname and GstAmount != 0", "@vname", comboBoxVendorName.SelectedItem.ToString(), vidExist) > 0) { calculateBillAmount(); calculateTotalPayment(); balanceAmount = billAmount - paymentAmount; txtBalance.Text = Convert.ToString(balanceAmount); txtPayment.Text = ""; } else { MessageBox.Show("No transaction with " + comboBoxVendorName.SelectedItem.ToString()); } } } catch { comboBoxVendorName.SelectedItem = null; } cc.CloseConnection(); comboBoxVendorName.IsDropDownOpen = true; txtPayment.Focus(); }
private void DamageItemId_PreviewKeyDown(object sender, KeyEventArgs e) { try { if (e.Key == Key.Return) { cc.OpenConnection(); if (cc.BillPreview("select COUNT(*) from Stock where itemid = @value ", "@value", DamageItemId.Text, isExist) > 0) { cc.CloseConnection(); idCount = Convert.ToInt32(DamageItemId.Text); GetFromStock(); if (id.list.Contains(DamageItemId.Text)) { UpdateGridRow(); } else { StoreId(); InsertNewRow(); } DamageItemId.Text = ""; buttonDelete.Visibility = Visibility.Hidden; buttonList.Visibility = Visibility.Visible; buttonSaveDamaged.Visibility = Visibility.Visible; } else { MessageBox.Show("Item does not exist in DB"); DamageItemId.Text = ""; DamageItemId.Focus(); } } } catch (Exception) { if (DamageItemId.Text == "") { MessageBox.Show("Enter Item ID..!"); } } }
private void txtItemId_PreviewKeyDown(object sender, KeyEventArgs e) { try { if (e.Key == Key.Return) { cc.OpenConnection(); if (cc.BillPreview("select COUNT(*) from Stock where itemid = @value ", "@value", txtItemId.Text, isExist) > 0) { cc.CloseConnection(); GetFromStock(); idCount = Convert.ToInt32(txtItemId.Text); if (id.list.Contains(txtItemId.Text)) { UpdateGridRow(); } else { StoreId(); InsertNewRow(); } DisplayNetAmount(); txtItemId.Text = ""; } else { MessageBox.Show("Item does not exist in DB"); txtItemId.Text = ""; txtItemId.Focus(); } } } catch (Exception) { if (txtItemId.Text == "") { MessageBox.Show("Enter Item ID..!"); } } }
private void dataGridVendor_MouseDoubleClick(object sender, MouseButtonEventArgs e) { cc.OpenConnection(); try { expenseId = ((DataRowView)dataGridVendor.SelectedItem).Row["Eid"].ToString(); if (cc.BillPreview("select Count(*) from ExpenseDetails where Eid=@Eid", "@Eid", expenseId, vidExist) > 0) { ExpenseListWindow elp = new ExpenseListWindow(); elp.ShowDialog(); } else { MessageBox.Show("Transaction not found"); } } catch (Exception) { MessageBox.Show("Click on the Vendor"); } cc.CloseConnection(); }
private void viewBill() { if (txtBillNo.Text != null) { if (MainWindow.userName == "admin") { cc.OpenConnection(); string txtbn = Convert.ToString(txtBillNo.Text); if (checkBoxGST.IsChecked == true) { if (cc.BillPreview("select COUNT(*) from BillStock where BillNo = @bno and BillType='GST'", "@bno", txtbn, billExistValue) > 0) { displayDetails(); int bn = Convert.ToInt32(txtBillNo.Text); cc.DataGridDisplay("select ItemNo,Product,Price,ProductQuantity,gstPercent,gstRate,TotalPrice from BillStock where BillNo = " + bn + " and BillType='GST' "); dataGrid1.ItemsSource = cc.dt.AsDataView(); } else { MessageBox.Show("Bill does not exist"); txtBillNo.Text = currentBillNo; txtBillNo.Focus(); } } else { if (cc.BillPreview("select COUNT(*) from BillStock where BillNo = @bno and BillType='NON_GST'", "@bno", txtbn, billExistValue) > 0) { displayDetails(); int bn = Convert.ToInt32(txtBillNo.Text); cc.DataGridDisplay("select ItemNo,Product,Price,ProductQuantity,gstPercent,gstRate,TotalPrice from BillStock where BillNo = " + bn + " and BillType='NON_GST'"); dataGrid1.ItemsSource = cc.dt.AsDataView(); } else { MessageBox.Show("Bill does not exist"); txtBillNo.Text = currentBillNo; txtBillNo.Focus(); } } cc.CloseConnection(); } else { cc.OpenConnection(); string txtbn = Convert.ToString(txtBillNo.Text); if (cc.BillPreview("select COUNT(*) from BillStock where BillNo = @bno and BillType='GST'", "@bno", txtbn, billExistValue) > 0) { displayDetails(); int bn = Convert.ToInt32(txtBillNo.Text); cc.DataGridDisplay("select ItemNo,Product,Price,ProductQuantity,gstPercent,gstRate,TotalPrice from BillStock where BillNo = " + bn + " and BillType='GST' "); dataGrid1.ItemsSource = cc.dt.AsDataView(); } else { MessageBox.Show("Bill does not exist"); txtBillNo.Text = currentBillNo; txtBillNo.Focus(); } cc.CloseConnection(); } } }
private void ViewBill() { if (txt_Bill_No.Text != null) { if (MainWindow.userName == "admin") { if (checkBoxGST.IsChecked == true) { cc.OpenConnection(); string txtbn = Convert.ToString(txt_Bill_No.Text); if (cc.BillPreview("select COUNT(*) from Stock where Bno = @bno and BillType='GST'", "@bno", txtbn, billExistValue) > 0) { displayVendorDetails(); int bn = Convert.ToInt32(txt_Bill_No.Text); cc.DataGridDisplay("select itemid,iname,rate,purchaseQty,total,sprice,gst_percent,gst_amount from Stock where Bno = " + bn + " and BillType='GST'"); dataGridPurchase.ItemsSource = cc.dt.AsDataView(); } else { MessageBox.Show("Bill does not exist"); txt_Bill_No.Text = currentBillNo; txt_Bill_No.Focus(); } cc.CloseConnection(); } else { cc.OpenConnection(); string txtbn = Convert.ToString(txt_Bill_No.Text); if (cc.BillPreview("select COUNT(*) from Stock where Bno = @bno and BillType='NON_GST'", "@bno", txtbn, billExistValue) > 0) { displayVendorDetails(); int bn = Convert.ToInt32(txt_Bill_No.Text); cc.DataGridDisplay("select itemid,iname,rate,purchaseQty,total,sprice,gst_percent,gst_amount from Stock where Bno = " + bn + " and BillType='NON_GST'"); dataGridPurchase.ItemsSource = cc.dt.AsDataView(); } else { MessageBox.Show("Bill does not exist"); txt_Bill_No.Text = currentBillNo; txt_Bill_No.Focus(); } cc.CloseConnection(); } } else { cc.OpenConnection(); string txtbn = Convert.ToString(txt_Bill_No.Text); if (cc.BillPreview("select COUNT(*) from Stock where Bno = @bno and BillType='GST'", "@bno", txtbn, billExistValue) > 0) { displayVendorDetails(); int bn = Convert.ToInt32(txt_Bill_No.Text); cc.DataGridDisplay("select itemid,iname,rate,purchaseQty,total,sprice,gst_percent,gst_amount from Stock where Bno = " + bn + " and BillType='GST'"); dataGridPurchase.ItemsSource = cc.dt.AsDataView(); } else { MessageBox.Show("Bill does not exist"); txt_Bill_No.Text = currentBillNo; txt_Bill_No.Focus(); } cc.CloseConnection(); } } }