//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));
}
