// Find a customer by name and category
public static int SearchForCustomer(string customername, string categoryname)
{
string sql;
sql = SqlProcedures.GetCustomers(customername, categoryname);
DataTable temp = Call(sql);
if (temp.Rows.Count > 0)
{
int id;
int.TryParse(temp.Rows[0][0].ToString(), out id);
return(id);
}
else
{
return(-1);
}
}