public ActionResult Edit(ProjectAssignment ProjectAssignment)
{
ProjectAssignment oProjectAssignment = new ProjectAssignment();
oProjectAssignment.ProjectAssignmentID = System.Convert.ToInt32(ProjectAssignment.ProjectAssignmentID);
oProjectAssignment = ProjectAssignmentData.Select_Record(ProjectAssignment);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = ProjectAssignmentData.Update(oProjectAssignment, ProjectAssignment);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
// ComboBox
ViewData["ProjectID"] = new SelectList(ProjectAssignment_ProjectData.List(), "ProjectID", "ProjectName", ProjectAssignment.ProjectID);
ViewData["EmployeeID"] = new SelectList(ProjectAssignment_EmployeeData.List(), "EmployeeID", "FirstName", ProjectAssignment.EmployeeID);
return(View(ProjectAssignment));
}
// GET: /ProjectAssignment/Edit/<id>
public ActionResult Edit(
Int32?ProjectAssignmentID
)
{
if (
ProjectAssignmentID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProjectAssignment ProjectAssignment = new ProjectAssignment();
ProjectAssignment.ProjectAssignmentID = System.Convert.ToInt32(ProjectAssignmentID);
ProjectAssignment = ProjectAssignmentData.Select_Record(ProjectAssignment);
if (ProjectAssignment == null)
{
return(HttpNotFound());
}
// ComboBox
ViewData["ProjectID"] = new SelectList(ProjectAssignment_ProjectData.List(), "ProjectID", "ProjectName", ProjectAssignment.ProjectID);
ViewData["EmployeeID"] = new SelectList(ProjectAssignment_EmployeeData.List(), "EmployeeID", "FirstName", ProjectAssignment.EmployeeID);
return(View(ProjectAssignment));
}
public ActionResult Create([Bind(Include =
"ProjectID"
+ "," + "EmployeeID"
+ "," + "AssignmentDate"
+ "," + "Remarks"
+ "," + "AddUserID"
+ "," + "AddDate"
+ "," + "ArchiveUserID"
+ "," + "ArchiveDate"
)] ProjectAssignment ProjectAssignment)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = ProjectAssignmentData.Add(ProjectAssignment);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["ProjectID"] = new SelectList(ProjectAssignment_ProjectData.List(), "ProjectID", "ProjectName", ProjectAssignment.ProjectID);
ViewData["EmployeeID"] = new SelectList(ProjectAssignment_EmployeeData.List(), "EmployeeID", "FirstName", ProjectAssignment.EmployeeID);
return(View(ProjectAssignment));
}
public ActionResult DeleteConfirmed(
Int32?ProjectAssignmentID
)
{
ProjectAssignment ProjectAssignment = new ProjectAssignment();
ProjectAssignment.ProjectAssignmentID = System.Convert.ToInt32(ProjectAssignmentID);
ProjectAssignment = ProjectAssignmentData.Select_Record(ProjectAssignment);
bool bSucess = false;
bSucess = ProjectAssignmentData.Delete(ProjectAssignment);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
// GET: /ProjectAssignment/Delete/<id>
public ActionResult Delete(
Int32?ProjectAssignmentID
)
{
if (
ProjectAssignmentID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dtProject = ProjectAssignment_ProjectData.SelectAll();
dtEmployee = ProjectAssignment_EmployeeData.SelectAll();
ProjectAssignment ProjectAssignment = new ProjectAssignment();
ProjectAssignment.ProjectAssignmentID = System.Convert.ToInt32(ProjectAssignmentID);
ProjectAssignment = ProjectAssignmentData.Select_Record(ProjectAssignment);
ProjectAssignment.Project = new Project()
{
ProjectID = (Int32)ProjectAssignment.ProjectID
, ProjectName = (from DataRow rowProject in dtProject.Rows
where ProjectAssignment.ProjectID == (int)rowProject["ProjectID"]
select(String) rowProject["ProjectName"]).FirstOrDefault()
};
ProjectAssignment.Employee = new Employee()
{
EmployeeID = (Int32)ProjectAssignment.EmployeeID
, FirstName = (from DataRow rowEmployee in dtEmployee.Rows
where ProjectAssignment.EmployeeID == (int)rowEmployee["EmployeeID"]
select(String) rowEmployee["FirstName"]).FirstOrDefault()
};
if (ProjectAssignment == null)
{
return(HttpNotFound());
}
return(View(ProjectAssignment));
}
// GET: /ProjectAssignment/
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 ? "Project 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["ProjectAssignmentIDSortParm"] = sortOrder == "ProjectAssignmentID_asc" ? "ProjectAssignmentID_desc" : "ProjectAssignmentID_asc";
ViewData["ProjectIDSortParm"] = sortOrder == "ProjectID_asc" ? "ProjectID_desc" : "ProjectID_asc";
ViewData["EmployeeIDSortParm"] = sortOrder == "EmployeeID_asc" ? "EmployeeID_desc" : "EmployeeID_asc";
ViewData["AssignmentDateSortParm"] = sortOrder == "AssignmentDate_asc" ? "AssignmentDate_desc" : "AssignmentDate_asc";
ViewData["RemarksSortParm"] = sortOrder == "Remarks_asc" ? "Remarks_desc" : "Remarks_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";
dtProjectAssignment = ProjectAssignmentData.SelectAll();
dtProject = ProjectAssignment_ProjectData.SelectAll();
dtEmployee = ProjectAssignment_EmployeeData.SelectAll();
try
{
if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"])))
{
dtProjectAssignment = ProjectAssignmentData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"]));
}
}
catch { }
var Query = from rowProjectAssignment in dtProjectAssignment.AsEnumerable()
join rowProject in dtProject.AsEnumerable() on rowProjectAssignment.Field <Int32>("ProjectID") equals rowProject.Field <Int32>("ProjectID")
join rowEmployee in dtEmployee.AsEnumerable() on rowProjectAssignment.Field <Int32>("EmployeeID") equals rowEmployee.Field <Int32>("EmployeeID")
select new ProjectAssignment()
{
ProjectAssignmentID = rowProjectAssignment.Field <Int32>("ProjectAssignmentID")
,
Project = new Project()
{
ProjectID = rowProject.Field <Int32>("ProjectID")
, ProjectName = rowProject.Field <String>("ProjectName")
}
,
Employee = new Employee()
{
EmployeeID = rowEmployee.Field <Int32>("EmployeeID")
, FirstName = rowEmployee.Field <String>("FirstName")
}
, AssignmentDate = rowProjectAssignment.Field <DateTime>("AssignmentDate")
, Remarks = rowProjectAssignment.Field <String>("Remarks")
, AddUserID = rowProjectAssignment.Field <Int32>("AddUserID")
, AddDate = rowProjectAssignment.Field <DateTime>("AddDate")
, ArchiveUserID = rowProjectAssignment.Field <Int32?>("ArchiveUserID")
, ArchiveDate = rowProjectAssignment.Field <DateTime?>("ArchiveDate")
};
switch (sortOrder)
{
case "ProjectAssignmentID_desc":
Query = Query.OrderByDescending(s => s.ProjectAssignmentID);
break;
case "ProjectAssignmentID_asc":
Query = Query.OrderBy(s => s.ProjectAssignmentID);
break;
case "ProjectID_desc":
Query = Query.OrderByDescending(s => s.Project.ProjectName);
break;
case "ProjectID_asc":
Query = Query.OrderBy(s => s.Project.ProjectName);
break;
case "EmployeeID_desc":
Query = Query.OrderByDescending(s => s.Employee.FirstName);
break;
case "EmployeeID_asc":
Query = Query.OrderBy(s => s.Employee.FirstName);
break;
case "AssignmentDate_desc":
Query = Query.OrderByDescending(s => s.AssignmentDate);
break;
case "AssignmentDate_asc":
Query = Query.OrderBy(s => s.AssignmentDate);
break;
case "Remarks_desc":
Query = Query.OrderByDescending(s => s.Remarks);
break;
case "Remarks_asc":
Query = Query.OrderBy(s => s.Remarks);
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.ProjectAssignmentID);
break;
}
if (command == "Export")
{
GridView gv = new GridView();
DataTable dt = new DataTable();
dt.Columns.Add("Project Assignment I D", typeof(string));
dt.Columns.Add("Project I D", typeof(string));
dt.Columns.Add("Employee I D", typeof(string));
dt.Columns.Add("Assignment Date", typeof(string));
dt.Columns.Add("Remarks", 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.ProjectAssignmentID
, item.Project.ProjectName
, item.Employee.FirstName
, item.AssignmentDate
, item.Remarks
, 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))));
}