// 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))));
}
