private Gender GetParentGender() { return(new Gender { Id = (long)DBTransformer.GetOrDefault(this.SqlDataReader["ParentId"], 0), Name = DBTransformer.GetOrDefault(this.SqlDataReader["ParentName"], String.Empty), MediaType = new MediaTypeRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["ParentMediaType"], 0)), Status = new StatusRepository().FindStatusByCode(DBTransformer.GetOrDefault(this.SqlDataReader["ParentStatus"], String.Empty)), }); }
private FinalUser GetRowCasted(AbstractUser abstractUser) { return(new FinalUser(abstractUser) { ImageSource = DBTransformer.GetOrDefault(this.SqlDataReader["ImageSource"], ""), Telephone = DBTransformer.GetOrDefault(this.SqlDataReader["ImageSource"], null), ParentUser = new FinalUser() }); }
private Artist GetRowCasted(AbstractUser abstractUser) { return(new Artist(abstractUser) { Alias = DBTransformer.GetOrDefault(this.SqlDataReader["Alias"], ""), ImageSource = DBTransformer.GetOrDefault(this.SqlDataReader["ImageSource"], ""), Verified = DBTransformer.GetOrDefault(this.SqlDataReader["Verified"], false), ArtistType = new MediaTypeRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["MediaType"], 0)), Manager = new ManagerRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["Manager"], 0)) }); }
private Gender GetRowCasted() { //if (!this.SqlDataReader.HasRows) // return new Gender(); return(new Gender { Id = (long)DBTransformer.GetOrDefault(this.SqlDataReader["Id"], 0), Name = DBTransformer.GetOrDefault(this.SqlDataReader["Name"], String.Empty), MediaType = new MediaTypeRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["MediaType"], 0)), Status = new StatusRepository().FindStatusByCode(DBTransformer.GetOrDefault(this.SqlDataReader["Status"], String.Empty)), ParentGender = this.GetParentGender() }); }
private Album GetRowCasted() { return(new Album() { Id = DBTransformer.GetOrDefault(this.SqlDataReader["Id"], 0), Name = DBTransformer.GetOrDefault(this.SqlDataReader["Name"], ""), ImageSource = DBTransformer.GetOrDefault(this.SqlDataReader["ImageSource"], ""), RegisterDate = this.GetOrNull(this.SqlDataReader["RegisterDate"]), ModificationDate = this.GetOrNull(this.SqlDataReader["ModificationDate"]), Artist = new ArtistRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["Artist"], 0)), MediaType = new MediaTypeRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["MediaType"], 0)), Status = new StatusRepository().FindStatusByCode(this.SqlDataReader["Status"].ToString()), }); }
public int Add(AbstractMedia media) { try { String QueryTemplate = "INSERT INTO {0} (Album, Name, Gender, Category, Size, Source) VALUES ({1}, '{2}', {3}, {4}, '{5}', '{6}')"; String Query = String.Format(QueryTemplate, this.Table, media.Album.Id, media.Name, media.Gender.Id, media.Category.Id, media.Size, media.Source); this.ExecInsert(Query); this.SqlConnection.Close(); Query = String.Format("SELECT MAX(Id) AS Id FROM {0}", this.Table); this.ExecSelect(Query); this.SqlDataReader.Read(); return(DBTransformer.GetOrDefault(this.SqlDataReader["Id"], 0)); } catch (Exception ex) { throw ex; } finally { this.SqlConnection.Close(); } }
protected AbstractMedia GetRowCasted() { if (!this.SqlDataReader.HasRows) { throw new SqlParsedException(100); } return(new AbstractMedia { Id = int.Parse(this.SqlDataReader["Id"].ToString()), Name = this.SqlDataReader["Name"].ToString(), Rating = DBTransformer.GetOrDefault(this.SqlDataReader["Rating"], 0), Size = DBTransformer.GetOrDefault(this.SqlDataReader["Size"], "0"), ReproducedTimes = DBTransformer.GetOrDefault(this.SqlDataReader["ReproducedTimes"], 0), Source = DBTransformer.GetOrDefault(this.SqlDataReader["Source"], null), RegisterDate = this.GetOrNull(this.SqlDataReader["RegisterDate"]), Status = (new StatusRepository()).FindStatusByCode(this.SqlDataReader["Status"].ToString()), Album = new AlbumRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["Album"], 0)), Category = new CategoryRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["Category"], 0)), Gender = new GenderRepository().FindById(DBTransformer.GetOrDefault(this.SqlDataReader["Gender"], 0)) }); }
public int ExecInsert(String Query) { this.PrepareExec(Query); return(DBTransformer.GetOrDefault(this.SqlCommand.ExecuteScalar(), 0)); }