private void DisplayData()
{
string vWhere = string.Empty;
if (!string.IsNullOrEmpty(txtFilter.Text))
{
vWhere = " AND Parties.PartyName Like '%" + txtFilter.Text + "%'";
}
vWhere += string.Format(" And convert(datetime,Convert(varchar,CustomerIssue.IssueDate,1)) Between Convert(Datetime,(convert(varchar,convert(Datetime,'{0} 00:00:00',102),1)))and Convert(Datetime,(convert(varchar,convert(Datetime,'{1} 00:00:00',102),1)))", dt_From.Value.ToShortDateString(), dt_ToDate.Value.ToShortDateString());
if (vIsFromReturn)
{
vWhere += " AND SaleID NOT IN (Select SaleID From SaleReturn)";
}
try
{
DAL.CustomerIssue objDAL = new DAL.CustomerIssue();
objDAL.connectionstring = connectionString;
dt = objDAL.getSearchRecord(vWhere);
Grid.AutoGenerateColumns = false;
Grid.DataSource = dt;
}
catch (Exception exc)
{
MessageBox.Show(exc.Message.ToString());
}
}
private void txtVendorID_TextChanged(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtVendorID.Text))
{
txtVendorName.Text = string.Empty;
}
else
{
string vWhere = string.Empty;
vWhere = "AND Parties.PartyID = " + txtVendorID.Text;
DAL.CustomerIssue obj = new DAL.CustomerIssue();
obj.connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString;
//DataTable dt = obj.getParties(vWhere);
DataTable dt = obj.getParties(vWhere);
if (dt.Rows.Count > 0)
{
txtVendorID.Text = dt.Rows[0]["PartyID"].ToString(); // vForm.MyID;
txtVendorName.Text = dt.Rows[0]["PartyName"].ToString(); // vForm.MyName;
}
}
}
