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