private static void SetParameters(Business.DataObjectSurvey item, SqlParameterCollection parameters)
{
if (!string.IsNullOrEmpty(item.Header))
{
parameters.AddWithValue("@Header", item.Header);
}
else
{
parameters.AddWithValue("@Header", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.HeaderLinked))
{
parameters.AddWithValue("@HeaderLinked", item.HeaderLinked);
}
else
{
parameters.AddWithValue("@HeaderLinked", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Footer))
{
parameters.AddWithValue("@Footer", item.Footer);
}
else
{
parameters.AddWithValue("@Footer", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.FooterLinked))
{
parameters.AddWithValue("@FooterLinked", item.FooterLinked);
}
else
{
parameters.AddWithValue("@FooterLinked", DBNull.Value);
}
parameters.AddWithValue("@PunkteGruen", item.PunkteGruen);
parameters.AddWithValue("@PunkteGelb", item.PunkteGelb);
parameters.AddWithValue("@PunkteRot", item.PunkteRot);
if (!string.IsNullOrEmpty(item.MailTo))
{
parameters.AddWithValue("@MailTo", item.MailTo);
}
else
{
parameters.AddWithValue("@MailTo", DBNull.Value);
}
parameters.AddWithValue("@IsContest", item.IsContest);
parameters.AddWithValue("@ShowForm", item.ShowForm);
}
protected void OnOverviewItemDataBound(object sender, DataListItemEventArgs e)
{
Business.DataObjectSurvey dataObjectUser = (Business.DataObjectSurvey)e.Item.DataItem;
PlaceHolder ph = (PlaceHolder)e.Item.FindControl("PhItem");
string templateControl = this.OutputTemplate;
Control outControl = LoadControl(string.Format("~/UserControls/Templates/{0}", templateControl));
IDataObjectWorker outputControl = outControl as IDataObjectWorker;
outputControl.DataObject = dataObjectUser;
ISettings iCtrSett = outputControl as ISettings;
iCtrSett.Settings = this.Settings;
ph.Controls.Add(outControl);
}
protected void Page_Load(object sender, EventArgs e)
{
if (DataObject is Business.DataObjectSurvey)
{
dataObjectSurvey = (Business.DataObjectSurvey)DataObject;
}
else
{
dataObjectSurvey = DataAccess.Business.DataObject.Load <Business.DataObjectSurvey>(DataObject.ObjectID, null, false);
}
lnkTitle.Text = dataObjectSurvey.Title;
lnkTitle.NavigateUrl = Helper.GetDetailLink(dataObjectSurvey.ObjectType, dataObjectSurvey.ObjectID.Value.ToString());
litDesc.Text = dataObjectSurvey.HeaderLinked;
if (string.IsNullOrEmpty(litDesc.Text))
{
litDesc.Text = "-";
}
litDesc.ID = null;
lnkTitle.ID = null;
}
public static void FillObject(Business.DataObjectSurvey item, SqlDataReader sqlReader)
{
if (sqlReader["Header"] != DBNull.Value)
{
item.Header = sqlReader["Header"].ToString();
}
if (sqlReader["HeaderLinked"] != DBNull.Value)
{
item.HeaderLinked = sqlReader["HeaderLinked"].ToString();
}
if (sqlReader["Footer"] != DBNull.Value)
{
item.Footer = sqlReader["Footer"].ToString();
}
if (sqlReader["FooterLinked"] != DBNull.Value)
{
item.FooterLinked = sqlReader["FooterLinked"].ToString();
}
if (sqlReader["PunkteGruen"] != DBNull.Value)
{
item.PunkteGruen = Convert.ToDouble(sqlReader["PunkteGruen"]);
}
if (sqlReader["PunkteGelb"] != DBNull.Value)
{
item.PunkteGelb = Convert.ToDouble(sqlReader["PunkteGelb"]);
}
if (sqlReader["PunkteRot"] != DBNull.Value)
{
item.PunkteRot = Convert.ToDouble(sqlReader["PunkteRot"]);
}
item.IsContest = sqlReader["IsContest"] != DBNull.Value && Convert.ToBoolean(sqlReader["IsContest"]);
item.ShowForm = sqlReader["ShowForm"] != DBNull.Value && Convert.ToBoolean(sqlReader["ShowForm"]);
if (sqlReader["MailTo"] != DBNull.Value)
{
item.MailTo = sqlReader["MailTo"].ToString();
}
}
public static string GetUpdateSql(Business.DataObjectSurvey item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_Survey SET [OBJ_ID] = @OBJ_ID,[Header] = @Header, [HeaderLinked] = @HeaderLinked,[Footer] = @Footer,[FooterLinked] = @FooterLinked,[PunkteGruen] = @PunkteGruen,[PunkteGelb] = @PunkteGelb,[PunkteRot] = @PunkteRot,[IsContest] =@IsContest,[ShowForm] = @ShowForm,[MailTo]=@MailTo");
}
public static string GetInsertSql(Business.DataObjectSurvey item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("INSERT INTO hiobj_Survey([OBJ_ID],[Header],[HeaderLinked],[Footer],[FooterLinked],[PunkteGruen],[PunkteGelb],[PunkteRot],[IsContest],[ShowForm],[MailTo])VALUES (@OBJ_ID,@Header,@HeaderLinked,@Footer,@FooterLinked,@PunkteGruen,@PunkteGelb,@PunkteRot,@IsContest,@ShowForm,@MailTo)");
}
