private Collective.OfferTranslation GetOfferTranslation()
{
if (_offerTranslation == null)
{
int langid;
if (Int32.TryParse(Request.QueryString["langid"], out langid) && GetOffer() != null)
{
_offerTranslation = Collective.OfferTranslation.GetOfferTranslation(GetOffer().OfferId, langid);
}
}
return _offerTranslation;
}
public void SetClientData(int langId)
{
using (SqlConnection con = new SqlConnection(PutovalicaUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand()
{
Connection = con,
CommandType = CommandType.StoredProcedure,
CommandText = "Collective_SetOfferClientData"
})
{
cmd.Parameters.Add(new SqlParameter("@OfferId", SqlDbType.Int, 4) { Value = this.OfferId });
cmd.Parameters.Add(new SqlParameter("@Langid", SqlDbType.Int, 4) { Value = langId });
SqlParameter parFirstImgSrc = new SqlParameter("@FirstImgSrc", SqlDbType.NVarChar, 1000) { Direction = ParameterDirection.Output };
SqlParameter parOfferTitle = new SqlParameter("@OfferTitle", SqlDbType.NVarChar, 250) { Direction = ParameterDirection.Output };
SqlParameter parContentShort = new SqlParameter("@ContentShort", SqlDbType.NVarChar, 1000) { Direction = ParameterDirection.Output };
SqlParameter parContentText = new SqlParameter("@ContentText", SqlDbType.NVarChar, -1) { Direction = ParameterDirection.Output };
SqlParameter parReservationText = new SqlParameter("@ReservationText", SqlDbType.NVarChar, -1) { Direction = ParameterDirection.Output };
SqlParameter parMetaDesc = new SqlParameter("@MetaDesc", SqlDbType.NVarChar, 1000) { Direction = ParameterDirection.Output };
SqlParameter parMetaKW = new SqlParameter("@MetaKeywords", SqlDbType.NVarChar, 1000) { Direction = ParameterDirection.Output };
SqlParameter parUrlTag = new SqlParameter("@UrlTag", SqlDbType.NVarChar, 250) { Direction = ParameterDirection.Output };
SqlParameter parCurrencySymbol = new SqlParameter("@CurrencySymbol", SqlDbType.NVarChar, 5) { Direction = ParameterDirection.Output };
cmd.Parameters.Add(parFirstImgSrc);
cmd.Parameters.Add(parOfferTitle);
cmd.Parameters.Add(parContentShort);
cmd.Parameters.Add(parContentText);
cmd.Parameters.Add(parReservationText);
cmd.Parameters.Add(parMetaDesc);
cmd.Parameters.Add(parMetaKW);
cmd.Parameters.Add(parUrlTag);
cmd.Parameters.Add(parCurrencySymbol);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
this.FirstImgSrc = parFirstImgSrc.Value != DBNull.Value ? parFirstImgSrc.Value.ToString() : null;
this.Translation = new OfferTranslation(this.OfferId, langId,
parOfferTitle.Value != DBNull.Value ? parOfferTitle.Value.ToString() : null,
parContentShort.Value != DBNull.Value ? parContentShort.Value.ToString() : null,
parContentText.Value != DBNull.Value ? parContentText.Value.ToString() : null,
parReservationText.Value != DBNull.Value ? parReservationText.Value.ToString() : null,
parMetaDesc.Value != DBNull.Value ? parMetaDesc.Value.ToString() : null,
parMetaKW.Value != DBNull.Value ? parMetaKW.Value.ToString() : null,
parUrlTag.Value.ToString());
this.CurrencySymbol = parCurrencySymbol.Value != DBNull.Value ? parCurrencySymbol.Value.ToString() : null;
this.IsClientDataSet = true;
}
}
}
