//Function DeleteEmployee(ByVal oEmployee As Employee) ' - deletes employee record //CRUD DELETE //POST a deletion to the db //error checking public string DeleteEmployee(TSEmployeeModel tsEmployee) { if (tsEmployee != null) { //create a new Employee-type object called oEmployee Employee oEmployee = new Employee(); //populate the DAL-object with the MVC object data oEmployee.EmployeeID = tsEmployee.EmployeeID; oEmployee.ShortEmployeeID = tsEmployee.ShortEmployeeID; oEmployee.EmployeeName = tsEmployee.EmployeeName; oEmployee.CostCtr = tsEmployee.CostCtr; oEmployee.CostCenter = tsEmployee.CostCenter; oEmployee.OrganizationalUnit = tsEmployee.OrganizationalUnit; oEmployee.EmployeeSubGroup = tsEmployee.EmployeeSubGroup; oEmployee.Job = tsEmployee.Job; oEmployee.PSubArea = tsEmployee.PSubArea; oEmployee.PersonnelSubArea = tsEmployee.PersonnelSubArea; oEmployee.EmployeeGroup = tsEmployee.EmployeeGroup; oEmployee.ActivityType = tsEmployee.ActivityType; oEmployee.WorkCenter = tsEmployee.WorkCenter; oEmployee.Active = tsEmployee.Active; //connect via interface to DAL App, and delete the object. The DAL parses out just the id, deleting the object with that id itsApp.DeleteEmployee(oEmployee); return("Employee Deleted Successfully"); } else { return("Employee Not Deleted! Try Again"); } }
//inserts/creates an Employee object in the DAL->db public string InsertEmployee(TSEmployeeModel tsEmployee) { //error checking. If any of the required values are null or 0, return a error message to AngularJS's backend, while will then create a pop-up rejection message //if the object has data, insert the data, else if there is no data just return a string if (tsEmployee != null && tsEmployee.EmployeeID != 0 //&& //tsEmployee.EmployeeName != null && //tsEmployee.CostCenter != null && //tsEmployee.CostCtr != null && //tsEmployee.OrganizationalUnit != null && //tsEmployee.EmployeeSubGroup != null && //tsEmployee.Job != null && //tsEmployee.PSubArea != null && //tsEmployee.PersonnelSubArea != null && //tsEmployee.EmployeeGroup != null ) { //create a new Employee-type object called oEmployee Employee oEmployee = new Employee(); //populate the DAL-object with the MVC object data oEmployee.EmployeeID = tsEmployee.EmployeeID; oEmployee.ShortEmployeeID = tsEmployee.ShortEmployeeID; oEmployee.EmployeeName = tsEmployee.EmployeeName; oEmployee.CostCtr = tsEmployee.CostCtr; oEmployee.CostCenter = tsEmployee.CostCenter; oEmployee.OrganizationalUnit = tsEmployee.OrganizationalUnit; oEmployee.EmployeeSubGroup = tsEmployee.EmployeeSubGroup; oEmployee.Job = tsEmployee.Job; oEmployee.PSubArea = tsEmployee.PSubArea; oEmployee.PersonnelSubArea = tsEmployee.PersonnelSubArea; oEmployee.EmployeeGroup = tsEmployee.EmployeeGroup; oEmployee.ActivityType = tsEmployee.ActivityType; oEmployee.WorkCenter = tsEmployee.WorkCenter; oEmployee.Active = tsEmployee.Active; //connect via interface to DAL App, and insert the object itsApp.InsertEmployee(oEmployee); return("Employee Added Successfully"); } else { return("Employee Not Inserted! Try Again"); } }
//GET and POST: /TSEmployee/GetEmployeesByEmployeeIDInactive //gets/reads inactive employee by their employee id public ActionResult GetEmployeesByEmployeeIDInactive(TSEmployeeModel tsEmployee) { if (tsEmployee.EmployeeID != 0) { //gets entries as Dataview //stores the first table EmployeesByEmployeeIDInactive = itsApp.GetEmployeesByEmployeeID(tsEmployee.EmployeeID).Tables[0].DefaultView; List <Dictionary <string, object> > parentRow = new List <Dictionary <string, object> >(); Dictionary <string, object> childRow; foreach (DataRow row in EmployeesByEmployeeIDInactive.Table.Rows) { childRow = new Dictionary <string, object>(); foreach (DataColumn col in EmployeesByEmployeeIDInactive.Table.Columns) { childRow.Add(col.ColumnName, row[col]); } parentRow.Add(childRow); } //takes the List, and filters through to data using LINQ to SQL format, //gets only the rows of data that have Activity labeled as "false" var employeeByIDFilteredByActiveFalse = from x in parentRow where x.Keys.Contains("Active") && x.Values.Contains(false) select x; //serializes/converts the DataView to JSON JavaScriptSerializer jsSerializer = new JavaScriptSerializer(); string JsSerializer = JsonConvert.SerializeObject(employeeByIDFilteredByActiveFalse); return(Json(JsSerializer, JsonRequestBehavior.AllowGet)); } else { return(Content("[]")); } }