/// <summary>
/// 업체 수정
/// </summary>
/// <param name="carCategoryCode"></param>
/// <param name="codeName"></param>
/// <returns></returns>
public int updateCompany(CompanyInfo company)
{
log.Debug("=================START updateCompany=================");
log.Debug("company = " + company.ToString());
StringBuilder sql_update = new StringBuilder();
sql_update.Append("UPDATE Company SET");
sql_update.Append(" companyName=N'" + company.CompanyName + "',");
sql_update.Append("regNumber1='" + company.RegNumber1 + "',");
sql_update.Append("regNumber2='" + company.RegNumber2 + "',");
sql_update.Append("regNumber3='" + company.RegNumber3 + "',");
sql_update.Append("phone1='" + company.Phone1 + "',");
sql_update.Append("phone2='" + company.Phone2 + "',");
sql_update.Append("phone3='" + company.Phone3 + "',");
sql_update.Append("masterName=N'" + company.MasterName + "',");
sql_update.Append("approve=N'" + company.Approve + "',");
sql_update.Append("address=N'" + company.Address + "',");
sql_update.Append("companyManagementNo=N'" + company.CompanyManagementNo + "',");
sql_update.Append("companyStartNo=N'" + company.CompanyStartNo + "'");
sql_update.Append("WHERE companyCode="+ company.CompanyCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);
log.Debug(@"=================END updateCompany=================");
return(result);
}
/// <summary>
/// 업체 저장
/// </summary>
/// <param name="codeName"></param>
/// <returns></returns>
public int insertCompany(CompanyInfo company)
{
log.Debug("=================START insertCompany=================");
log.Debug("company = " + company.ToString());
StringBuilder sql_insert = new StringBuilder();
sql_insert.Append("INSERT INTO Company");
sql_insert.Append("(companyName,regNumber1,regNumber2,regNumber3,phone1,phone2,phone3,masterName,address,regDate,approve,employeeCode,companyManagementNo,companyStartNo)");
sql_insert.Append("VALUES");
sql_insert.Append("(N'" + company.CompanyName + "','" + company.RegNumber1 + "','" + company.RegNumber2 + "','" + company.RegNumber3 + "',");
sql_insert.Append("'" + company.Phone1 + "','" + company.Phone2 + "','" + company.Phone3 + "',N'" + company.MasterName + "',N'" + company.Address + "',");
sql_insert.Append("GETDATE()," + company.Approve + ",'" + company.EmployeeCode + "',N'" + company.CompanyManagementNo + "',N'" + company.CompanyStartNo + "')");
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_insert.ToString(), null);
log.Debug(@"=================END insertCompany=================");
return(result);
}
public override async Task <bool> UpdateFromOnlineMusicTrackAlbumCompanyAsync(AlbumInfo album, CompanyInfo company, string language, bool cacheOnly)
{
try
{
AudioDbAlbum albumDetail = null;
language = language ?? PreferredLanguage;
if (album.AudioDbId > 0)
{
albumDetail = await _audioDbHandler.GetAlbumAsync(album.AudioDbId, language, cacheOnly).ConfigureAwait(false);
}
if (albumDetail == null && !string.IsNullOrEmpty(album.MusicBrainzId))
{
List <AudioDbAlbum> foundAlbums = await _audioDbHandler.GetAlbumByMbidAsync(album.MusicBrainzId, language, cacheOnly).ConfigureAwait(false);
if (foundAlbums != null && foundAlbums.Count == 1)
{
//Get the album into the cache
albumDetail = await _audioDbHandler.GetAlbumAsync(foundAlbums[0].AlbumId, language, cacheOnly).ConfigureAwait(false);
}
}
if (albumDetail == null)
{
return(false);
}
if (!string.IsNullOrEmpty(albumDetail.Label) && company.MatchNames(company.Name, albumDetail.Label) && albumDetail.LabelId.HasValue)
{
company.AudioDbId = albumDetail.LabelId.Value;
company.Name = albumDetail.Label;
company.Type = CompanyAspect.COMPANY_MUSIC_LABEL;
return(true);
}
return(false);
}
catch (Exception ex)
{
ServiceRegistration.Get <ILogger>().Debug("TheAudioDbWrapper: Exception while processing company {0}", ex, company.ToString());
return(false);
}
}
public override async Task <bool> UpdateFromOnlineMusicTrackAlbumCompanyAsync(AlbumInfo album, CompanyInfo company, string language, bool cacheOnly)
{
try
{
TrackLabel labelDetail = null;
if (!string.IsNullOrEmpty(company.MusicBrainzId))
{
labelDetail = await _musicBrainzHandler.GetLabelAsync(company.MusicBrainzId, cacheOnly).ConfigureAwait(false);
}
if (labelDetail == null)
{
return(false);
}
if (labelDetail.Label == null)
{
return(false);
}
company.MusicBrainzId = labelDetail.Label.Id;
company.Name = labelDetail.Label.Name;
company.Type = CompanyAspect.COMPANY_MUSIC_LABEL;
return(true);
}
catch (Exception ex)
{
ServiceRegistration.Get <ILogger>().Debug("MusicBrainzWrapper: Exception while processing company {0}", ex, company.ToString());
return(false);
}
}
public override async Task <bool> UpdateFromOnlineSeriesCompanyAsync(SeriesInfo seriesInfo, CompanyInfo company, TvdbLanguage language, bool cacheOnly)
{
try
{
if (company.Type != CompanyAspect.COMPANY_TV_NETWORK)
{
return(false);
}
language = language ?? PreferredLanguage;
TvdbSeries seriesDetail = null;
if (seriesInfo.TvdbId > 0)
{
seriesDetail = await _tvdbHandler.GetSeriesAsync(seriesInfo.TvdbId, language, true, false, false).ConfigureAwait(false);
}
if (seriesDetail == null && !cacheOnly && !string.IsNullOrEmpty(seriesInfo.ImdbId))
{
TvdbSearchResult foundSeries = await _tvdbHandler.GetSeriesByRemoteIdAsync(ExternalId.ImdbId, seriesInfo.ImdbId).ConfigureAwait(false);
if (foundSeries != null)
{
seriesDetail = await _tvdbHandler.GetSeriesAsync(foundSeries.Id, language, true, false, false).ConfigureAwait(false);
}
}
if (seriesDetail == null)
{
return(false);
}
List <CompanyInfo> companies = ConvertToCompanies(seriesDetail.NetworkID, seriesDetail.Network, CompanyAspect.COMPANY_TV_NETWORK);
int index = companies.IndexOf(company);
if (index >= 0)
{
company.TvdbId = companies[index].TvdbId;
company.Name = companies[index].Name;
company.Type = companies[index].Type;
company.Order = companies[index].Order;
return(true);
}
return(false);
}
catch (Exception ex)
{
ServiceRegistration.Get <ILogger>().Debug("TvDbWrapper: Exception while processing company {0}", ex, company.ToString());
return(false);
}
}