// GET: /ArchitectAssociate/
public ActionResult Index(string sortOrder,
String SearchField,
String SearchCondition,
String SearchText,
String Export,
int?PageSize,
int?page,
string command)
{
if (command == "Show All")
{
SearchField = null;
SearchCondition = null;
SearchText = null;
Session["SearchField"] = null;
Session["SearchCondition"] = null;
Session["SearchText"] = null;
}
else if (command == "Add New Record")
{
return(RedirectToAction("Create"));
}
else if (command == "Export")
{
Session["Export"] = Export;
}
else if (command == "Search" | command == "Page Size")
{
if (!string.IsNullOrEmpty(SearchText))
{
Session["SearchField"] = SearchField;
Session["SearchCondition"] = SearchCondition;
Session["SearchText"] = SearchText;
}
}
if (command == "Page Size")
{
Session["PageSize"] = PageSize;
}
ViewData["SearchFields"] = GetFields((Session["SearchField"] == null ? "Architect Associate I D" : Convert.ToString(Session["SearchField"])));
ViewData["SearchConditions"] = Library.GetConditions((Session["SearchCondition"] == null ? "Contains" : Convert.ToString(Session["SearchCondition"])));
ViewData["SearchText"] = Session["SearchText"];
ViewData["Exports"] = Library.GetExports((Session["Export"] == null ? "Pdf" : Convert.ToString(Session["Export"])));
ViewData["PageSizes"] = Library.GetPageSizes();
ViewData["CurrentSort"] = sortOrder;
ViewData["ArchitectAssociateIDSortParm"] = sortOrder == "ArchitectAssociateID_asc" ? "ArchitectAssociateID_desc" : "ArchitectAssociateID_asc";
ViewData["ArchitectIDSortParm"] = sortOrder == "ArchitectID_asc" ? "ArchitectID_desc" : "ArchitectID_asc";
ViewData["AssociateNameSortParm"] = sortOrder == "AssociateName_asc" ? "AssociateName_desc" : "AssociateName_asc";
ViewData["ContactNoSortParm"] = sortOrder == "ContactNo_asc" ? "ContactNo_desc" : "ContactNo_asc";
ViewData["EMailSortParm"] = sortOrder == "EMail_asc" ? "EMail_desc" : "EMail_asc";
dtArchitectAssociate = ArchitectAssociateData.SelectAll();
dtArchitect = ArchitectAssociate_ArchitectData.SelectAll();
try
{
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"])))
{
dtArchitectAssociate = ArchitectAssociateData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"]));
}
}
catch { }
var Query = from rowArchitectAssociate in dtArchitectAssociate.AsEnumerable()
join rowArchitect in dtArchitect.AsEnumerable() on rowArchitectAssociate.Field <Int32>("ArchitectID") equals rowArchitect.Field <Int32>("ArchitectID")
select new ArchitectAssociate()
{
ArchitectAssociateID = rowArchitectAssociate.Field <Int32>("ArchitectAssociateID")
,
Architect = new Architect()
{
ArchitectID = rowArchitect.Field <Int32>("ArchitectID")
,
ArchitectName = rowArchitect.Field <String>("ArchitectName")
}
,
AssociateName = rowArchitectAssociate.Field <String>("AssociateName")
,
ContactNo = rowArchitectAssociate.Field <String>("ContactNo")
,
EMail = rowArchitectAssociate.Field <String>("EMail")
};
switch (sortOrder)
{
case "ArchitectAssociateID_desc":
Query = Query.OrderByDescending(s => s.ArchitectAssociateID);
break;
case "ArchitectAssociateID_asc":
Query = Query.OrderBy(s => s.ArchitectAssociateID);
break;
case "ArchitectID_desc":
Query = Query.OrderByDescending(s => s.Architect.ArchitectName);
break;
case "ArchitectID_asc":
Query = Query.OrderBy(s => s.Architect.ArchitectName);
break;
case "AssociateName_desc":
Query = Query.OrderByDescending(s => s.AssociateName);
break;
case "AssociateName_asc":
Query = Query.OrderBy(s => s.AssociateName);
break;
case "ContactNo_desc":
Query = Query.OrderByDescending(s => s.ContactNo);
break;
case "ContactNo_asc":
Query = Query.OrderBy(s => s.ContactNo);
break;
case "EMail_desc":
Query = Query.OrderByDescending(s => s.EMail);
break;
case "EMail_asc":
Query = Query.OrderBy(s => s.EMail);
break;
default: // Name ascending
Query = Query.OrderBy(s => s.ArchitectAssociateID);
break;
}
if (command == "Export")
{
GridView gv = new GridView();
DataTable dt = new DataTable();
dt.Columns.Add("Architect Associate I D", typeof(string));
dt.Columns.Add("Architect I D", typeof(string));
dt.Columns.Add("Associate Name", typeof(string));
dt.Columns.Add("Contact No", typeof(string));
dt.Columns.Add("E Mail", typeof(string));
foreach (var item in Query)
{
dt.Rows.Add(
item.ArchitectAssociateID
, item.Architect.ArchitectName
, item.AssociateName
, item.ContactNo
, item.EMail
);
}
gv.DataSource = dt;
gv.DataBind();
ExportData(Export, gv, dt);
}
int pageNumber = (page ?? 1);
int?pageSZ = (Convert.ToInt32(Session["PageSize"]) == 0 ? 5 : Convert.ToInt32(Session["PageSize"]));
return(View(Query.ToPagedList(pageNumber, (pageSZ ?? 5))));
}
