//inserts/creates an Equipment object in the DAL->db public string InsertEquipment(TSEquipmentModel tsEquipment) { //if the object has data, insert the data, else if there is no data just return a string if (tsEquipment != null) { //create a new Equipment-type object called oEquipment Equipment oEquipment = new Equipment(); //populate the DAL-object with the MVC object data oEquipment.EquipmentNumber = tsEquipment.EquipmentNumber; oEquipment.TechID = tsEquipment.TechID; oEquipment.CostCenter = tsEquipment.CostCenter; oEquipment.EquipDesc = tsEquipment.EquipDescription; oEquipment.EquipmentNumber = tsEquipment.EquipmentNumber; oEquipment.EquipType = tsEquipment.EquipType; oEquipment.UserStatus = tsEquipment.UserStatus; oEquipment.Active = tsEquipment.Active; oEquipment.FunctionalLocation = tsEquipment.FunctionalLocation; oEquipment.FunctionalLocationDesc = tsEquipment.FuncLocDescription; oEquipment.EquipClass = tsEquipment.EquipClass; oEquipment.WorkCenter = tsEquipment.WorkCenter; oEquipment.ActivityType = tsEquipment.ActivityType; oEquipment.MeasurementPoint = tsEquipment.MeasurementPoint; oEquipment.EorI = tsEquipment.EquipmentOrImplement; //connect via interface to DAL App, and insert the object itsApp.InsertEquipment(oEquipment); return("Equipment Added Successfully"); } else { return("Equipment Not Inserted! Try Again"); } }
//CRUD DELETE //POST a deletion to the db //error checking public string DeleteEquipment(TSEquipmentModel tsEquipment) { if (tsEquipment != null) { //create a new Equipment-type object called oEquipment Equipment oEquipment = new Equipment(); //populate the DAL-object with the MVC object data oEquipment.EquipmentNumber = tsEquipment.EquipmentNumber; oEquipment.TechID = tsEquipment.TechID; oEquipment.CostCenter = tsEquipment.CostCenter; oEquipment.EquipDesc = tsEquipment.EquipDescription; oEquipment.EquipmentNumber = tsEquipment.EquipmentNumber; oEquipment.EquipType = tsEquipment.EquipType; oEquipment.UserStatus = tsEquipment.UserStatus; oEquipment.Active = tsEquipment.Active; oEquipment.FunctionalLocation = tsEquipment.FunctionalLocation; oEquipment.FunctionalLocationDesc = tsEquipment.FuncLocDescription; oEquipment.EquipClass = tsEquipment.EquipClass; oEquipment.WorkCenter = tsEquipment.WorkCenter; oEquipment.ActivityType = tsEquipment.ActivityType; oEquipment.MeasurementPoint = tsEquipment.MeasurementPoint; oEquipment.EorI = tsEquipment.EquipmentOrImplement; //connect via interface to DAL App, and delete the object. The DAL parses out just the equipment number, deleting the object with that number itsApp.DeleteEquipment(oEquipment); return("Equipment Deleted Successfully"); } else { return("Equipment Not Deleted! Try Again"); } }
//gets/reads equipment by their id/equipmentnumber public ActionResult GetEquipmentByEquipmentNumber(TSEquipmentModel tsEquipment) { //gets entries as Dataview //stores the first table EquipmentByNumber = itsApp.GetEquipmentByEquipmentNumber(tsEquipment.EquipmentNumber).Tables[0].DefaultView; //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 EquipmentByNumber.Table.Rows) { childRow = new Dictionary <string, object>(); foreach (DataColumn col in EquipmentByNumber.Table.Columns) { childRow.Add(col.ColumnName, row[col]); } parentRow.Add(childRow); } string JsSerializer = JsonConvert.SerializeObject(parentRow); return(Json(JsSerializer, JsonRequestBehavior.AllowGet)); }