public static List<TemplateInfo> GetTemplateList(int PortalID, string UserName) { string sp = "[dbo].[sp_TemplateGetList]"; SQLHandler sagesql = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); ParamCollInput.Add(new KeyValuePair<string, object>("@Username", UserName)); List<TemplateInfo> lstTemplate = new List<TemplateInfo>(); try { SqlDataReader reader; reader = sagesql.ExecuteAsDataReader(sp, ParamCollInput); while (reader.Read()) { TemplateInfo obj = new TemplateInfo(); obj.TemplateID = int.Parse(reader["TemplateID"].ToString()); obj.TemplateTitle = reader["TemplateTitle"].ToString(); obj.PortalID = int.Parse(reader["PortalID"].ToString()); obj.Author = reader["Author"].ToString(); obj.AuthorURL = reader["AuthorURL"].ToString(); obj.Description = reader["Description"].ToString(); lstTemplate.Add(obj); } reader.Close(); return lstTemplate; } catch (Exception ex) { throw (ex); } }
public static bool AddTemplate(TemplateInfo obj) { try { return (TemplateDataProvider.AddTemplate(obj)); } catch (Exception) { throw; } }
/// <summary> /// Connects to database and adds template. /// </summary> /// <param name="obj">TemplateInfo object containing the template details.</param> /// <returns>True if the template is added successfully.</returns> public static bool AddTemplate(TemplateInfo obj) { string sp = "[dbo].[sp_TemplateAdd]"; SQLHandler sagesql = new SQLHandler(); List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@TemplateTitle", obj.TemplateTitle)); ParamCollInput.Add(new KeyValuePair <string, object>("@Author", obj.Author)); ParamCollInput.Add(new KeyValuePair <string, object>("@Description", obj.Description)); ParamCollInput.Add(new KeyValuePair <string, object>("@AuthorURL", obj.AuthorURL)); ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", obj.PortalID)); ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", obj.AddedBy)); try { sagesql.ExecuteNonQuery(sp, ParamCollInput); return(true); } catch (Exception ex) { throw (ex); } }
/// <summary> /// Connects to database and adds template. /// </summary> /// <param name="obj">TemplateInfo object containing the template details.</param> /// <returns>True if the template is added successfully.</returns> public static bool AddTemplate(TemplateInfo obj) { string sp = "[dbo].[sp_TemplateAdd]"; SQLHandler sagesql = new SQLHandler(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@TemplateTitle", obj.TemplateTitle)); ParamCollInput.Add(new KeyValuePair<string, object>("@Author",obj.Author)); ParamCollInput.Add(new KeyValuePair<string, object>("@Description", obj.Description)); ParamCollInput.Add(new KeyValuePair<string, object>("@AuthorURL", obj.AuthorURL)); ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", obj.PortalID)); ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", obj.AddedBy)); try { sagesql.ExecuteNonQuery(sp, ParamCollInput); return true; } catch (Exception ex) { throw (ex); } }