private void companyProfile()
{
try
{
string sql = "select ID,CName,CAddress,COwner,CMobile,CPhone,CEmail,CWebsite from Company";
// if (con.State != ConnectionState.Open)
SqlConnection connection = ConnectDB.GetSqlConnection();
SqlCommand cmd = new SqlCommand(sql, connection);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
SI.Text = reader[0].ToString();
txtName.Text = reader[1].ToString();
txtCompanyAddress.Text = reader[2].ToString();
txtOwner.Text = reader[3].ToString();
txtMobile.Text = reader[4].ToString();
txtPhone.Text = reader[5].ToString();
txtEmail.Text = reader[6].ToString();
txtWebsite.Text = reader[7].ToString();
}
else
{
MessageBox.Show("No accounted created earlier. Please make your profile");
}
}
catch
{
MessageBox.Show("You have no conpany profile. Please insert your company profile");
// txtCompanyName.Focus();
}
}
private void cmbGroups_SelectedValueChanged(object sender, EventArgs e)
{
SqlDataReader myreader = null;
SqlConnection sqlConn = null;
cmbName.Text = "";
cmbName.Items.Clear();
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select distinct Ledgers from Ledgers where Groups like N'" + cmbGroups.Text + "'";
SqlCommand comm = new SqlCommand(query, conn);
myreader = comm.ExecuteReader();
if (myreader != null)
{
while (myreader.Read())
{
cmbName.Items.Add(myreader["Ledgers"]);
}
}
{
if (myreader != null)
{
myreader.Close();
}
if (sqlConn != null)
{
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are You Sure Want To Delete ?", "Some Title", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
if (txtName.Text != "")
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "DELETE Authenticat where ID='" + txtSI.Text + "' ";
SqlCommand command = new SqlCommand(query, conn);
if (command.ExecuteNonQuery() > 0)
{
MessageBox.Show("User Deleted Successfully !!");
RESET();
btnUpdate.Enabled = false;
btnDelete.Enabled = false;
btnSave.Enabled = true;
}
}
else
{
MessageBox.Show("Check Required Field !!");
}
}
}
private void MainForm_Load(object sender, EventArgs e)
{
string sql = "select CName,CAddress,COwner,CMobile,CEmail from Company";
// if (con.State != ConnectionState.Open)
SqlConnection connection = ConnectDB.GetSqlConnection();
SqlCommand cmd = new SqlCommand(sql, connection);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
//SI.Text = reader[0].ToString();
label5.Text = reader[0].ToString();
label7.Text = reader[1].ToString();
label8.Text = reader[2].ToString();
label9.Text = reader[3].ToString();
// txtPhone.Text = reader[5].ToString();
label10.Text = reader[4].ToString();
// txtWebsite.Text = reader[7].ToString();
}
else
{
MessageBox.Show("No accounted created earlier. Please make your profile");
}
}
private void Group()
{
SqlDataReader myreader = null;
SqlConnection sqlConn = null;
cmbGroups.Text = "";
cmbGroups.Items.Clear();
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select distinct Groups from Groups";
SqlCommand comm = new SqlCommand(query, conn);
myreader = comm.ExecuteReader();
if (myreader != null)
{
while (myreader.Read())
{
cmbGroups.Items.Add(myreader["Groups"]);
}
}
{
if (myreader != null)
{
myreader.Close();
}
if (sqlConn != null)
{
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
}
}
public SqlDataReader search_Total_Balance(string name)
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query1 = "select LNo,Address,Mobile from Ledgers where Ledgers ='" + name + "'";
SqlCommand comm = new SqlCommand(query1, conn);
SqlDataReader reader = comm.ExecuteReader();
return(reader);
}
public SqlDataReader SearchData_Buyers_suppliers_Note_Sl(string name)
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select Address,Mobile from Ledgers where Name ='" + name + "'";
SqlCommand comm = new SqlCommand(query, conn);
SqlDataReader reader = comm.ExecuteReader();
return(reader);
}
public SqlDataReader Search_User_Password_LogIn(string uid)
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select UPassword from Authenticat where UName=N'" + uid + "'";
SqlCommand comm = new SqlCommand(query, conn);
SqlDataReader reader = comm.ExecuteReader();
return(reader);
}
public SqlDataReader SearchData_Area_Info_Name(string sl)
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select ID from Groups where ID='" + sl + "'";
SqlCommand comm = new SqlCommand(query, conn);
SqlDataReader reader = comm.ExecuteReader();
return(reader);
}
private void btnSearch_Click(object sender, EventArgs e)
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select * from Authenticat ";
SqlDataAdapter ad = new SqlDataAdapter(query, conn);
DataTable dt = new DataTable();
ad.Fill(dt);
dataGridView1.DataSource = dt;
}
private void btnSearch_Click(object sender, EventArgs e)
{
SqlConnection connection = ConnectDB.GetSqlConnection();
string query = "select * from Unit where Unit like '" + cmbUnit.Text + "'";
SqlDataAdapter ad = new SqlDataAdapter(query, connection);
DataTable dt = new DataTable();
ad.Fill(dt);
dataGridView1.DataSource = dt;
}
private void cmbGroups_KeyUp(object sender, KeyEventArgs e)
{
if (radioname.Checked == true)
{
SqlConnection connection = ConnectDB.GetSqlConnection();
string query = "select INo,Item from Items where Item like '" + cmbGroups.Text + "'";
SqlDataAdapter ad = new SqlDataAdapter(query, connection);
DataTable dt = new DataTable();
ad.Fill(dt);
dataGridView1.DataSource = dt;
}
}
private void cmbName_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataReader myreader = null;
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select Address from Ledgers where Ledgers ='" + cmbName.Text + "'";
SqlCommand comm = new SqlCommand(query, conn);
myreader = comm.ExecuteReader();
while (myreader.Read())
{
txtA.Text = myreader.GetString(0).ToString();
//txtM.Text = myreader.GetString(1).ToString();
}
}
public SqlDataReader Select_Credit_Debit_transaction(string name)
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query1 = "select SUM(a.Credit) as Total_Credit,SUM(a.Debit) as Total_Debit,SUM(a.Credit) -SUM(a.Debit) as Balance from Ledgers L inner join Accounts a ON a.Ledgers_ID = L.LNo where a.Ledgers_ID ='" + name + "' ";
SqlCommand comm = new SqlCommand(query1, conn);
SqlDataReader reader = comm.ExecuteReader();
return(reader);
//SqlConnection conn = ConnectDB.GetSqlConnection();
//string query = "select SUM(a.Credit) as Total_Credit,SUM(a.Debit) as Total_Debit,SUM(a.Credit) -SUM(a.Debit) as Balance from Ledgers L inner join Accounts a ON a.Ledgers_ID = L.LNo where a.Ledgers_ID ='" + name + "' ";
////SqlDataAdapter ad = new SqlDataAdapter(query, conn);
////DataTable dt = new DataTable();
////ad.Fill(dt);
////return dt;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you sure?", "Some Title", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "UPDATE Item set Item=N'" + txtName.Text.Replace("'", "`") + "' where INo='" + SI.Text + "'";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("Item Updated Successfully !");
RESET();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you sure?", "Some Title", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "UPDATE Company set CName=N'" + txtName.Text.Replace("'", "`") + "',CAddress=N'" + txtCompanyAddress.Text.Replace("'", "`") + "',COwner=N'" + txtOwner.Text.Replace("'", "`") + "',CMobile=N'" + txtMobile.Text.Replace("'", "`") + "',CPhone=N'" + txtPhone.Text.Replace("'", "`") + "',CEmail=N'" + txtEmail.Text.Replace("'", "`") + "',CWebsite=N'" + txtWebsite.Text.Replace("'", "`") + "' where ID='" + SI.Text + "'";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("Company Updated Successfully !");
//RESET();
}
}
}
private void Transaction_ID()
{
SqlConnection connection = ConnectDB.GetSqlConnection();
string sqlQuery = "SELECT MAX(ID) from Item";
SqlCommand command = new SqlCommand(sqlQuery, connection);
SqlDataReader reader = command.ExecuteReader();
reader.Read();
{
try
{
SI.Text = "Item-" + (reader.GetInt64(0) + 1).ToString();
}
catch
{
SI.Text = "Item-1";
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtPassword.Text == txtConfirmPassword.Text && txtName.Text != "" && txtPassword.Text != "")
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "INSERT INTO Authenticat values ( '" + txtName.Text + "','" + txtPassword.Text + "')";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("User Created Successfully !");
RESET();
}
}
else
{
MessageBox.Show("Password did not match.");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text != "")
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "INSERT INTO Groups values ( N'" + txtName.Text.Replace("'", "`") + "',N'" + txtU.Text.Replace("'", "`") + "')";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("Groups Created Successfully !");
RESET();
}
}
else
{
MessageBox.Show("Check Required Field !!");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text != "")
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "INSERT INTO Item values (N'" + SI.Text + "', N'" + txtName.Text + "' )";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("Item Created Successfully !");
RESET();
}
}
else
{
MessageBox.Show(" required");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string Symbol = "Symbol";
if (txtUnit.Text != "")
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "UPDATE Unit set Unit=N'" + txtUnit.Text.Replace("'", "`") + "',Symbol= '" + Symbol + "' where ID='" + txtSI.Text + "'";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("Item Updated Successfully !");
RESET();
}
}
else
{
MessageBox.Show(" required");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtUnit.Text != "")
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "DELETE Unit where ID='" + txtSI.Text + "'";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("Unit Delete Successfully !");
RESET();
}
}
else
{
MessageBox.Show(" required");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you sure?", "Some Title", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
SqlConnection scn = ConnectDB.GetSqlConnection();
//Insert Query for Vouchar
SqlCommand scm = new SqlCommand();
scm.Connection = scn;
scm.CommandText = "DELETE Groups where ID='" + SI.Text + "'";
if (scm.ExecuteNonQuery() > 0)
{
MessageBox.Show("Groups Delete Successfully !");
SqlCommand scm_delete = new SqlCommand();
scm_delete.Connection = scn;
scm_delete.CommandText = "DELETE Accounts where Groups_ID='" + SI.Text + "'";
scm_delete.ExecuteNonQuery();
RESET();
}
}
}
private void txtUName_Validating(object sender, CancelEventArgs e)
{
SqlConnection conn = ConnectDB.GetSqlConnection();
string query = "select UName from Authenticat where UName=@find";
SqlCommand command = new SqlCommand(query, conn);
command.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NVarChar, 250, "UName"));
command.Parameters["@find"].Value = txtName.Text;
rdr = command.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("User Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtName.Text = "";
txtName.Focus();
if ((rdr != null))
{
rdr.Close();
}
return;
}
}
private void btnPriview_Click(object sender, EventArgs e)
{
if (radioAll.Checked == true)
{
SqlConnection connection = ConnectDB.GetSqlConnection();
// string query = "select Groups,Ledgers,Address,Mobile,SUM(Credit)-SUM(Debit) as Balance from Accounts where Date <= Convert(DateTime,'" + To.Text + "',103) group by Groups,Ledgers,Address,Mobile";
string query = "select a.Groups,SUM(a.Credit)-SUM(a.Debit) as Balance,L.Ledgers,L.Address,L.Mobile from Accounts a inner join Ledgers L on a.Ledgers_ID=L.LNo where (Convert(Datetime,a.Date,103) between Convert(Datetime,'" + From.Text + "',103) and Convert(Datetime,'" + To.Text + "',103)) group by a.Groups,L.Groups,L.Ledgers,L.Address,L.Mobile HAVING SUM(a.Credit)-SUM(a.Debit) <>0 order by L.Ledgers";
SqlDataAdapter ad1 = new SqlDataAdapter(query, connection);
string query1 = "select * from Company";
SqlDataAdapter ad = new SqlDataAdapter(query1, connection);
DSBalanceSheet DS = new DSBalanceSheet();
ad1.Fill(DS, "Accounts");
ad.Fill(DS, "Company");
rptBalanceSheets cr = new rptBalanceSheets();
//cr.SetDataSource(DS);
cr.SetDataSource(DS);
Print f2 = new Print();
f2.Show();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition1;
ParameterFieldDefinition crParameterFieldDefinition2;
// ParameterFieldDefinition crParameterFieldDefinition3;
//ParameterFieldDefinition crParameterFieldDefinition4;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterValues crParameterValues2 = new ParameterValues();
// ParameterValues crParameterValues3 = new ParameterValues();
//ParameterValues crParameterValues4 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue();
// ParameterDiscreteValue crParameterDiscreteValue3 = new ParameterDiscreteValue();
//ParameterDiscreteValue crParameterDiscreteValue4 = new ParameterDiscreteValue();
crParameterDiscreteValue1.Value = From.Text;
crParameterDiscreteValue2.Value = To.Text;
//crParameterDiscreteValue3.Value = txtDueAmount.Text;
//crParameterDiscreteValue4.Value = txtPaid.Text;
crParameterFieldDefinitions = cr.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions["From"];
crParameterFieldDefinition2 = crParameterFieldDefinitions["To"];
//crParameterFieldDefinition3 = crParameterFieldDefinitions["Due Amount"];
//crParameterFieldDefinition4 = crParameterFieldDefinitions["Paid"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues2 = crParameterFieldDefinition2.CurrentValues;
//crParameterValues3 = crParameterFieldDefinition3.CurrentValues;
//crParameterValues4 = crParameterFieldDefinition4.CurrentValues;
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterValues2.Add(crParameterDiscreteValue2);
//crParameterValues3.Add(crParameterDiscreteValue3);
//crParameterValues4.Add(crParameterDiscreteValue4);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2);
f2.crystalReportViewer1.ReportSource = cr;
f2.crystalReportViewer1.Refresh();
}
if (radioRanged.Checked == true)
{
SqlConnection connection = ConnectDB.GetSqlConnection();
// string query = "select Groups,Ledgers,Address,Mobile,SUM(Credit)-SUM(Debit) as Balance from Accounts where Date <= Convert(DateTime,'" + To.Text + "',103) group by Groups,Ledgers,Address,Mobile";
string query = "select a.Groups,SUM(a.Credit)-SUM(a.Debit) as Balance,L.Ledgers,L.Address,L.Mobile from Accounts a inner join Ledgers L on a.Ledgers_ID=L.LNo where a.Groups='" + cmbGroups.Text + "' and (Convert(Datetime,a.Date,103) between Convert(Datetime,'" + From.Text + "',103) and Convert(Datetime,'" + To.Text + "',103)) group by a.Groups,L.Groups,L.Ledgers,L.Address,L.Mobile HAVING SUM(a.Credit)-SUM(a.Debit) <>0 order by L.Ledgers";
SqlDataAdapter ad1 = new SqlDataAdapter(query, connection);
string query1 = "select * from Company";
SqlDataAdapter ad = new SqlDataAdapter(query1, connection);
DSBalanceSheet DS = new DSBalanceSheet();
ad1.Fill(DS, "Accounts");
ad.Fill(DS, "Company");
rptBalanceSheets cr = new rptBalanceSheets();
//cr.SetDataSource(DS);
cr.SetDataSource(DS);
Print f2 = new Print();
f2.Show();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition1;
ParameterFieldDefinition crParameterFieldDefinition2;
// ParameterFieldDefinition crParameterFieldDefinition3;
//ParameterFieldDefinition crParameterFieldDefinition4;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterValues crParameterValues2 = new ParameterValues();
// ParameterValues crParameterValues3 = new ParameterValues();
//ParameterValues crParameterValues4 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue();
// ParameterDiscreteValue crParameterDiscreteValue3 = new ParameterDiscreteValue();
//ParameterDiscreteValue crParameterDiscreteValue4 = new ParameterDiscreteValue();
crParameterDiscreteValue1.Value = From.Text;
crParameterDiscreteValue2.Value = To.Text;
//crParameterDiscreteValue3.Value = txtDueAmount.Text;
//crParameterDiscreteValue4.Value = txtPaid.Text;
crParameterFieldDefinitions = cr.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions["From"];
crParameterFieldDefinition2 = crParameterFieldDefinitions["To"];
//crParameterFieldDefinition3 = crParameterFieldDefinitions["Due Amount"];
//crParameterFieldDefinition4 = crParameterFieldDefinitions["Paid"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues2 = crParameterFieldDefinition2.CurrentValues;
//crParameterValues3 = crParameterFieldDefinition3.CurrentValues;
//crParameterValues4 = crParameterFieldDefinition4.CurrentValues;
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterValues2.Add(crParameterDiscreteValue2);
//crParameterValues3.Add(crParameterDiscreteValue3);
//crParameterValues4.Add(crParameterDiscreteValue4);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2);
f2.crystalReportViewer1.ReportSource = cr;
f2.crystalReportViewer1.Refresh();
}
}
private void btnPriview_Click(object sender, EventArgs e)
{
if (radioRanged.Checked == true)
{
SqlConnection connection = ConnectDB.GetSqlConnection();
string query = " select * from Accounts where (Convert(Datetime,Date,103) between Convert(Datetime,'" + From.Text + "',103) and Convert(Datetime,'" + To.Text + "',103)) order by TNo ";
SqlDataAdapter ad1 = new SqlDataAdapter(query, connection);
string query1 = "select * from Company";
SqlDataAdapter ad = new SqlDataAdapter(query1, connection);
DSDayBook DS = new DSDayBook();
//ad.Fill(DS, "Company");
ad1.Fill(DS, "Account");
ad.Fill(DS, "Company");
rptDB cr = new rptDB();
//cr.SetDataSource(DS);
cr.SetDataSource(DS);
Print f2 = new Print();
f2.Show();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition1;
ParameterFieldDefinition crParameterFieldDefinition2;
//ParameterFieldDefinition crParameterFieldDefinition3;
//ParameterFieldDefinition crParameterFieldDefinition4;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterValues crParameterValues2 = new ParameterValues();
//ParameterValues crParameterValues3 = new ParameterValues();
//ParameterValues crParameterValues4 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue();
//ParameterDiscreteValue crParameterDiscreteValue3 = new ParameterDiscreteValue();
//ParameterDiscreteValue crParameterDiscreteValue4 = new ParameterDiscreteValue();
crParameterDiscreteValue1.Value = From.Text;
crParameterDiscreteValue2.Value = To.Text;
//crParameterDiscreteValue3.Value = txtDueAmount.Text;
//crParameterDiscreteValue4.Value = txtPaid.Text;
crParameterFieldDefinitions = cr.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions["From"];
crParameterFieldDefinition2 = crParameterFieldDefinitions["To"];
//crParameterFieldDefinition3 = crParameterFieldDefinitions["Due Amount"];
//crParameterFieldDefinition4 = crParameterFieldDefinitions["Paid"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues2 = crParameterFieldDefinition2.CurrentValues;
//crParameterValues3 = crParameterFieldDefinition3.CurrentValues;
//crParameterValues4 = crParameterFieldDefinition4.CurrentValues;
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterValues2.Add(crParameterDiscreteValue2);
//crParameterValues3.Add(crParameterDiscreteValue3);
//crParameterValues4.Add(crParameterDiscreteValue4);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2);
f2.crystalReportViewer1.ReportSource = cr;
f2.crystalReportViewer1.Refresh();
}
if (radioAll.Checked == true)
{
SqlConnection connection = ConnectDB.GetSqlConnection();
string query = " select * from Accounts order by TNo ";
SqlDataAdapter ad1 = new SqlDataAdapter(query, connection);
string query1 = "select * from Company";
SqlDataAdapter ad = new SqlDataAdapter(query1, connection);
DSDayBook DS = new DSDayBook();
ad.Fill(DS, "Company");
ad1.Fill(DS, "Account");
rptD cr = new rptD();
cr.SetDataSource(DS);
cr.SetDataSource(DS);
Print f2 = new Print();
f2.Show();
f2.crystalReportViewer1.ReportSource = cr;
f2.crystalReportViewer1.Refresh();
}
}