public void UpdateMediaAndPressInformation(MediaPress mediaPressItem) { const string sqlInsert = "Update CompanyCategoryContent set Title=@Title , Description=@Description ,ImageUrl=@ImageUrl where CompanyId = @CompanyId"; SqlParameter[] sqlParamArray = { new SqlParameter("@Title", SqlDbType.NVarChar) { Value = mediaPressItem.Title }, new SqlParameter("@Description", SqlDbType.NVarChar) { Value = mediaPressItem .Description }, new SqlParameter("@ImageUrl", SqlDbType.NVarChar) { Value = mediaPressItem .ImageUrl }, new SqlParameter("@CompanyId", SqlDbType.Int) { Value = Strings .Company .MediaPressCompanyId } }; sqlHelper.Cmd(sqlInsert, sqlParamArray); }
public MediaPress GetMediaAndPressInformation() { var rowMediaPress = sqlHelper.GetDataRow("select * from CompanyCategoryContent where CompanyId =" + Strings.Company.MediaPressCompanyId); var mediaPressInfo = new MediaPress() { Id = Convert.ToInt32(Strings.Company.MediaPressCompanyId), Description = rowMediaPress["Description"].ToString(), ImageUrl = rowMediaPress["ImageUrl"].ToString(), Title = rowMediaPress["Title"].ToString() }; return mediaPressInfo; }
public void UpdateMediaAndPressInformation(MediaPress mediaPressItem) { _companyRepository.UpdateMediaAndPressInformation(mediaPressItem); }