public void Initialize(OmnitureDto omniture, QuestionnaireDto quesitonnaire, PageDto page)
{
_omniture = omniture;
_questionnaire = quesitonnaire;
_page = page;
Load += new EventHandler(WucMetaBase_Load);
}
//private List<KeyValuePair<PageElementDto, List<PageElementChoiceDto>>> _elements;
//public List<KeyValuePair<PageElementDto, List<PageElementChoiceDto>>> Elements
//{
// get { return _elements; }
// set { _elements = value; }
//}
public PageAssemblyDto(QuestionnaireDto questionnaire, PageDto page, OmnitureDto omniture, List<PageElementAssemblyDto> elements, List<PagePredefinedQuestionAssemblyDto> predefinedQuestions)
{
if (questionnaire == null || page == null || omniture == null || elements == null)
{
throw new ArgumentNullException("PageAssemblyDto requires all parameters to be not null");
}
_questionnaire = questionnaire;
_page = page;
_omniture = omniture;
_elements = elements;
_predeinedQuestions = predefinedQuestions;
}
public void TestOmnitureMergeGetMergeDelete()
{
OmnitureDto dto = new OmnitureDto(_currentQuestionnaire.QuestionnaireId, "pagename fp", "pagename cp", "pagename lp", "pagename pp", "pagename rp", "pagename uf", "pagename uc", 22, "sales", 24, "products", "prop2 add", "prop3 fp", "prop3 cp", "prop3 lp", "prop3 pp", "prop2 rp", "prop3 uf", "prop3 uc", 44, "hho", 37, "ipg", false,false); //RFG 2.20
OmnitureDto pers = FormRegistry.OmnitureDao.Merge(dto);
Assert.IsNotNull(pers);
Assert.IsTrue(dto.Equals(pers, true));
OmnitureDto sel1 = FormRegistry.OmnitureDao.Get(_currentQuestionnaire.QuestionnaireId, ViewType.CleanSheetOverlay);
Assert.IsNotNull(sel1);
Assert.AreEqual(typeof(OmnitureDto), sel1.GetType());
Assert.IsNotNull(pers);
Assert.IsNotNull(sel1);
OmnitureDto sel2 = FormRegistry.OmnitureDao.Get(_currentQuestionnaire.QuestionnaireId, ViewType.CleanSheetOverlay);
sel2.OmniPagenameFp = "OmniPagenameFp";
sel2.OmniPagenameCp = "OmniPagenameCp";
sel2.OmniPagenameLp = "OmniPagenameLp";
sel2.OmniPagenamePp = "OmniPagenamePp";
sel2.OmniPagenameRp = "OmniPagenameRp";
sel2.OmniPagenameUf = "OmniPagenameUf";
sel2.OmniPagenameUc = "OmniPagenameUc";
sel2.OmniProp1Fk = 21;
sel2.OmniProp1 = "pre sales";
sel2.OmniProp2Fk = 25;
sel2.OmniProp2 = "services";
sel2.OmniProp2Add = "OmniProp2Add";
sel2.OmniProp3Fp = "OmniProp3Fp";
sel2.OmniProp3Cp = "OmniProp3Cp";
sel2.OmniProp3Lp = "OmniProp3Lp";
sel2.OmniProp3Pp = "OmniProp3Pp";
sel2.OmniProp3Rp = "OmniProp3Rp";
sel2.OmniProp3Uf = "OmniProp3Uf";
sel2.OmniProp3Uc = "OmniProp3Uc";
sel2.OmniProp9Fk = 45;
sel2.OmniProp9 = "hho";
sel2.OmniProp16Fk = 38;
sel2.OmniProp16 = "psg";
sel2.OmniEvent8 = true;
sel2.OmniEvent3 = true;
pers = FormRegistry.OmnitureDao.Merge(sel2);
Assert.IsNotNull(pers);
Assert.IsFalse(sel1.Equals(pers, true));
//sel2 = FormRegistry.OmnitureDao.Get(_currentQuestionnaire.QuestionnaireId);
Assert.IsNotNull(sel2);
Assert.IsTrue(sel2.Equals(pers, true));
Assert.AreEqual(typeof(OmnitureDto), sel2.GetType());
Assert.AreEqual(pers, sel2);
Assert.IsTrue(FormRegistry.OmnitureDao.Delete(_currentQuestionnaire.QuestionnaireId));
sel2 = FormRegistry.OmnitureDao.Get(_currentQuestionnaire.QuestionnaireId, ViewType.CleanSheetOverlay);
Assert.IsNull(sel2);
}
public OmnitureDto Merge(OmnitureDto dto)
{
OmnitureDto retval = null;
DbCommand sp = null;
DbConnection connection = null;
IDataReader reader = null;
try
{
connection = _dbLayer.GetConnection();
sp = connection.CreateCommand();
sp.CommandText = "rfg_Omniture_Merge";
sp.CommandType = CommandType.StoredProcedure;
Write(sp, dto);
_dbLayer.AddReturnParameter(sp);
sp.ExecuteNonQuery();
int code = _dbLayer.GetReturnValue(sp);
if (code < 0)
{
Trace.WriteLine("OmnitureDao.Merge(" + dto + "): returned " + code);
//throw new SupportRequiredException(??);
throw new Exception(code.ToString());
}
retval = new OmnitureDto(
dto.QuestionnaireFk,
dto.OmniPagenameFp,
dto.OmniPagenameCp,
dto.OmniPagenameLp,
dto.OmniPagenamePp,
dto.OmniPagenameRp,
dto.OmniPagenameUf,
dto.OmniPagenameUc,
dto.OmniProp1Fk,
dto.OmniProp1,
dto.OmniProp2Fk,
dto.OmniProp2,
dto.OmniProp2Add,
dto.OmniProp3Fp,
dto.OmniProp3Cp,
dto.OmniProp3Lp,
dto.OmniProp3Pp,
dto.OmniProp3Rp,
dto.OmniProp3Uf,
dto.OmniProp3Uc,
dto.OmniProp9Fk,
dto.OmniProp9,
dto.OmniProp16Fk,
dto.OmniProp16,
dto.OmniEvent8,
dto.OmniEvent3
);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
if (sp != null)
sp.Dispose();
if (connection != null)
{
_dbLayer.ReturnConnection(connection);
}
else
{
_dbLayer.ReturnConnection(connection, true);
}
}
return retval;
}
private OmnitureDto Read(IDataReader reader, ref bool alreadyRead, ViewType viewType)
{
OmnitureDto retval = null;
int questionnaireFk = reader.GetInt32(0);
string omniPagenameFp = GetString(reader, 1);
string omniPagenameCp = GetString(reader, 2);
string omniPagenameLp = GetString(reader, 3);
string omniPagenamePp = GetString(reader, 4);
string omniPagenameRp = GetString(reader, 5);
string omniPagenameUf = GetString(reader, 6);
string omniPagenameUc = GetString(reader, 7);
int? omniProp1Fk = GetInt32(reader, 8);
string omniProp1 = GetString(reader, 9);
int? omniProp2Fk = GetInt32(reader, 10);
string omniProp2 = GetString(reader, 11);
string omniProp2Add = GetString(reader, 12);
string omniProp3Fp = GetString(reader, 13);
string omniProp3Cp = GetString(reader, 14);
string omniProp3Lp = GetString(reader, 15);
string omniProp3Pp = GetString(reader, 16);
string omniProp3Rp = GetString(reader, 17);
string omniProp3Uf = GetString(reader, 18);
string omniProp3Uc = GetString(reader, 19);
int? omniProp9Fk = GetInt32(reader, 20);
string omniProp9 = null;
//TODO: check and (if necessary) change omniProp9 for Standalone design
if(viewType == ViewType.CleanSheetOverlay ||
viewType == ViewType.CleanSheetStandalone ||
viewType == ViewType.Processor ||
viewType == ViewType.WebService)
omniProp9 = GetString(reader, 21);
else
omniProp9 = FormRegistry.QuestionnaireDao.GetMetaCS(GetString(reader, 21), omniProp9Fk, Migration.ConvertPageTagCheatTypeToString(PageTagCheatType.Classic));
int? omniProp16Fk = GetInt32(reader, 22);
string omniProp16 = GetString(reader, 23);
bool omniEvent8 = false;
if (GetBoolean(reader, 24).HasValue) // RFG 2.20
{
omniEvent8 = GetBoolean(reader, 24).Value;
}
bool omniEvent3 = false;
if (GetBoolean(reader, 25).HasValue)
{
omniEvent3 = GetBoolean(reader, 25).Value;
}
retval = new OmnitureDto(
questionnaireFk,
omniPagenameFp,
omniPagenameCp,
omniPagenameLp,
omniPagenamePp,
omniPagenameRp,
omniPagenameUf,
omniPagenameUc,
omniProp1Fk,
omniProp1,
omniProp2Fk,
omniProp2,
omniProp2Add,
omniProp3Fp,
omniProp3Cp,
omniProp3Lp,
omniProp3Pp,
omniProp3Rp,
omniProp3Uf,
omniProp3Uc,
omniProp9Fk,
omniProp9,
omniProp16Fk,
omniProp16,
omniEvent8,
omniEvent3
);
alreadyRead = reader.Read();
return retval;
}
private void Write(DbCommand sp, OmnitureDto dto)
{
_dbLayer.AddInParameter(sp, "@questionnaire_FK", DbType.Int32, dto.QuestionnaireFk);
_dbLayer.AddInParameter(sp, "@omni_pagename_fp", DbType.String, dto.OmniPagenameFp);
_dbLayer.AddInParameter(sp, "@omni_pagename_cp", DbType.String, dto.OmniPagenameCp);
_dbLayer.AddInParameter(sp, "@omni_pagename_lp", DbType.String, dto.OmniPagenameLp);
_dbLayer.AddInParameter(sp, "@omni_pagename_pp", DbType.String, dto.OmniPagenamePp);
_dbLayer.AddInParameter(sp, "@omni_pagename_rp", DbType.String, dto.OmniPagenameRp);
_dbLayer.AddInParameter(sp, "@omni_pagename_uf", DbType.String, dto.OmniPagenameUf);
_dbLayer.AddInParameter(sp, "@omni_pagename_uc", DbType.String, dto.OmniPagenameUc);
_dbLayer.AddInParameter(sp, "@omni_prop1_fk", DbType.Int32, dto.OmniProp1Fk);
_dbLayer.AddInParameter(sp, "@omni_prop2_fk", DbType.Int32, dto.OmniProp2Fk);
_dbLayer.AddInParameter(sp, "@omni_prop2_add", DbType.String, dto.OmniProp2Add);
_dbLayer.AddInParameter(sp, "@omni_prop3_fp", DbType.String, dto.OmniProp3Fp);
_dbLayer.AddInParameter(sp, "@omni_prop3_cp", DbType.String, dto.OmniProp3Cp);
_dbLayer.AddInParameter(sp, "@omni_prop3_lp", DbType.String, dto.OmniProp3Lp);
_dbLayer.AddInParameter(sp, "@omni_prop3_pp", DbType.String, dto.OmniProp3Pp);
_dbLayer.AddInParameter(sp, "@omni_prop3_rp", DbType.String, dto.OmniProp3Rp);
_dbLayer.AddInParameter(sp, "@omni_prop3_uf", DbType.String, dto.OmniProp3Uf);
_dbLayer.AddInParameter(sp, "@omni_prop3_uc", DbType.String, dto.OmniProp3Uc);
_dbLayer.AddInParameter(sp, "@omni_prop9_fk", DbType.Int32, dto.OmniProp9Fk);
_dbLayer.AddInParameter(sp, "@omni_prop16_fk", DbType.Int32, dto.OmniProp16Fk);
_dbLayer.AddInParameter(sp, "@omni_event8", DbType.Boolean, dto.OmniEvent8);
_dbLayer.AddInParameter(sp, "@omni_event3", DbType.Boolean, dto.OmniEvent3);
}
