public int UpdateObject(Db_objects marker) { int res = 0; res = this.ExecuteSQL("update db_objects set address=@address, [identity]=@identity where objectId=@objectId", marker); return(res); }
public Db_objects GetObjectByIdentity(string identity) { Db_objects marker = null; marker = this.GetItemData <Db_objects>(sql_objects_select + " where [identity]=@identity_", new { identity_ = identity }); return(marker); }
public Db_objects GetObjectById(int id) { Db_objects marker = null; marker = this.GetItemData <Db_objects>(sql_objects_select + " where objectId=@id_", new { id_ = id }); return(marker); }
public int InsertObject(Db_objects marker) { int res = this.GetItemData <int>("insert into db_objects (address, [identity]) values(@address,@identity); SELECT SCOPE_IDENTITY();", marker); return(res); }