//CRUD UPDATE //POST an update to the db //error checking public string UpdateTSEntry(TSEntryModel tsEntry) { if (tsEntry != null) { //create a new oTSEntry object TimeSheetEntry oTSEntry = new TimeSheetEntry(); //populate the object with the object data from tsEntry oTSEntry.TSEntryID = tsEntry.TSEntryID; oTSEntry.EntryDate = tsEntry.Date; oTSEntry.EmployeeID = tsEntry.EmployeeID; oTSEntry.ProdZoneID = tsEntry.ProdZoneID; oTSEntry.StartTime = tsEntry.StartTime; oTSEntry.EndTime = tsEntry.EndTime; oTSEntry.EquipmentMeterReading = tsEntry.EquipmentMeterReading; oTSEntry.EquipmentNumber = tsEntry.EquipmentNumber; oTSEntry.ImplementNumber = tsEntry.ImplementNumber; oTSEntry.TaskWOID = tsEntry.Task_WO_ID; oTSEntry.FieldNumber = tsEntry.FieldNumber; //connect via interface to DAL App, and update the ts entry as an object itsApp.UpdateTSEntry(oTSEntry); return("Entry Updated Successfully"); } else { return("Entry Not Updated! Try Again"); } }
//CRUD DELETE //POST a deletion to the db //error checking public string DeleteTSEntry(TSEntryModel tsEntry) { if (tsEntry != null) { //create a new oTSEntry object TimeSheetEntry oTSEntry = new TimeSheetEntry(); //populate the object with the object data from tsEntry oTSEntry.TSEntryID = tsEntry.TSEntryID; oTSEntry.EntryDate = tsEntry.Date; oTSEntry.EmployeeID = tsEntry.EmployeeID; oTSEntry.ProdZoneID = tsEntry.ProdZoneID; oTSEntry.StartTime = tsEntry.StartTime; oTSEntry.EndTime = tsEntry.EndTime; oTSEntry.EquipmentMeterReading = tsEntry.EquipmentMeterReading; oTSEntry.EquipmentNumber = tsEntry.EquipmentNumber; oTSEntry.ImplementNumber = tsEntry.ImplementNumber; oTSEntry.TaskWOID = tsEntry.Task_WO_ID; oTSEntry.FieldNumber = tsEntry.FieldNumber; //connect via interface to DAL App, and delete the ts entry as an object. The DAL parses out just the tsEntry.TSEntryID, and removed the entry by it's particular id/insertion order itsApp.DeleteTSEntry(oTSEntry); return("Entry Deleted Successfully"); } else { return("Entry Not Deleted! Try Again"); } }
//gets/reads all an employees timesheet entries by their date public ActionResult GetTimeSheetEntriesByDate(TSEntryModel tsEntry) { //gets entries as Dataview itsApp.GetTimeSheetEntriesByDate(tsEntry.Date); EntriesByDate = itsApp.dvTimeSheetEntriesByDate(); //serializes/converts the DataView to JSON JavaScriptSerializer jsSerializer = new JavaScriptSerializer(); List <Dictionary <string, object> > parentRow = new List <Dictionary <string, object> >(); Dictionary <string, object> childRow; foreach (DataRow row in EntriesByDate.Table.Rows) { childRow = new Dictionary <string, object>(); foreach (DataColumn col in EntriesByDate.Table.Columns) { childRow.Add(col.ColumnName, row[col]); } parentRow.Add(childRow); } string JsSerializer = JsonConvert.SerializeObject(parentRow); return(Json(JsSerializer, JsonRequestBehavior.AllowGet)); }