private List <MediaFiles> GetMediaFiles(Guid?gGuid = null)
{
List <MediaFiles> liMediaFiles = new List <MediaFiles>();
MediaFiles oMediaFiles = null;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DemoVideoBurstConnection"].ConnectionString))
{
conn.Open();
RenderTemplateElementsBL oRenderTemplateElementsBL = new RenderTemplateElementsBL();
SqlDataReader reader = null;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = " Select M.urlid ,MP.description,M.width, M.height, M.mediatype, isnull(Mu.dsignedurl, '') dsignedurl from tblJobs Job INNER JOIN tblMedia M ON Job.id = M.jobid INNER JOIN tblMediaUrls MU On M.urlid = MU.id INNER JOIN tblMediaProfiles MP On M.profile = MP.profileid WHERE MP.active = 1 and M.active=1 and Job.status=100000 and Job.deleted=0 and Job.guid='" + gGuid + "' Order by MU.created desc";
sqlCmd.Connection = conn;
reader = sqlCmd.ExecuteReader();
ElementTypesBL oElementTypesBL = new ElementTypesBL();
while (reader.Read())
{
oMediaFiles = new MediaFiles();
oMediaFiles.url = Convert.ToString(reader["dsignedurl"]);
oMediaFiles.description = Convert.ToString(reader["description"]);
oMediaFiles.width = Convert.ToInt32(reader["width"]);
oMediaFiles.height = Convert.ToInt32(reader["height"]);
oMediaFiles.mediatype = Convert.ToInt32(reader["mediatype"]);
liMediaFiles.Add(oMediaFiles);
}
}
}
catch (Exception ex)
{
}
return(liMediaFiles);
}
internal List <TemplateElements> GetTemplatesElements(Guid?gTemplateGuid)
{
List <TemplateElements> liTemplateElements = new List <TemplateElements>();
TemplateElements oTemplateElements = null;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DemoVideoBurstConnection"].ConnectionString))
{
conn.Open();
RenderTemplateElementsBL oRenderTemplateElementsBL = new RenderTemplateElementsBL();
SqlDataReader reader = null;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "Select * from tblTemplateElements where active=1 and templateguid='" + gTemplateGuid + "'";
sqlCmd.Connection = conn;
reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
oTemplateElements = new TemplateElements();
oTemplateElements.guid = Guid.Parse(reader["guid"].ToString());
oTemplateElements.templateguid = Guid.Parse(reader["templateguid"].ToString());
oTemplateElements.rendertemplateelement = oRenderTemplateElementsBL.GetRenderTemplateElementByGuid(Guid.Parse(reader["renderelementguid"].ToString()));
oTemplateElements.title = reader["title"].ToString();
oTemplateElements.helptext = Convert.ToString(reader.GetValue(3));
oTemplateElements.mode = Convert.ToInt16(reader["mode"]);
oTemplateElements.defaultvalue = reader["defaultvalue"].ToString();
oTemplateElements.active = Convert.ToBoolean(reader["active"]);
oTemplateElements.sortorder = Convert.ToInt16(reader["sortorder"]);
//reader["sortorder"] != DBNull.Value ? Convert.ToInt32(reader["sortorder"]) : 9999;
oTemplateElements.groupname = Convert.ToString(reader["groupname"]);
oTemplateElements.DefaultThumbnail = reader["DefaultThumbnail"].ToString();
liTemplateElements.Add(oTemplateElements);
//conn.Close();
}
return(liTemplateElements);
if (conn != null)
{
conn.Close();
}
}
}
catch (Exception ex)
{
}
return(liTemplateElements);
}
public List <ElementTypes> GetTemplatesElements(int?iElementTypeId = null)
{
List <ElementTypes> liElementTypes = new List <ElementTypes>();
ElementTypes oElementTypes = null;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DemoVideoBurstConnection"].ConnectionString))
{
conn.Open();
RenderTemplateElementsBL oRenderTemplateElementsBL = new RenderTemplateElementsBL();
SqlDataReader reader = null;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = " SELECT [type],[engineid],[description],[tag],[foldername] FROM [tblElementTypes] WHERE [type]=" + iElementTypeId + "";
sqlCmd.Connection = conn;
reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
oElementTypes = new ElementTypes();
oElementTypes.type = Convert.ToInt32(reader["type"]);
oElementTypes.engineid = Convert.ToInt32(reader["engineid"]);
oElementTypes.description = Convert.ToString(reader["description"]);
oElementTypes.tag = Convert.ToString(reader["tag"]);
oElementTypes.foldername = Convert.ToString(reader["foldername"]);
liElementTypes.Add(oElementTypes);
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
}
}
catch (Exception ex)
{
}
return(liElementTypes);
}
private List <RenderTemplateElements> GetRenderTemplateElements(Guid?gElementGuid = null)
{
List <RenderTemplateElements> liRenderTemplateElements = new List <RenderTemplateElements>();
RenderTemplateElements oRenderTemplateElements = null;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DemoVideoBurstConnection"].ConnectionString))
{
conn.Open();
RenderTemplateElementsBL oRenderTemplateElementsBL = new RenderTemplateElementsBL();
SqlDataReader reader = null;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = " SELECT [elements].[type],[types].[tag] typetext,[starttime],[stoptime],[width],[height],[minlength],[maxlength],[group] FROM dbo.[tblRenderTemplateElements] [elements] INNER JOIN dbo.[tblElementTypes][types] ON[types].[type] = [elements].[type] where guid='" + gElementGuid + "'";
sqlCmd.Connection = conn;
reader = sqlCmd.ExecuteReader();
ElementTypesBL oElementTypesBL = new ElementTypesBL();
while (reader.Read())
{
oRenderTemplateElements = new RenderTemplateElements();
oRenderTemplateElements.elementtype = oElementTypesBL.GetElementTypesByElementType(Convert.ToInt32(reader["type"]));
oRenderTemplateElements.typetext = Convert.ToString(reader["typetext"]);
oRenderTemplateElements.starttime = reader["starttime"] != DBNull.Value ? Math.Round(Convert.ToDecimal(reader["starttime"]), 0).ToString() : "0";
oRenderTemplateElements.stoptime = reader["stoptime"] != DBNull.Value ? Math.Round(Convert.ToDecimal(reader["stoptime"]), 0).ToString() : "0";
oRenderTemplateElements.width = !String.IsNullOrEmpty(Convert.ToString(reader["width"])) ? (int?)(reader["width"]) : null;
oRenderTemplateElements.height = !String.IsNullOrEmpty(Convert.ToString(reader["height"])) ? (int?)(reader["height"]) : null;
oRenderTemplateElements.minlength = !String.IsNullOrEmpty(Convert.ToString(reader["minlength"])) ? (int?)(reader["minlength"]) : null;
oRenderTemplateElements.maxlength = !String.IsNullOrEmpty(Convert.ToString(reader["maxlength"])) ? (int?)(reader["maxlength"]) : null;
oRenderTemplateElements.group = Convert.ToInt32(reader["group"]);
liRenderTemplateElements.Add(oRenderTemplateElements);
}
}
}
catch (Exception ex)
{
}
return(liRenderTemplateElements);
}