www.pudn.com > Tustena_CRM_OS_3.0.2_Stable.zip > DeleteChecked.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; 
using System.Web.UI.WebControls; 
using Digita.Tustena.Database; 
 
namespace Digita.Tustena.Base 
{ 
	public class DeleteChecked 
	{ 
		public DeleteChecked() 
		{ 
		} 
 
		public static int Delete(Repeater rep, string id, string idcheck, string dbtable) 
		{ 
			string ids=string.Empty; 
			int deleted = 0; 
			for (int i = 0; i < rep.Items.Count; i++) 
			{ 
				bool isChecked = ((CheckBox) rep.Items[i].FindControl(idcheck)).Checked; 
				if (isChecked) 
				{ 
					ids+="id="+((Literal) (rep.Items[i].FindControl(id))).Text+" or "; 
					deleted++; 
				} 
			} 
			if(ids.Length>0) 
			{ 
				DeleteDB(ids.Substring(0,ids.Length-3),dbtable); 
				return deleted; 
			} 
			else 
				return 0; 
		} 
 
		private static void DeleteDB(string ids,string table) 
		{ 
			DatabaseConnection.DoCommand("delete from "+table+" where "+ids); 
		} 
	} 
}