// GET: /Employee/Delete/<id> public ActionResult Delete( Int32?EmployeeID ) { if ( EmployeeID == null ) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } dtCompany = Employee_CompanyData.SelectAll(); Employee Employee = new Employee(); Employee.EmployeeID = System.Convert.ToInt32(EmployeeID); Employee = EmployeeData.Select_Record(Employee); Employee.Company = new Company() { CompanyID = (Int32)Employee.CompanyID , CompanyName = (from DataRow rowCompany in dtCompany.Rows where Employee.CompanyID == (int)rowCompany["CompanyID"] select(String) rowCompany["CompanyName"]).FirstOrDefault() }; if (Employee == null) { return(HttpNotFound()); } return(View(Employee)); }
public ActionResult Edit(Employee Employee) { Employee oEmployee = new Employee(); oEmployee.EmployeeID = System.Convert.ToInt32(Employee.EmployeeID); oEmployee = EmployeeData.Select_Record(Employee); if (ModelState.IsValid) { bool bSucess = false; bSucess = EmployeeData.Update(oEmployee, Employee); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Update"); } } // ComboBox ViewData["CompanyID"] = new SelectList(Employee_CompanyData.List(), "CompanyID", "CompanyName", Employee.CompanyID); return(View(Employee)); }
// GET: /Employee/Edit/<id> public ActionResult Edit( Int32?EmployeeID ) { if ( EmployeeID == null ) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Employee Employee = new Employee(); Employee.EmployeeID = System.Convert.ToInt32(EmployeeID); Employee = EmployeeData.Select_Record(Employee); if (Employee == null) { return(HttpNotFound()); } // ComboBox ViewData["CompanyID"] = new SelectList(Employee_CompanyData.List(), "CompanyID", "CompanyName", Employee.CompanyID); return(View(Employee)); }
// GET: /Employee/Create public ActionResult Create() { // ComboBox ViewData["CompanyID"] = new SelectList(Employee_CompanyData.List(), "CompanyID", "CompanyName"); return(View()); }
public ActionResult Create([Bind(Include = "FirstName" + "," + "LastName" + "," + "DOB" + "," + "DOJ" + "," + "Gender" + "," + "EMail" + "," + "Mobile" + "," + "Address1" + "," + "Address2" + "," + "Salary" + "," + "SignatureURL" + "," + "UserName" + "," + "Password" + "," + "CompanyID" + "," + "AddUserID" + "," + "AddDate" + "," + "ArchiveUserID" + "," + "ArchiveDate" )] Employee Employee) { if (ModelState.IsValid) { bool bSucess = false; bSucess = EmployeeData.Add(Employee); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Insert"); } } // ComboBox ViewData["CompanyID"] = new SelectList(Employee_CompanyData.List(), "CompanyID", "CompanyName", Employee.CompanyID); return(View(Employee)); }
// GET: /Employee/ 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 ? "Employee 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["EmployeeIDSortParm"] = sortOrder == "EmployeeID_asc" ? "EmployeeID_desc" : "EmployeeID_asc"; ViewData["FirstNameSortParm"] = sortOrder == "FirstName_asc" ? "FirstName_desc" : "FirstName_asc"; ViewData["LastNameSortParm"] = sortOrder == "LastName_asc" ? "LastName_desc" : "LastName_asc"; ViewData["DOBSortParm"] = sortOrder == "DOB_asc" ? "DOB_desc" : "DOB_asc"; ViewData["DOJSortParm"] = sortOrder == "DOJ_asc" ? "DOJ_desc" : "DOJ_asc"; ViewData["GenderSortParm"] = sortOrder == "Gender_asc" ? "Gender_desc" : "Gender_asc"; ViewData["EMailSortParm"] = sortOrder == "EMail_asc" ? "EMail_desc" : "EMail_asc"; ViewData["MobileSortParm"] = sortOrder == "Mobile_asc" ? "Mobile_desc" : "Mobile_asc"; ViewData["Address1SortParm"] = sortOrder == "Address1_asc" ? "Address1_desc" : "Address1_asc"; ViewData["Address2SortParm"] = sortOrder == "Address2_asc" ? "Address2_desc" : "Address2_asc"; ViewData["SalarySortParm"] = sortOrder == "Salary_asc" ? "Salary_desc" : "Salary_asc"; ViewData["SignatureURLSortParm"] = sortOrder == "SignatureURL_asc" ? "SignatureURL_desc" : "SignatureURL_asc"; ViewData["UserNameSortParm"] = sortOrder == "UserName_asc" ? "UserName_desc" : "UserName_asc"; ViewData["PasswordSortParm"] = sortOrder == "Password_asc" ? "Password_desc" : "Password_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"; dtEmployee = EmployeeData.SelectAll(); dtCompany = Employee_CompanyData.SelectAll(); try { if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"]))) { dtEmployee = EmployeeData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"])); } } catch { } var Query = from rowEmployee in dtEmployee.AsEnumerable() join rowCompany in dtCompany.AsEnumerable() on rowEmployee.Field <Int32>("CompanyID") equals rowCompany.Field <Int32>("CompanyID") select new Employee() { EmployeeID = rowEmployee.Field <Int32>("EmployeeID") , FirstName = rowEmployee.Field <String>("FirstName") , LastName = rowEmployee.Field <String>("LastName") , DOB = rowEmployee.Field <DateTime>("DOB") , DOJ = rowEmployee.Field <DateTime>("DOJ") , Gender = rowEmployee.Field <String>("Gender") , EMail = rowEmployee.Field <String>("EMail") , Mobile = rowEmployee.Field <String>("Mobile") , Address1 = rowEmployee.Field <String>("Address1") , Address2 = rowEmployee.Field <String>("Address2") , Salary = rowEmployee.Field <Decimal>("Salary") , UserName = rowEmployee.Field <String>("UserName") , Password = rowEmployee.Field <String>("Password") , SignatureURL = rowEmployee.Field <String>("SignatureURL") , Company = new Company() { CompanyID = rowCompany.Field <Int32>("CompanyID") , CompanyName = rowCompany.Field <String>("CompanyName") } , AddUserID = rowEmployee.Field <Int32>("AddUserID") , AddDate = rowEmployee.Field <DateTime>("AddDate") , ArchiveUserID = rowEmployee.Field <Int32?>("ArchiveUserID") , ArchiveDate = rowEmployee.Field <DateTime?>("ArchiveDate") }; switch (sortOrder) { case "EmployeeID_desc": Query = Query.OrderByDescending(s => s.EmployeeID); break; case "EmployeeID_asc": Query = Query.OrderBy(s => s.EmployeeID); break; case "FirstName_desc": Query = Query.OrderByDescending(s => s.FirstName); break; case "FirstName_asc": Query = Query.OrderBy(s => s.FirstName); break; case "LastName_desc": Query = Query.OrderByDescending(s => s.LastName); break; case "LastName_asc": Query = Query.OrderBy(s => s.LastName); break; case "DOB_desc": Query = Query.OrderByDescending(s => s.DOB); break; case "DOB_asc": Query = Query.OrderBy(s => s.DOB); break; case "DOJ_desc": Query = Query.OrderByDescending(s => s.DOJ); break; case "DOJ_asc": Query = Query.OrderBy(s => s.DOJ); break; case "Gender_desc": Query = Query.OrderByDescending(s => s.Gender); break; case "Gender_asc": Query = Query.OrderBy(s => s.Gender); break; case "EMail_desc": Query = Query.OrderByDescending(s => s.EMail); break; case "EMail_asc": Query = Query.OrderBy(s => s.EMail); break; case "Mobile_desc": Query = Query.OrderByDescending(s => s.Mobile); break; case "Mobile_asc": Query = Query.OrderBy(s => s.Mobile); 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 "Salary_desc": Query = Query.OrderByDescending(s => s.Salary); break; case "Salary_asc": Query = Query.OrderBy(s => s.Salary); break; case "SignatureURL_desc": Query = Query.OrderByDescending(s => s.SignatureURL); break; case "SignatureURL_asc": Query = Query.OrderBy(s => s.SignatureURL); break; case "UserName_desc": Query = Query.OrderByDescending(s => s.UserName); break; case "UserName_asc": Query = Query.OrderBy(s => s.UserName); break; case "Password_desc": Query = Query.OrderByDescending(s => s.Password); break; case "Password_asc": Query = Query.OrderBy(s => s.Password); 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.EmployeeID); break; } if (command == "Export") { GridView gv = new GridView(); DataTable dt = new DataTable(); dt.Columns.Add("Employee I D", typeof(string)); dt.Columns.Add("First Name", typeof(string)); dt.Columns.Add("Last Name", typeof(string)); dt.Columns.Add("D O B", typeof(string)); dt.Columns.Add("D O J", typeof(string)); dt.Columns.Add("Gender", typeof(string)); dt.Columns.Add("E Mail", typeof(string)); dt.Columns.Add("Mobile", typeof(string)); dt.Columns.Add("Address1", typeof(string)); dt.Columns.Add("Address2", typeof(string)); dt.Columns.Add("Salary", typeof(string)); dt.Columns.Add("Signature U R L", typeof(string)); dt.Columns.Add("User Name", typeof(string)); dt.Columns.Add("Password", 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.EmployeeID , item.FirstName , item.LastName , item.DOB , item.DOJ , item.Gender , item.EMail , item.Mobile , item.Address1 , item.Address2 , item.Salary , item.SignatureURL , item.UserName , item.Password , 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)))); }