public rb_HtmlText_st TranslateHtmlTextDTOIntoRb_HtmlText_st(HtmlTextDTO html)
{
rb_HtmlText_st _html = new rb_HtmlText_st();
_html.DesktopHtml = html.DesktopHtml;
_html.MobileDetails = html.MobileDetails;
_html.MobileSummary = html.MobileSummary;
_html.ModuleID = html.ModuleID;
return(_html);
}
public HtmlTextDTO TranslateRb_HtmlTextIntoHtmlTextDTO(rb_HtmlText html)
{
HtmlTextDTO _html = new HtmlTextDTO();
_html.DesktopHtml = html.DesktopHtml;
_html.MobileDetails = html.MobileDetails;
_html.MobileSummary = html.MobileSummary;
_html.ModuleID = html.ModuleID;
return(_html);
}
public rb_HtmlText TranslateHtmlTextDTOIntoRb_HtmlText(HtmlTextDTO html)
{
rb_HtmlText _html = new rb_HtmlText();
_html.DesktopHtml = html.DesktopHtml;
_html.MobileDetails = html.MobileDetails;
_html.MobileSummary = html.MobileSummary;
_html.ModuleID = html.ModuleID;
_html.CWCSS = html.CWCSS;
_html.CWHTML = html.CWHTML;
_html.CWJS = html.CWJS;
return(_html);
}
public bool SetContentData(int moduleId, HtmlTextDTO content)
{
if (content == null || content.DesktopHtml.Equals(string.Empty))
{
//si el contenido es nullo es porque no existe ningun registro en htmltext para el modulo
return(true);
}
else
{
IPortalTemplateServices services = PortalTemplateFactory.GetPortalTemplateServices(new PortalTemplateRepository());
return(services.SaveHtmlText(moduleId, content));
}
}
public string GetContentData(int moduleId)
{
IPortalTemplateServices services = PortalTemplateFactory.GetPortalTemplateServices(new PortalTemplateRepository());
HtmlTextDTO _html = services.GetHtmlTextDTO(moduleId);
if (_html == null)
{
return(string.Empty);
}
else
{
System.IO.StringWriter xout = new System.IO.StringWriter();
XmlSerializer xs = new XmlSerializer(typeof(HtmlTextDTO));
xs.Serialize(xout, _html);
return(xout.ToString());
}
}
public bool SetContentData(int moduleId, string content)
{
if (content == null || content.Equals(string.Empty))
{
//si el contenido es nullo es porque no existe ningun registro en htmltext para el modulo
return(true);
}
else
{
IPortalTemplateServices services = PortalTemplateFactory.GetPortalTemplateServices(new PortalTemplateRepository());
HtmlTextDTO _html = new HtmlTextDTO();
System.IO.StringReader xin = new System.IO.StringReader(content);
XmlSerializer xs = new XmlSerializer(typeof(HtmlTextDTO));
_html = (HtmlTextDTO)xs.Deserialize(xin);
return(services.SaveHtmlText(moduleId, _html));
}
}
/// <summary>
/// Saves the HTML text.
/// </summary>
/// <param name="moduleId">
/// The module id.
/// </param>
/// <param name="html">
/// The HTML.
/// </param>
/// <returns>
/// The save html text.
/// </returns>
public bool SaveHtmlText(int moduleId, HtmlTextDTO html)
{
var result = true;
try {
var db = new PortalTemplateDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
var translate = new Translate();
var htmlText = translate.TranslateHtmlTextDTOIntoRb_HtmlText(html);
htmlText.ModuleID = moduleId;
var htmlst = translate.TranslateHtmlTextDTOIntoRb_HtmlText_st(html);
htmlst.ModuleID = moduleId;
db.rb_HtmlTexts.InsertOnSubmit(htmlText);
db.rb_HtmlText_sts.InsertOnSubmit(htmlst);
db.SubmitChanges(ConflictMode.FailOnFirstConflict);
} catch (Exception ex) {
result = false;
ErrorHandler.Publish(LogLevel.Error, "There was an error saving the content modules", ex);
}
return(result);
}
public HtmlTextDTO GetHtmlTextDTO(int moduleId, WorkFlowVersion version)
{
var strDesktopHtml = new HtmlTextDTO();
// Create Instance of Connection and Command Object
using (var connection = Config.SqlConnectionString)
{
using (var command = new SqlCommand("rb_GetHtmlText", connection))
{
// Mark the Command as a SPROC
command.CommandType = CommandType.StoredProcedure;
// Add Parameters to SPROC
var parameterModuleId = new SqlParameter("@ModuleID", SqlDbType.Int, 4)
{
Value = moduleId
};
command.Parameters.Add(parameterModuleId);
// Change by [email protected]
// Date: 6/2/2003
var parameterWorkflowVersion = new SqlParameter("@WorkflowVersion", SqlDbType.Int, 4)
{
Value = (int)version
};
command.Parameters.Add(parameterWorkflowVersion);
//Add by [email protected]
// Date: 12/23/2014
// Get published version content
int publishedVersion = 1;
SqlDataReader sqlDatard = this.GetHtmlTextRecord(moduleId);
if (sqlDatard.HasRows)
{
while (sqlDatard.Read())
{
if (Convert.ToBoolean(sqlDatard["Published"]))
{
publishedVersion = Convert.ToInt32(sqlDatard["VersionNo"]);
break;
}
}
}
// Added by Ashish - Connection Pool Issues
if (sqlDatard != null)
{
sqlDatard.Close();
}
var moduleVersion = new SqlParameter("@VersionNo", SqlDbType.Int, 4)
{
Value = publishedVersion
};
command.Parameters.Add(moduleVersion);
// End Change [email protected]
// Execute the command
connection.Open();
using (var result = command.ExecuteReader(CommandBehavior.CloseConnection))
{
try
{
if (result.Read())
{
strDesktopHtml.DesktopHtml = result["DesktopHtml"].ToString();
strDesktopHtml.CWCSS = result["CWCSS"].ToString();
strDesktopHtml.CWHTML = result["CWHTML"].ToString();
strDesktopHtml.CWJS = result["CWJS"].ToString();
strDesktopHtml.MobileDetails = result["MobileDetails"].ToString();
strDesktopHtml.MobileSummary = result["MobileSummary"].ToString();
strDesktopHtml.ModuleID = moduleId;
}
}
finally
{
// Close the datareader
result.Close();
}
}
}
}
return(strDesktopHtml);
}
