private void displayVendorDetails() { cc.OpenConnection(); int tbn = Convert.ToInt32(txt_Bill_No.Text); if (MainWindow.userName == "admin") { if (checkBoxGST.IsChecked == true) { cc.CreateView("CREATE VIEW DisplayVendor AS Select Stock.Bno,Stock.gtotal,TransactionDetails.Vid,TransactionDetails.Vname,TransactionDetails.Vphone,TransactionDetails.Vplace,FORMAT(TransactionDetails.PurchaseDate,'dd-MMM-yyyy') as PDate from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno and Stock.BillType='GST' and TransactionDetails.BillType='GST'"); } else { cc.CreateView("CREATE VIEW DisplayVendor AS Select Stock.Bno,Stock.gtotal,TransactionDetails.Vid,TransactionDetails.Vname,TransactionDetails.Vphone,TransactionDetails.Vplace,FORMAT(TransactionDetails.PurchaseDate,'dd-MMM-yyyy') as PDate from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno and Stock.BillType='NON_GST' and TransactionDetails.BillType='NON_GST'"); } } else { cc.CreateView("CREATE VIEW DisplayVendor AS Select Stock.Bno,Stock.gtotal,TransactionDetails.Vid,TransactionDetails.Vname,TransactionDetails.Vphone,TransactionDetails.Vplace,FORMAT(TransactionDetails.PurchaseDate,'dd-MMM-yyyy') as PDate from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno and Stock.BillType='GST' and TransactionDetails.BillType='GST'"); } cc.DataReader("Select * from DisplayVendor where Bno=" + tbn + ""); while (cc.reader.Read()) { txt_Net_Amount.Text = cc.reader["gtotal"].ToString(); txt_Vendor_Id.Text = cc.reader["Vid"].ToString(); txt_Vendor_Name.Text = cc.reader["Vname"].ToString(); txt_Vendor_Place.Text = cc.reader["Vplace"].ToString(); txt_Vendor_Phone.Text = cc.reader["Vphone"].ToString(); txt_Purchase_Date.Text = cc.reader["PDate"].ToString(); } cc.CloseReader(); cc.DropView("DROP VIEW DisplayVendor"); cc.CloseConnection(); }
private void ShowDetails() { cc.OpenConnection(); if (MainWindow.userName == "admin") { if (MainWindow.isgst == 1) { cc.CreateView("CREATE VIEW PurchaseBill AS Select Distinct Stock.Bno,Stock.gtotal,FORMAT(TransactionDetails.PurchaseDate,'dd-MMM-yyyy') as PDate,TransactionDetails.CreditAmount,TransactionDetails.PaymentType,TransactionDetails.GstAmount from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno and Stock.BillType='GST' and TransactionDetails.BillType='GST'"); } else { cc.CreateView("CREATE VIEW PurchaseBill AS Select Distinct Stock.Bno,Stock.gtotal,FORMAT(TransactionDetails.PurchaseDate,'dd-MMM-yyyy') as PDate,TransactionDetails.CreditAmount,TransactionDetails.PaymentType,TransactionDetails.GstAmount from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno and Stock.BillType='NON_GST' and TransactionDetails.BillType='NON_GST'"); } } else { cc.CreateView("CREATE VIEW PurchaseBill AS Select Distinct Stock.Bno,Stock.gtotal,FORMAT(TransactionDetails.PurchaseDate,'dd-MMM-yyyy') as PDate,TransactionDetails.CreditAmount,TransactionDetails.PaymentType,TransactionDetails.GstAmount from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno and Stock.BillType='GST' and TransactionDetails.BillType='GST'"); } cc.DataReader("select * from PurchaseBill where Bno = " + billNumber + ""); while (cc.reader.Read()) { txt_Bill_Number.Text = cc.reader["Bno"].ToString(); txt_Sale_Date.Text = cc.reader["PDate"].ToString(); txt_Grant_Total.Text = "₹ " + cc.reader["gtotal"].ToString(); textBox_Credit.Text = cc.reader["CreditAmount"].ToString(); txt_Payment_Type.Text = cc.reader["PaymentType"].ToString(); } cc.CloseReader(); cc.DropView("DROP VIEW PurchaseBill"); cc.CloseConnection(); }
public PurchasedVendor(string selectedName) { InitializeComponent(); VnameCombo = selectedName; LoadVendor(); cc.OpenConnection(); cc.CreateView("CREATE VIEW PurchasedVendor AS Select Stock.iname,Stock.rate,Stock.quantity,Stock.total,Stock.gtotal,TransactionDetails.Vname,TransactionDetails.PurchaseDate from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno"); //cc.DataGridDisplay("select iname,rate,quantity,total,gtotal,PurchaseDate from Stock where Vname='"+VnameCombo+"'"); cc.DataGridDisplay("Select * from PurchasedVendor where Vname='" + VnameCombo + "'"); dataGridPurchasedVendor.ItemsSource = cc.dt.AsDataView(); dataGridPurchasedVendor.Visibility = System.Windows.Visibility.Visible; cc.DropView("DROP VIEW PurchasedVendor"); cc.CloseConnection(); }
private void GetFromStock() { cc.OpenConnection(); cc.CreateView("CREATE VIEW DamagedItems AS Select Stock.itemid,Stock.iname,Stock.rate,TransactionDetails.Vid,TransactionDetails.Vname,TransactionDetails.Vphone from Stock,TransactionDetails where Stock.Bno=TransactionDetails.Bno"); cc.DataReader("select * from DamagedItems where itemid=" + DamageItemId.Text + ""); while (cc.reader.Read()) { DItemNo = cc.reader["itemid"].ToString(); DName = cc.reader["iname"].ToString(); DRate = cc.reader["rate"].ToString(); DVid = cc.reader["Vid"].ToString(); DVname = cc.reader["Vname"].ToString(); DVphone = cc.reader["Vphone"].ToString(); } cc.CloseReader(); cc.DropView("DROP VIEW DamagedItems"); cc.CloseConnection(); }