public static LandingPage Save(LandingPage landingpage)
{
DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.ctx_SAVE_LANDINGPAGE");
cmd.AddInputOutputParam("pLandingPageID", DbType.Guid, landingpage.ID);
cmd.AddInputOutputParam("pOfferID", DbType.Guid, landingpage.OfferID );
cmd.AddInputOutputParam("pDesignerID", DbType.Guid, landingpage.DesignerID );
cmd.AddInputOutputParam("pName", DbType.String, landingpage.Name);
cmd.AddInputOutputParam("pUrl", DbType.String, landingpage.Url);
cmd.AddInputOutputParam("pWeight", DbType.Int32, landingpage.Weight);
cmd.AddInputOutputParam("pType", DbType.Int32, landingpage.Type);
cmd.AddInputOutputParam("pActive", DbType.Boolean, landingpage.IsActive);
cmd.AddInputOutputParam("pApproved", DbType.Boolean, landingpage.IsApproved);
cmd.AddOutputParam("oLastEditDate", DbType.DateTime);
cmd.AddOutputParam("oCreationDate", DbType.DateTime);
SqlHelpers.ExecuteNonQuery(cmd);
landingpage.ID = cmd.ExtractGuid("pLandingPageID");
landingpage.OfferID = cmd.ExtractGuid("pOfferID");
landingpage.DesignerID = cmd.ExtractGuid("pDesignerID");
landingpage.Name = cmd.ExtractString("pName");
landingpage.Url = cmd.ExtractString("pUrl");
landingpage.Weight = int.Parse(cmd.ExtractString("pWeight").ToString());
landingpage.Type = int.Parse(cmd.ExtractString("pType").ToString());
landingpage.IsActive = cmd.ExtractBool("pActive");
landingpage.IsApproved = cmd.ExtractBool("pApproved");
landingpage.LastEditDate = cmd.ExtractDateTime("oLastEditDate");
landingpage.CreationDate = cmd.ExtractDateTime("oCreationDate");
return landingpage;
}
public static LandingPage ToLandingPage(this DataRow dr)
{
LandingPage page = new LandingPage
{
ID = dr.GetGuid("LandingPageID"),
OfferID = dr.GetGuid("OfferID"),
DesignerID = dr.GetGuid("DesignerID"),
Name = dr.GetString("Name"),
Url = dr.GetString("Url"),
Weight = dr.GetInt("Weight"),
Type=dr.GetInt("Type"),
IsActive=dr.GetBoolean("Active"),
IsApproved=dr.GetBoolean("Approved"),
CreationDate =dr.GetDate("CreationDate"),
LastEditDate = dr.GetDate("LastEditDate")
};
return page;
}
