protected void btnAdd_Click(object sender, System.EventArgs e) { SetMessage(""); //validation if (!DataValidation.IsNaturalNumberRange(txtWidth.Text, 1, 1680)) return; if (!DataValidation.IsNaturalNumberRange(txtHeight.Text, 1, 1024)) return; if (!CheckInputLength(txtWatermarkImage, "E00104")) return; if (!DataValidation.IsNaturalNumberRange(txtImageTransparent.Text, 0, 100)) return; if (!CheckInputLength(txtWatermarkImage, "E00104", false)) return; if (!DataValidation.IsNaturalNumberRange(txtTextTransparent.Text, 0, 100)) return; Johnny.CMS.BLL.SystemInfo.BreviarySettings bll = new Johnny.CMS.BLL.SystemInfo.BreviarySettings(); Johnny.CMS.OM.SystemInfo.BreviarySettings model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(); model.Width = DataConvert.GetInt32(txtWidth.Text); model.Height = DataConvert.GetInt32(txtHeight.Text); model.PlusWatermark = rdbPlusWatermark1.Checked; model.WatermarkType = rdbWatermarkType0.Checked; model.WatermarkImage = txtWatermarkImage.Text; model.ImageTransparent = DataConvert.GetInt32(txtImageTransparent.Text); model.WatermarkText = txtWatermarkText.Text; model.TextTransparent = DataConvert.GetInt32(txtTextTransparent.Text); model.WatermarkPosition = DataConvert.GetInt32(ddlWatermarkPosition.SelectedValue); bll.AddOrUpdate(model); SetMessage(GetMessage("C00003")); }
/// <summary> /// Method to get one recoder by primary key /// </summary> public Johnny.CMS.OM.SystemInfo.BreviarySettings GetModel(int id) { //Set up a return value Johnny.CMS.OM.SystemInfo.BreviarySettings model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [Id], [Width], [Height], [PlusWatermark], [WatermarkType], [WatermarkImage], [ImageTransparent], [WatermarkText], [TextTransparent], [WatermarkPosition] "); strSql.Append(" FROM [cms_breviarysettings] "); strSql.Append(" WHERE [Id]=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters)) { if (sdr.Read()) { model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(sdr.GetInt32(0), sdr.GetInt32(1), sdr.GetInt32(2), sdr.GetBoolean(3), sdr.GetBoolean(4), sdr.GetString(5), sdr.GetInt32(6), sdr.GetString(7), sdr.GetInt32(8), sdr.GetInt32(9)); } else { model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(); } } return(model); }
/// <summary> /// Add or update one record /// </summary> public void AddOrUpdate(Johnny.CMS.OM.SystemInfo.BreviarySettings model) { if (!dal.IsExist(1)) { dal.Add(model); } else { dal.Update(model); } }
/// <summary> /// Add one record /// </summary> public int Add(Johnny.CMS.OM.SystemInfo.BreviarySettings model) { StringBuilder strSql = new StringBuilder(); //strSql.Append("DECLARE @Sequence int"); //strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_breviarysettings]"); //strSql.Append(" if @Sequence is NULL"); //strSql.Append(" Set @Sequence=1"); strSql.Append("INSERT INTO [cms_breviarysettings]("); strSql.Append("[Width],[Height],[PlusWatermark],[WatermarkType],[WatermarkImage],[ImageTransparent],[WatermarkText],[TextTransparent],[WatermarkPosition]"); strSql.Append(")"); strSql.Append(" VALUES ("); strSql.Append("@width,@height,@pluswatermark,@watermarktype,@watermarkimage,@imagetransparent,@watermarktext,@texttransparent,@watermarkposition"); strSql.Append(")"); strSql.Append(";SELECT @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@width", SqlDbType.Int, 4), new SqlParameter("@height", SqlDbType.Int, 4), new SqlParameter("@pluswatermark", SqlDbType.Bit), new SqlParameter("@watermarktype", SqlDbType.Bit), new SqlParameter("@watermarkimage", SqlDbType.VarChar, 800), new SqlParameter("@imagetransparent", SqlDbType.Int, 4), new SqlParameter("@watermarktext", SqlDbType.NVarChar, 50), new SqlParameter("@texttransparent", SqlDbType.Int, 4), new SqlParameter("@watermarkposition", SqlDbType.Int, 4) }; parameters[0].Value = model.Width; parameters[1].Value = model.Height; parameters[2].Value = model.PlusWatermark; parameters[3].Value = model.WatermarkType; parameters[4].Value = model.WatermarkImage; parameters[5].Value = model.ImageTransparent; parameters[6].Value = model.WatermarkText; parameters[7].Value = model.TextTransparent; parameters[8].Value = model.WatermarkPosition; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
protected void btnAdd_Click(object sender, System.EventArgs e) { SetMessage(""); //validation if (!DataValidation.IsNaturalNumberRange(txtWidth.Text, 1, 1680)) { return; } if (!DataValidation.IsNaturalNumberRange(txtHeight.Text, 1, 1024)) { return; } if (!CheckInputLength(txtWatermarkImage, "E00104")) { return; } if (!DataValidation.IsNaturalNumberRange(txtImageTransparent.Text, 0, 100)) { return; } if (!CheckInputLength(txtWatermarkImage, "E00104", false)) { return; } if (!DataValidation.IsNaturalNumberRange(txtTextTransparent.Text, 0, 100)) { return; } Johnny.CMS.BLL.SystemInfo.BreviarySettings bll = new Johnny.CMS.BLL.SystemInfo.BreviarySettings(); Johnny.CMS.OM.SystemInfo.BreviarySettings model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(); model.Width = DataConvert.GetInt32(txtWidth.Text); model.Height = DataConvert.GetInt32(txtHeight.Text); model.PlusWatermark = rdbPlusWatermark1.Checked; model.WatermarkType = rdbWatermarkType0.Checked; model.WatermarkImage = txtWatermarkImage.Text; model.ImageTransparent = DataConvert.GetInt32(txtImageTransparent.Text); model.WatermarkText = txtWatermarkText.Text; model.TextTransparent = DataConvert.GetInt32(txtTextTransparent.Text); model.WatermarkPosition = DataConvert.GetInt32(ddlWatermarkPosition.SelectedValue); bll.AddOrUpdate(model); SetMessage(GetMessage("C00003")); }
protected override void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); if (!this.IsPostBack) { Johnny.CMS.BLL.SystemInfo.BreviarySettings bll = new Johnny.CMS.BLL.SystemInfo.BreviarySettings(); Johnny.CMS.OM.SystemInfo.BreviarySettings model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(); model = bll.GetModel(1); txtWidth.Text = DataConvert.GetString(model.Width); txtHeight.Text = DataConvert.GetString(model.Height); if (model.PlusWatermark) { rdbPlusWatermark1.Checked = true; } else { rdbPlusWatermark0.Checked = true; } if (model.WatermarkType) { rdbWatermarkType0.Checked = true; } else { rdbWatermarkType0.Checked = true; } txtWatermarkImage.Text = model.WatermarkImage; txtImageTransparent.Text = DataConvert.GetString(model.ImageTransparent); txtWatermarkText.Text = model.WatermarkText; txtTextTransparent.Text = DataConvert.GetString(model.TextTransparent); CreateddlWatermarkPosition(); foreach (ListItem item in ddlWatermarkPosition.Items) { if (DataConvert.GetInt32(item.Value) == model.WatermarkPosition) { item.Selected = true; break; } } btnAdd.ButtonType = Johnny.Controls.Web.Button.Button.EnumButtonType.Save; } }
/// <summary> /// Method to get recoders with condition /// </summary> public IList<Johnny.CMS.OM.SystemInfo.BreviarySettings> GetList() { IList<Johnny.CMS.OM.SystemInfo.BreviarySettings> list = new List<Johnny.CMS.OM.SystemInfo.BreviarySettings>(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [Id], [Width], [Height], [PlusWatermark], [WatermarkType], [WatermarkImage], [ImageTransparent], [WatermarkText], [TextTransparent], [WatermarkPosition] "); strSql.Append(" FROM [cms_breviarysettings] "); strSql.Append(" ORDER BY [Sequence]"); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (sdr.Read()) { Johnny.CMS.OM.SystemInfo.BreviarySettings item = new Johnny.CMS.OM.SystemInfo.BreviarySettings(sdr.GetInt32(0), sdr.GetInt32(1), sdr.GetInt32(2), sdr.GetBoolean(3), sdr.GetBoolean(4), sdr.GetString(5), sdr.GetInt32(6), sdr.GetString(7), sdr.GetInt32(8), sdr.GetInt32(9)); list.Add(item); } } return list; }
/// <summary> /// Method to get recoders with condition /// </summary> public IList <Johnny.CMS.OM.SystemInfo.BreviarySettings> GetList() { IList <Johnny.CMS.OM.SystemInfo.BreviarySettings> list = new List <Johnny.CMS.OM.SystemInfo.BreviarySettings>(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [Id], [Width], [Height], [PlusWatermark], [WatermarkType], [WatermarkImage], [ImageTransparent], [WatermarkText], [TextTransparent], [WatermarkPosition] "); strSql.Append(" FROM [cms_breviarysettings] "); strSql.Append(" ORDER BY [Sequence]"); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (sdr.Read()) { Johnny.CMS.OM.SystemInfo.BreviarySettings item = new Johnny.CMS.OM.SystemInfo.BreviarySettings(sdr.GetInt32(0), sdr.GetInt32(1), sdr.GetInt32(2), sdr.GetBoolean(3), sdr.GetBoolean(4), sdr.GetString(5), sdr.GetInt32(6), sdr.GetString(7), sdr.GetInt32(8), sdr.GetInt32(9)); list.Add(item); } } return(list); }
/// <summary> /// Update one record /// </summary> public void Update(Johnny.CMS.OM.SystemInfo.BreviarySettings model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE [cms_breviarysettings] SET "); strSql.Append("[Width]=@width,"); strSql.Append("[Height]=@height,"); strSql.Append("[PlusWatermark]=@pluswatermark,"); strSql.Append("[WatermarkType]=@watermarktype,"); strSql.Append("[WatermarkImage]=@watermarkimage,"); strSql.Append("[ImageTransparent]=@imagetransparent,"); strSql.Append("[WatermarkText]=@watermarktext,"); strSql.Append("[TextTransparent]=@texttransparent,"); strSql.Append("[WatermarkPosition]=@watermarkposition"); //strSql.Append(" WHERE [Id]=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@width", SqlDbType.Int, 4), new SqlParameter("@height", SqlDbType.Int, 4), new SqlParameter("@pluswatermark", SqlDbType.Bit), new SqlParameter("@watermarktype", SqlDbType.Bit), new SqlParameter("@watermarkimage", SqlDbType.VarChar, 800), new SqlParameter("@imagetransparent", SqlDbType.Int, 4), new SqlParameter("@watermarktext", SqlDbType.NVarChar, 50), new SqlParameter("@texttransparent", SqlDbType.Int, 4), new SqlParameter("@watermarkposition", SqlDbType.Int, 4) }; parameters[0].Value = model.Id; parameters[1].Value = model.Width; parameters[2].Value = model.Height; parameters[3].Value = model.PlusWatermark; parameters[4].Value = model.WatermarkType; parameters[5].Value = model.WatermarkImage; parameters[6].Value = model.ImageTransparent; parameters[7].Value = model.WatermarkText; parameters[8].Value = model.TextTransparent; parameters[9].Value = model.WatermarkPosition; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// Method to get one recoder by primary key /// </summary> public Johnny.CMS.OM.SystemInfo.BreviarySettings GetModel(int id) { //Set up a return value Johnny.CMS.OM.SystemInfo.BreviarySettings model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [Id], [Width], [Height], [PlusWatermark], [WatermarkType], [WatermarkImage], [ImageTransparent], [WatermarkText], [TextTransparent], [WatermarkPosition] "); strSql.Append(" FROM [cms_breviarysettings] "); strSql.Append(" WHERE [Id]=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters)) { if (sdr.Read()) model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(sdr.GetInt32(0), sdr.GetInt32(1), sdr.GetInt32(2), sdr.GetBoolean(3), sdr.GetBoolean(4), sdr.GetString(5), sdr.GetInt32(6), sdr.GetString(7), sdr.GetInt32(8), sdr.GetInt32(9)); else model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(); } return model; }
protected override void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); if (!this.IsPostBack) { Johnny.CMS.BLL.SystemInfo.BreviarySettings bll = new Johnny.CMS.BLL.SystemInfo.BreviarySettings(); Johnny.CMS.OM.SystemInfo.BreviarySettings model = new Johnny.CMS.OM.SystemInfo.BreviarySettings(); model = bll.GetModel(1); txtWidth.Text = DataConvert.GetString(model.Width); txtHeight.Text = DataConvert.GetString(model.Height); if (model.PlusWatermark) rdbPlusWatermark1.Checked = true; else rdbPlusWatermark0.Checked = true; if (model.WatermarkType) rdbWatermarkType0.Checked = true; else rdbWatermarkType0.Checked = true; txtWatermarkImage.Text = model.WatermarkImage; txtImageTransparent.Text = DataConvert.GetString(model.ImageTransparent); txtWatermarkText.Text = model.WatermarkText; txtTextTransparent.Text = DataConvert.GetString(model.TextTransparent); CreateddlWatermarkPosition(); foreach (ListItem item in ddlWatermarkPosition.Items) { if (DataConvert.GetInt32(item.Value) == model.WatermarkPosition) { item.Selected = true; break; } } btnAdd.ButtonType = Johnny.Controls.Web.Button.Button.EnumButtonType.Save; } }
/// <summary> /// Update one record /// </summary> public void Update(Johnny.CMS.OM.SystemInfo.BreviarySettings model) { dal.Update(model); }
/// <summary> /// Add one record /// </summary> public int Add(Johnny.CMS.OM.SystemInfo.BreviarySettings model) { return(dal.Add(model)); }