private void regularserchTXT_ButtonClick(object sender, EventArgs e)
{
regularserchTXT.Text = regularserchTXT.Text.Replace("'", "`").Trim();
regularserchTXT.Text = regularserchTXT.Text.Replace("\"", "``").Trim();
CallinTableClass b = new CallinTableClass(this);
string query = "select " + rowcounter(rownumber1.Text) + " " + b.callintbcolumns + " from callintb where project like '%" + regularserchTXT.Text + "%'";
b.findcallin(query);
}
private void findBTN_Click(object sender, EventArgs e)
{
cleanSearchfields();
string cola = "STATUS";
string colb = "CDATE";
string colc = "CIN";
string cold = "PROJECT";
string colf = "ADDRESS";
string colg = "RECIPIENT";
string a = statusSearch.Text;
string b = dateSearch.Text;
string c = cinSearch.Text;
string d = projectSearch.Text;
string f = addressSearch.Text;
string g = recipientSearch.Text;
if (a == "")
{
a = "STATUS";
}
else
{
a = "'%" + a + "%'";
}
if (b == "")
{
b = "CDATE";
}
else
{
b = "'%" + b + "%'";
}
if (c == "")
{
c = "CIN";
}
else
{
c = "'%" + c + "%'";
}
if (d == "")
{
d = "PROJECT";
}
else
{
d = "'%" + d + "%'";
}
if (f == "")
{
f = "ADDRESS";
}
else
{
f = "'%" + f + "%'";
}
if (g == "")
{
g = "RECIPIENT";
}
else
{
g = "'%" + g + "%'";
}
CallinTableClass y = new CallinTableClass(this);
string query = "select " + rowcounter(rownumber1.Text) + " " + y.callintbcolumns + " from callintb where " + cola + " like " + a + " and " +
"" + colb + " like " + b + " and " +
"" + colc + " like " + c + " and " +
"" + cold + " like " + d + " and " +
"" + colf + " like " + f + " and " +
"" + colg + " like " + g + " order by autonum desc";
y.findcallin(query);
}