protected void Page_Load(object sender, EventArgs e)
{
var criteria = Request["query"];
//if (!criteria.Contains(' '))
// criteria = criteria + ' ';
var arabic = Convert.ToBoolean(Request["arabic"]);
var translationID = arabic ? 45 : 7;
var searchTranslationIDs = new int[] { 6, 12, 45, 50, 5 };
using (var quran = new QuranContext())
{
var verse = from a in quran.Ayahs
where searchTranslationIDs.Contains(a.TranslatorID) && a.Content.Contains(criteria)
group a by new { a.SurahNo, a.AyahNo } into anAyah
select new
{
SurahNo = anAyah.Key.SurahNo,
AyahNo = anAyah.Key.AyahNo,
Result = (arabic ? "<big>" : "") + anAyah.FirstOrDefault().Content.Replace(criteria, "<em>" + criteria + "</em>") + (arabic ? "" : " - <small>[" + anAyah.FirstOrDefault().Translator.Name + "]</small>") + (arabic ? "</big>" : ""),
Other = (from b in quran.Ayahs
where b.AyahNo == anAyah.Key.AyahNo &&
b.SurahNo == anAyah.Key.SurahNo &&
b.TranslatorID == translationID
select(arabic ? "" : "<big>") + b.Content + (arabic ? " - <small>[" + b.Translator.Name + "]</small>" : "") + (arabic ? "" : "</big>")).FirstOrDefault()
};
SearchResultGridView.DataSource = verse.Take(50).ToList();
SearchResultGridView.DataBind();
}
}
private void PopulateGridView()
{
TextInfo myTI = new CultureInfo("en-US", false).TextInfo;
List <Employee> employees;
String lastName = SearchLastName.Text;
String lastNameProp = myTI.ToTitleCase(lastName);
String firstName = SearchFirstName.Text;
String firstNameProp = myTI.ToTitleCase(firstName);
String department = SearchDepartment.Text;
String departmentProp = myTI.ToTitleCase(department);
int n = 0;
if (string.IsNullOrEmpty(lastNameProp) && !string.IsNullOrEmpty(firstNameProp) && !string.IsNullOrEmpty(departmentProp))
{
n = 1;
}
if (string.IsNullOrEmpty(lastNameProp) && string.IsNullOrEmpty(firstNameProp) && !string.IsNullOrEmpty(departmentProp))
{
n = 2;
}
if (string.IsNullOrEmpty(lastNameProp) && string.IsNullOrEmpty(firstNameProp) && string.IsNullOrEmpty(departmentProp))
{
n = 3;
}
if (string.IsNullOrEmpty(firstNameProp) && !string.IsNullOrEmpty(lastNameProp) && !string.IsNullOrEmpty(departmentProp))
{
n = 4;
}
if (string.IsNullOrEmpty(departmentProp) && !string.IsNullOrEmpty(lastNameProp) && !string.IsNullOrEmpty(firstNameProp))
{
n = 5;
}
if (!string.IsNullOrEmpty(lastNameProp) && !string.IsNullOrEmpty(firstNameProp) && !string.IsNullOrEmpty(departmentProp))
{
n = 6;
}
if (!string.IsNullOrEmpty(lastNameProp) && string.IsNullOrEmpty(firstNameProp) && string.IsNullOrEmpty(departmentProp))
{
n = 7;
}
if (!string.IsNullOrEmpty(firstNameProp) && string.IsNullOrEmpty(lastNameProp) && string.IsNullOrEmpty(departmentProp))
{
n = 8;
}
switch (n)
{
case 1:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.SearchEmployees("FirstName = " + "\""
+ firstNameProp + "\""
+ " AND Department = " + "\"" + departmentProp + "\""), "LastName");
break;
case 2:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.SearchEmployees("Department = " + "\""
+ departmentProp + "\""), "LastName");
break;
case 3:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.GetAllEmployees(), "LastName");
break;
case 4:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.SearchEmployees("LastName = " + "\"" + lastNameProp + "\""
+ " AND Department = " + "\"" + departmentProp + "\""), "LastName");
break;
case 5:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.SearchEmployees("LastName = " + "\"" + lastNameProp + "\""
+ " AND FirstName = " + "\"" + firstNameProp + "\""), "LastName");
break;
case 6:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.SearchEmployees("LastName = " + "\"" + lastNameProp + "\""
+ " AND FirstName = " + "\"" + firstNameProp + "\""
+ " AND Department = " + "\"" + departmentProp + "\""), "LastName");
break;
case 7:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.SearchEmployees("LastName = "
+ "\"" + lastNameProp + "\""), "LastName");
break;
case 8:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.SearchEmployees("FirstName = "
+ "\"" + firstNameProp + "\""), "LastName");
break;
default:
employees = EmployeeDataAccess.SortEmployees(EmployeeDataAccess.GetAllEmployees(), "LastName");
break;
}
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[6] {
new DataColumn("EmployeeID"), new DataColumn("LastName"),
new DataColumn("FirstName"), new DataColumn("Department"),
new DataColumn("Title"), new DataColumn("Extension")
});
foreach (var employee in employees)
{
DataRow dr = dt.NewRow();
dr["EmployeeID"] = employee.EmployeeID;
dr["FirstName"] = employee.FirstName;
dr["LastName"] = employee.LastName;
dr["Title"] = employee.Title;
dr["Department"] = employee.Department;
dr["Extension"] = employee.Extension;
dt.Rows.Add(dr);
}
SearchResultGridView.DataSource = dt;
SearchResultGridView.DataBind();
}
public void FillSearchGridView()
{
SearchResultGridView.DataSource = _dataTable;
SearchResultGridView.DataBind();
}
