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();
}
