// GET: /Architect/Delete/<id>
public ActionResult Delete(
Int32?ArchitectID
)
{
if (
ArchitectID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dtCompany = Architect_CompanyData.SelectAll();
Architect Architect = new Architect();
Architect.ArchitectID = System.Convert.ToInt32(ArchitectID);
Architect = ArchitectData.Select_Record(Architect);
Architect.Company = new Company()
{
CompanyID = (Int32)Architect.CompanyID
, CompanyName = (from DataRow rowCompany in dtCompany.Rows
where Architect.CompanyID == (int)rowCompany["CompanyID"]
select(String) rowCompany["CompanyName"]).FirstOrDefault()
};
if (Architect == null)
{
return(HttpNotFound());
}
return(View(Architect));
}
public ActionResult Edit(Architect Architect)
{
Architect oArchitect = new Architect();
oArchitect.ArchitectID = System.Convert.ToInt32(Architect.ArchitectID);
oArchitect = ArchitectData.Select_Record(Architect);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = ArchitectData.Update(oArchitect, Architect);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
// ComboBox
ViewData["CompanyID"] = new SelectList(Architect_CompanyData.List(), "CompanyID", "CompanyName", Architect.CompanyID);
return(View(Architect));
}
// GET: /Architect/Edit/<id>
public ActionResult Edit(
Int32?ArchitectID
)
{
if (
ArchitectID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Architect Architect = new Architect();
Architect.ArchitectID = System.Convert.ToInt32(ArchitectID);
Architect = ArchitectData.Select_Record(Architect);
if (Architect == null)
{
return(HttpNotFound());
}
// ComboBox
ViewData["CompanyID"] = new SelectList(Architect_CompanyData.List(), "CompanyID", "CompanyName", Architect.CompanyID);
return(View(Architect));
}
// GET: /Architect/Create
public ActionResult Create()
{
// ComboBox
ViewData["CompanyID"] = new SelectList(Architect_CompanyData.List(), "CompanyID", "CompanyName");
return(View());
}
public ActionResult Create([Bind(Include =
"ArchitectName"
+ "," + "Address1"
+ "," + "Address2"
+ "," + "City"
+ "," + "District"
+ "," + "State"
+ "," + "Country"
+ "," + "Pincode"
+ "," + "EMail"
+ "," + "ContactNo"
+ "," + "CompanyID"
+ "," + "AddUserID"
+ "," + "AddDate"
+ "," + "ArchiveUserID"
+ "," + "ArchiveDate"
)] Architect Architect)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = ArchitectData.Add(Architect);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["CompanyID"] = new SelectList(Architect_CompanyData.List(), "CompanyID", "CompanyName", Architect.CompanyID);
return(View(Architect));
}
// GET: /Architect/
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 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["ArchitectIDSortParm"] = sortOrder == "ArchitectID_asc" ? "ArchitectID_desc" : "ArchitectID_asc";
ViewData["ArchitectNameSortParm"] = sortOrder == "ArchitectName_asc" ? "ArchitectName_desc" : "ArchitectName_asc";
ViewData["Address1SortParm"] = sortOrder == "Address1_asc" ? "Address1_desc" : "Address1_asc";
ViewData["Address2SortParm"] = sortOrder == "Address2_asc" ? "Address2_desc" : "Address2_asc";
ViewData["CitySortParm"] = sortOrder == "City_asc" ? "City_desc" : "City_asc";
ViewData["DistrictSortParm"] = sortOrder == "District_asc" ? "District_desc" : "District_asc";
ViewData["StateSortParm"] = sortOrder == "State_asc" ? "State_desc" : "State_asc";
ViewData["CountrySortParm"] = sortOrder == "Country_asc" ? "Country_desc" : "Country_asc";
ViewData["PincodeSortParm"] = sortOrder == "Pincode_asc" ? "Pincode_desc" : "Pincode_asc";
ViewData["EMailSortParm"] = sortOrder == "EMail_asc" ? "EMail_desc" : "EMail_asc";
ViewData["ContactNoSortParm"] = sortOrder == "ContactNo_asc" ? "ContactNo_desc" : "ContactNo_asc";
ViewData["CompanyIDSortParm"] = sortOrder == "CompanyID_asc" ? "CompanyID_desc" : "CompanyID_asc";
ViewData["AddUserIDSortParm"] = sortOrder == "AddUserID_asc" ? "AddUserID_desc" : "AddUserID_asc";
ViewData["AddDateSortParm"] = sortOrder == "AddDate_asc" ? "AddDate_desc" : "AddDate_asc";
ViewData["ArchiveUserIDSortParm"] = sortOrder == "ArchiveUserID_asc" ? "ArchiveUserID_desc" : "ArchiveUserID_asc";
ViewData["ArchiveDateSortParm"] = sortOrder == "ArchiveDate_asc" ? "ArchiveDate_desc" : "ArchiveDate_asc";
dtArchitect = ArchitectData.SelectAll();
dtCompany = Architect_CompanyData.SelectAll();
try
{
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"])))
{
dtArchitect = ArchitectData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"]));
}
}
catch { }
var Query = from rowArchitect in dtArchitect.AsEnumerable()
join rowCompany in dtCompany.AsEnumerable() on rowArchitect.Field <Int32>("CompanyID") equals rowCompany.Field <Int32>("CompanyID")
select new Architect()
{
ArchitectID = rowArchitect.Field <Int32>("ArchitectID")
, ArchitectName = rowArchitect.Field <String>("ArchitectName")
, Address1 = rowArchitect.Field <String>("Address1")
, Address2 = rowArchitect.Field <String>("Address2")
, City = rowArchitect.Field <String>("City")
, District = rowArchitect.Field <String>("District")
, State = rowArchitect.Field <String>("State")
, Country = rowArchitect.Field <String>("Country")
, Pincode = rowArchitect.Field <String>("Pincode")
, EMail = rowArchitect.Field <String>("EMail")
, ContactNo = rowArchitect.Field <String>("ContactNo")
,
Company = new Company()
{
CompanyID = rowCompany.Field <Int32>("CompanyID")
, CompanyName = rowCompany.Field <String>("CompanyName")
}
, AddUserID = rowArchitect.Field <Int32?>("AddUserID")
, AddDate = rowArchitect.Field <DateTime?>("AddDate")
, ArchiveUserID = rowArchitect.Field <Int32?>("ArchiveUserID")
, ArchiveDate = rowArchitect.Field <DateTime?>("ArchiveDate")
};
switch (sortOrder)
{
case "ArchitectID_desc":
Query = Query.OrderByDescending(s => s.ArchitectID);
break;
case "ArchitectID_asc":
Query = Query.OrderBy(s => s.ArchitectID);
break;
case "ArchitectName_desc":
Query = Query.OrderByDescending(s => s.ArchitectName);
break;
case "ArchitectName_asc":
Query = Query.OrderBy(s => s.ArchitectName);
break;
case "Address1_desc":
Query = Query.OrderByDescending(s => s.Address1);
break;
case "Address1_asc":
Query = Query.OrderBy(s => s.Address1);
break;
case "Address2_desc":
Query = Query.OrderByDescending(s => s.Address2);
break;
case "Address2_asc":
Query = Query.OrderBy(s => s.Address2);
break;
case "City_desc":
Query = Query.OrderByDescending(s => s.City);
break;
case "City_asc":
Query = Query.OrderBy(s => s.City);
break;
case "District_desc":
Query = Query.OrderByDescending(s => s.District);
break;
case "District_asc":
Query = Query.OrderBy(s => s.District);
break;
case "State_desc":
Query = Query.OrderByDescending(s => s.State);
break;
case "State_asc":
Query = Query.OrderBy(s => s.State);
break;
case "Country_desc":
Query = Query.OrderByDescending(s => s.Country);
break;
case "Country_asc":
Query = Query.OrderBy(s => s.Country);
break;
case "Pincode_desc":
Query = Query.OrderByDescending(s => s.Pincode);
break;
case "Pincode_asc":
Query = Query.OrderBy(s => s.Pincode);
break;
case "EMail_desc":
Query = Query.OrderByDescending(s => s.EMail);
break;
case "EMail_asc":
Query = Query.OrderBy(s => s.EMail);
break;
case "ContactNo_desc":
Query = Query.OrderByDescending(s => s.ContactNo);
break;
case "ContactNo_asc":
Query = Query.OrderBy(s => s.ContactNo);
break;
case "CompanyID_desc":
Query = Query.OrderByDescending(s => s.Company.CompanyName);
break;
case "CompanyID_asc":
Query = Query.OrderBy(s => s.Company.CompanyName);
break;
case "AddUserID_desc":
Query = Query.OrderByDescending(s => s.AddUserID);
break;
case "AddUserID_asc":
Query = Query.OrderBy(s => s.AddUserID);
break;
case "AddDate_desc":
Query = Query.OrderByDescending(s => s.AddDate);
break;
case "AddDate_asc":
Query = Query.OrderBy(s => s.AddDate);
break;
case "ArchiveUserID_desc":
Query = Query.OrderByDescending(s => s.ArchiveUserID);
break;
case "ArchiveUserID_asc":
Query = Query.OrderBy(s => s.ArchiveUserID);
break;
case "ArchiveDate_desc":
Query = Query.OrderByDescending(s => s.ArchiveDate);
break;
case "ArchiveDate_asc":
Query = Query.OrderBy(s => s.ArchiveDate);
break;
default: // Name ascending
Query = Query.OrderBy(s => s.ArchitectID);
break;
}
if (command == "Export")
{
GridView gv = new GridView();
DataTable dt = new DataTable();
dt.Columns.Add("Architect I D", typeof(string));
dt.Columns.Add("Architect Name", typeof(string));
dt.Columns.Add("Address1", typeof(string));
dt.Columns.Add("Address2", typeof(string));
dt.Columns.Add("City", typeof(string));
dt.Columns.Add("District", typeof(string));
dt.Columns.Add("State", typeof(string));
dt.Columns.Add("Country", typeof(string));
dt.Columns.Add("Pincode", typeof(string));
dt.Columns.Add("E Mail", typeof(string));
dt.Columns.Add("Contact No", typeof(string));
dt.Columns.Add("Company I D", typeof(string));
dt.Columns.Add("Add User I D", typeof(string));
dt.Columns.Add("Add Date", typeof(string));
dt.Columns.Add("Archive User I D", typeof(string));
dt.Columns.Add("Archive Date", typeof(string));
foreach (var item in Query)
{
dt.Rows.Add(
item.ArchitectID
, item.ArchitectName
, item.Address1
, item.Address2
, item.City
, item.District
, item.State
, item.Country
, item.Pincode
, item.EMail
, item.ContactNo
, item.Company.CompanyName
, item.AddUserID
, item.AddDate
, item.ArchiveUserID
, item.ArchiveDate
);
}
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))));
}
