www.pudn.com > Tustena_CRM_OS_3.0.2_Stable.zip > ScoreManagment.ascx.cs

/// TUSTENA PUBLIC LICENSE v1.0 
///  
/// Portions Copyright (c) 2003-2005 Digita S.r.l. All Rights Reserved. 
/// 
/// Tustena CRM is a trademark of: 
/// Digita S.r.l. 
/// Viale Enrico Fermi 14/z 
/// 31011 Asolo (Italy) 
/// Tel. +39-0423-951251 
/// Mail. info@digita.it 
/// 
/// This file contains Original Code and/or Modifications of Original Code 
/// as defined in and that are subject to the Tustena Public Source License 
/// Version 1.0 (the 'License'). You may not use this file except in 
/// compliance with the License. Please obtain a copy of the License at 
/// http://www.tustena.com/TPL/ and read it before using this 
// file. 
/// 
/// The Original Code and all software distributed under the License are 
/// distributed on an 'AS IS' basis, WITHOUT WARRANTY OF ANY KIND, EITHER 
/// EXPRESS OR IMPLIED, AND DIGITA S.R.L. HEREBY DISCLAIMS ALL SUCH WARRANTIES, 
/// INCLUDING WITHOUT LIMITATION, ANY WARRANTIES OF MERCHANTABILITY, 
/// FITNESS FOR A PARTICULAR PURPOSE, QUIET ENJOYMENT OR NON-INFRINGEMENT. 
/// Please see the License for the specific language governing rights and 
/// limitations under the License. 
/// 
/// YOU MAY NOT REMOVE OR ALTER THIS COPYRIGHT NOTICE! 
///  
 
using System.Resources; 
using System.Web.UI; 
using Digita.Tustena.Database; 
 
namespace Digita.Tustena.Admin 
{ 
	using System; 
	using System.Data; 
	using System.Drawing; 
	using System.Web; 
	using System.Web.UI.WebControls; 
	using System.Web.UI.HtmlControls; 
 
	public class ScoreManagment1 : System.Web.UI.UserControl 
	{ 
		protected System.Web.UI.WebControls.Repeater scorerepeater; 
		protected System.Web.UI.WebControls.LinkButton submit; 
		private UserConfig UC = new UserConfig(); 
		protected Digita.Tustena.Localize.LocalizedLiteral Localizedliteral1; 
		public static ResourceManager rm = (ResourceManager) HttpContext.Current.Application["RM"]; 
 
		private void Page_Load(object sender, System.EventArgs e) 
		{ 
			UC = (UserConfig) HttpContext.Current.Session["userconfig"]; 
			if(!Page.IsPostBack) 
			{ 
				submit.Text=rm.GetString("Save"); 
				RefreshTable(); 
			} 
		} 
 
		private void RefreshTable() 
		{ 
			scorerepeater.DataSource=DatabaseConnection.CreateDataset("select * from scoredescription"); 
			scorerepeater.DataBind(); 
		} 
 
		#region Codice generato da Progettazione Web Form 
		override protected void OnInit(EventArgs e) 
		{ 
			InitializeComponent(); 
			base.OnInit(e); 
		} 
 
		private void InitializeComponent() 
		{ 
			this.scorerepeater.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.scorerepeater_ItemDataBound); 
			this.scorerepeater.ItemCommand += new System.Web.UI.WebControls.RepeaterCommandEventHandler(this.scorerepeater_ItemCommand); 
			this.submit.Click += new System.EventHandler(this.submit_Click); 
			this.Load += new System.EventHandler(this.Page_Load); 
 
		} 
		#endregion 
 
		private byte ScorePercent=0; 
		private void scorerepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) 
		{ 
			switch (e.Item.ItemType) 
			{ 
				case ListItemType.Item: 
				case ListItemType.AlternatingItem: 
					TextBox ScoreDescription = (TextBox)e.Item.FindControl("ScoreDescription"); 
					TextBox ScoreWeight = (TextBox)e.Item.FindControl("ScoreWeight"); 
					Label ScoreID = (Label)e.Item.FindControl("ScoreID"); 
					ScoreID.Text=DataBinder.Eval((DataRowView) e.Item.DataItem, "id").ToString(); 
					ScoreDescription.Text=DataBinder.Eval((DataRowView) e.Item.DataItem, "Description").ToString(); 
					ScoreWeight.Text=DataBinder.Eval((DataRowView) e.Item.DataItem, "Weight").ToString(); 
					ScorePercent+=Convert.ToByte(ScoreWeight.Text); 
					break; 
				case ListItemType.Footer: 
					TextBox ScoreTotal = (TextBox)e.Item.FindControl("ScoreTotal"); 
					ScoreTotal.Text=ScorePercent.ToString(); 
					LinkButton AddItem = (LinkButton)e.Item.FindControl("AddItem"); 
					AddItem.Text=rm.GetString("MakeNew"); 
					break; 
			} 
		} 
 
		private void submit_Click(object sender, EventArgs e) 
		{ 
			foreach(RepeaterItem  ri in scorerepeater.Items) 
			{ 
				Label ScoreID = (Label)ri.FindControl("ScoreID"); 
				TextBox ScoreDescription = (TextBox)ri.FindControl("ScoreDescription"); 
				TextBox ScoreWeight = (TextBox)ri.FindControl("ScoreWeight"); 
				byte w = 0; 
				try 
				{ 
					w = byte.Parse(ScoreWeight.Text); 
				} 
				catch 
				{ 
					w=0; 
				} 
				DatabaseConnection.DoCommand(string.Format("update scoredescription set description='{0}', weight={1} where id={2}",DatabaseConnection.FilterInjection(ScoreDescription.Text),w,ScoreID.Text)); 
			} 
			RefreshTable(); 
			Page.RegisterStartupScript("",""); 
		} 
 
		private void scorerepeater_ItemCommand(object source, RepeaterCommandEventArgs e) 
		{ 
			switch(e.CommandName) 
			{ 
				case "AddItem": 
							string AddDescription = ((TextBox)e.Item.FindControl("AddDescription")).Text; 
							string AddWeight = ((TextBox)e.Item.FindControl("AddWeight")).Text; 
							byte w = 0; 
							try 
							{ 
								w = byte.Parse(AddWeight); 
							}catch 
							{ 
								w=0; 
							} 
							DatabaseConnection.DoCommand(string.Format("insert into scoredescription (description,weight) values ('{0}',{1})",DatabaseConnection.FilterInjection(AddDescription),w)); 
 
					break; 
				case "DeleteItems": 
					foreach(RepeaterItem  ri in scorerepeater.Items) 
					{ 
						CheckBox todelete = (CheckBox)ri.FindControl("todelete"); 
						if(todelete.Checked) 
						{ 
							DatabaseConnection.DoCommand("delete from scoredescription where id="+((Label)ri.FindControl("ScoreID")).Text); 
						} 
					} 
 
					break; 
			} 
			RefreshTable(); 
		} 
	} 
}