private bool IfIdExists(string Item_Name, string Item_Id)
{
con2.dataGet2("select 1 from [dbo].[Stock] where Item_Name='" + textBox2.Text + "'and Item_Id='" + textBox1.Text + "'");
DataTable dt = new DataTable();
con2.sda2.Fill(dt);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public void disp_data()
{
try
{
con2.dataGet2("select * from [dbo].[Billing_Details]");
DataTable dt = new DataTable();
con2.sda2.Fill(dt);
dataGridView1.Rows.Clear();
foreach (DataRow row in dt.Rows)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells["Customer_Name"].Value = row["Customer_Name"].ToString();
dataGridView1.Rows[n].Cells["Date"].Value = Convert.ToDateTime(row["Date"].ToString()).ToString("dd-MM-yyyy");
dataGridView1.Rows[n].Cells["Sub_Total"].Value = row["Sub_Total"].ToString();
dataGridView1.Rows[n].Cells["Discount"].Value = row["Discount"].ToString();
dataGridView1.Rows[n].Cells["Net_Total"].Value = row["Net_Total"].ToString();
dataGridView1.Rows[n].Cells["Paid"].Value = row["Paid"].ToString();
dataGridView1.Rows[n].Cells["Balance"].Value = row["Balance"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Bill_Output_Page_Load_1(object sender, EventArgs e)
{
try
{
crypt.Load(@"C:\Users\Prageeth Thilina\source\repos\Group Project\Group Project\Bill_Report.rpt");
Connection2 con2 = new Connection2();
DataSet dst = new DataSet();
con2.dataGet2("select top 1 Customer_Name,Date,Sub_Total,Discount,Net_Total,Paid,Balance from Billing_Details order by Date desc");
con2.sda2.Fill(dst, "Billing_Details");
crypt.SetDataSource(dst);
crystalReportViewer1.ReportSource = crypt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void disp_data()
{
try
{
con2.dataGet2("select * from [dbo].[SupDetails]");
DataTable dt = new DataTable();
con2.sda2.Fill(dt);
SupDetailGrid.Rows.Clear();
foreach (DataRow row in dt.Rows)
{
int n = SupDetailGrid.Rows.Add();
SupDetailGrid.Rows[n].Cells["SupID"].Value = row["SupID"].ToString();
SupDetailGrid.Rows[n].Cells["SupName"].Value = row["SupName"].ToString();
SupDetailGrid.Rows[n].Cells["SupConNum"].Value = row["SupNum"].ToString();
SupDetailGrid.Rows[n].Cells["SupAdd"].Value = row["SupAdd"].ToString();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}