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