public void AddNewObjectData(ObjectCompleteDescription newData)
{
var sqlQuery = "INSERT INTO ObjectData (ObjectTypeId, ObjectId, ObjectPropertyId, ObjectName) "
+ "VALUES(@ObjectTypeId, @ObjectId, @ObjectPropertyId, @ObjectName)";
_db.Execute(sqlQuery, newData);
}
public ActionResult Delete(ObjectCompleteDescription value)
{
if (ModelState.IsValid)
{
_objectOperation.DeleteExistingObjectData(value);
return(RedirectToAction("Get"));
}
return(View(value));
}
public void DeleteExistingObjectData(ObjectCompleteDescription deletedData)
{
var sqlQuery =
"DELETE FROM ObjectData " +
"WHERE ObjectTypeId = @ObjectTypeId" +
"AND ObjectPropertyId = @ObjectPropertyId" +
"AND ObjectId = @ObjectId";
_db.Execute(sqlQuery, deletedData);
}
public void UpdateExistingObjectData(ObjectCompleteDescription updatedData)
{
var sqlQuery =
"UPDATE ObjectData " +
"SET ObjectName = @ObjectName " +
"WHERE ObjectTypeId = @ObjectTypeId" +
"AND ObjectPropertyId = @ObjectPropertyId" +
"AND ObjectId = @ObjectId";
_db.Execute(sqlQuery, updatedData);
}
