// GET: /TaskAssignment/Delete/<id>
public ActionResult Delete(
Int32?TaskAssignmentID
)
{
if (
TaskAssignmentID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dtTask = TaskAssignment_TaskData.SelectAll();
dtEmployee = TaskAssignment_EmployeeData.SelectAll();
dtTaskState = TaskAssignment_TaskStateData.SelectAll();
TaskAssignment TaskAssignment = new TaskAssignment();
TaskAssignment.TaskAssignmentID = System.Convert.ToInt32(TaskAssignmentID);
TaskAssignment = TaskAssignmentData.Select_Record(TaskAssignment);
TaskAssignment.Task = new Task()
{
TaskID = (Int32)TaskAssignment.TaskID
, TaskName = (from DataRow rowTask in dtTask.Rows
where TaskAssignment.TaskID == (int)rowTask["TaskID"]
select(String) rowTask["TaskName"]).FirstOrDefault()
};
TaskAssignment.Employee = new Employee()
{
EmployeeID = (Int32)TaskAssignment.EmployeeID
, FirstName = (from DataRow rowEmployee in dtEmployee.Rows
where TaskAssignment.EmployeeID == (int)rowEmployee["EmployeeID"]
select(String) rowEmployee["FirstName"]).FirstOrDefault()
};
TaskAssignment.TaskState = new TaskState()
{
TaskStateID = (Int32)TaskAssignment.TaskStateID
, TaskStateName = (from DataRow rowTaskState in dtTaskState.Rows
where TaskAssignment.TaskStateID == (int)rowTaskState["TaskStateID"]
select(String) rowTaskState["TaskStateName"]).FirstOrDefault()
};
if (TaskAssignment == null)
{
return(HttpNotFound());
}
return(View(TaskAssignment));
}
// GET: /TaskAssignment/
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 ? "Task Assignment 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["TaskAssignmentIDSortParm"] = sortOrder == "TaskAssignmentID_asc" ? "TaskAssignmentID_desc" : "TaskAssignmentID_asc";
ViewData["AssignmentDateSortParm"] = sortOrder == "AssignmentDate_asc" ? "AssignmentDate_desc" : "AssignmentDate_asc";
ViewData["TaskIDSortParm"] = sortOrder == "TaskID_asc" ? "TaskID_desc" : "TaskID_asc";
ViewData["EmployeeIDSortParm"] = sortOrder == "EmployeeID_asc" ? "EmployeeID_desc" : "EmployeeID_asc";
ViewData["TaskStateIDSortParm"] = sortOrder == "TaskStateID_asc" ? "TaskStateID_desc" : "TaskStateID_asc";
dtTaskAssignment = TaskAssignmentData.SelectAll();
dtTask = TaskAssignment_TaskData.SelectAll();
dtEmployee = TaskAssignment_EmployeeData.SelectAll();
dtTaskState = TaskAssignment_TaskStateData.SelectAll();
try
{
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"])))
{
dtTaskAssignment = TaskAssignmentData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"]));
}
}
catch { }
var Query = from rowTaskAssignment in dtTaskAssignment.AsEnumerable()
join rowTask in dtTask.AsEnumerable() on rowTaskAssignment.Field <Int32>("TaskID") equals rowTask.Field <Int32>("TaskID")
join rowEmployee in dtEmployee.AsEnumerable() on rowTaskAssignment.Field <Int32>("EmployeeID") equals rowEmployee.Field <Int32>("EmployeeID")
join rowTaskState in dtTaskState.AsEnumerable() on rowTaskAssignment.Field <Int32>("TaskStateID") equals rowTaskState.Field <Int32>("TaskStateID")
select new TaskAssignment()
{
TaskAssignmentID = rowTaskAssignment.Field <Int32>("TaskAssignmentID")
, AssignmentDate = rowTaskAssignment.Field <DateTime>("AssignmentDate")
,
Task = new Task()
{
TaskID = rowTask.Field <Int32>("TaskID")
, TaskName = rowTask.Field <String>("TaskName")
}
,
Employee = new Employee()
{
EmployeeID = rowEmployee.Field <Int32>("EmployeeID")
, FirstName = rowEmployee.Field <String>("FirstName")
}
,
TaskState = new TaskState()
{
TaskStateID = rowTaskState.Field <Int32>("TaskStateID")
, TaskStateName = rowTaskState.Field <String>("TaskStateName")
}
};
switch (sortOrder)
{
case "TaskAssignmentID_desc":
Query = Query.OrderByDescending(s => s.TaskAssignmentID);
break;
case "TaskAssignmentID_asc":
Query = Query.OrderBy(s => s.TaskAssignmentID);
break;
case "AssignmentDate_desc":
Query = Query.OrderByDescending(s => s.AssignmentDate);
break;
case "AssignmentDate_asc":
Query = Query.OrderBy(s => s.AssignmentDate);
break;
case "TaskID_desc":
Query = Query.OrderByDescending(s => s.Task.TaskName);
break;
case "TaskID_asc":
Query = Query.OrderBy(s => s.Task.TaskName);
break;
case "EmployeeID_desc":
Query = Query.OrderByDescending(s => s.Employee.FirstName);
break;
case "EmployeeID_asc":
Query = Query.OrderBy(s => s.Employee.FirstName);
break;
case "TaskStateID_desc":
Query = Query.OrderByDescending(s => s.TaskState.TaskStateName);
break;
case "TaskStateID_asc":
Query = Query.OrderBy(s => s.TaskState.TaskStateName);
break;
default: // Name ascending
Query = Query.OrderBy(s => s.TaskAssignmentID);
break;
}
if (command == "Export")
{
GridView gv = new GridView();
DataTable dt = new DataTable();
dt.Columns.Add("Task Assignment I D", typeof(string));
dt.Columns.Add("Assignment Date", typeof(string));
dt.Columns.Add("Task I D", typeof(string));
dt.Columns.Add("Employee I D", typeof(string));
dt.Columns.Add("Task State I D", typeof(string));
foreach (var item in Query)
{
dt.Rows.Add(
item.TaskAssignmentID
, item.AssignmentDate
, item.Task.TaskName
, item.Employee.FirstName
, item.TaskState.TaskStateName
);
}
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))));
}