public void UpdateMissionInformation(Mission missionItem) { try { const string sqlInsert = "Update CompanyCategoryContent set Title=@Title , Description=@Description ,ImageUrl=@ImageUrl where CompanyId = @CompanyId"; SqlParameter[] sqlParamArray = { new SqlParameter("@Title", SqlDbType.NVarChar) { Value = missionItem.Title }, new SqlParameter("@Description", SqlDbType.NVarChar) { Value = missionItem .Description }, new SqlParameter("@ImageUrl", SqlDbType.NVarChar) { Value = missionItem .ImageUrl }, new SqlParameter("@CompanyId", SqlDbType.Int) { Value = Strings .Company .MissionCompanyId } }; sqlHelper.Cmd(sqlInsert, sqlParamArray); } catch (Exception exception) { } }
public Mission GetMissionInformation() { var dataRowMission = sqlHelper.GetDataRow("select * from CompanyCategoryContent where CompanyId =" + Strings.Company.MissionCompanyId); var missionInfo = new Mission { Id = Convert.ToInt32(Strings.Company.MissionCompanyId), Description = dataRowMission["Description"].ToString(), ImageUrl = dataRowMission["ImageUrl"].ToString(), Title = dataRowMission["Title"].ToString() }; return missionInfo; }
public void UpdateMissionInformation(Mission missionItem) { _companyRepository.UpdateMissionInformation(missionItem); }