snipt

Ctrl+h for KB shortcuts

C#

BLL class template

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using DataSetToDoTableAdapters;
using System.ComponentModel;

/// <summary>
/// Summary description for ClassBLL
/// </summary>
[Serializable, DataObject()]
public class ClassBLL
{
	#region [Class Members]

	private DBTableAdapter _adapterDB;

	#endregion

	#region [Constrators]

	/// <summary>
	/// Default constructor.
	/// </summary>
	public ClassBLL()
	{

	}

	#endregion

	#region [Methods]

	/// <summary>
	/// Delete an item.
	/// </summary>
	/// <param name="Original_Id">Integer. ItemId.</param>
	/// <returns>Integer. Number of affected items.</returns>
	[DataObjectMethodAttribute(DataObjectMethodType.Delete, true)]
	public int Delete(int Original_Id)
	{
		return (AdapterDB.Delete(Original_Id));
	}

	/// <summary>
	/// Insert a new item.
	/// </summary>
	/// <param name="?">Type. Description.</param>
	/// <returns>Integer. Number of affected items.</returns>
	[DataObjectMethodAttribute(DataObjectMethodType.Insert, true)]
	public cInsert(?)
	{
		return (AdapterDB.Insert(?));
	}

	/// <summary>
	/// Get item by its id.
	/// </summary>
	/// <param name="intItemId">Integer. Item Id.</param>
	/// <returns>DBDataTable</returns>
	[DataObjectMethodAttribute(DataObjectMethodType.Select, true)]
	public DataSetDB.DBDataTable GetItem(int intItemId)
	{
		return (AdapterDB.GetDataById(intItemId));
	}


	/// <summary>
	/// Update an item.
	/// </summary>
	/// <param name="?">Type. Description.</param>
	/// <param name="original_Id">Integer. Template id.</param>
	[DataObjectMethodAttribute(DataObjectMethodType.Update, true)]
	public int Update(?, int Original_Id)
	{
		return (AdapterDB.Update(?, Original_Id));
	}

	#endregion

	#region [Class Properties]



	#endregion

	#region [Data Adapters]

	/// <summary>
	/// DB table adapter.
	/// </summary>
	public DBTableAdapter AdapterDB
	{
		get
		{
			if(_adapterDB== null)
				_adapterDB = new DBTableAdapter();

			return(_adapterDB);
		}
	}

	#endregion
}
https://snipt.net/embed/b5c3b2c69de0aaaff55d53c14f5775b3/
/raw/b5c3b2c69de0aaaff55d53c14f5775b3/
b5c3b2c69de0aaaff55d53c14f5775b3
csharp
C#
110
2019-06-19T20:49:02
True
False
False
/api/public/snipt/32135/
bll-class-template
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10"> 10</a> <a href="#L-11"> 11</a> <a href="#L-12"> 12</a> <a href="#L-13"> 13</a> <a href="#L-14"> 14</a> <a href="#L-15"> 15</a> <a href="#L-16"> 16</a> <a href="#L-17"> 17</a> <a href="#L-18"> 18</a> <a href="#L-19"> 19</a> <a href="#L-20"> 20</a> <a href="#L-21"> 21</a> <a href="#L-22"> 22</a> <a href="#L-23"> 23</a> <a href="#L-24"> 24</a> <a href="#L-25"> 25</a> <a href="#L-26"> 26</a> <a href="#L-27"> 27</a> <a href="#L-28"> 28</a> <a href="#L-29"> 29</a> <a href="#L-30"> 30</a> <a href="#L-31"> 31</a> <a href="#L-32"> 32</a> <a href="#L-33"> 33</a> <a href="#L-34"> 34</a> <a href="#L-35"> 35</a> <a href="#L-36"> 36</a> <a href="#L-37"> 37</a> <a href="#L-38"> 38</a> <a href="#L-39"> 39</a> <a href="#L-40"> 40</a> <a href="#L-41"> 41</a> <a href="#L-42"> 42</a> <a href="#L-43"> 43</a> <a href="#L-44"> 44</a> <a href="#L-45"> 45</a> <a href="#L-46"> 46</a> <a href="#L-47"> 47</a> <a href="#L-48"> 48</a> <a href="#L-49"> 49</a> <a href="#L-50"> 50</a> <a href="#L-51"> 51</a> <a href="#L-52"> 52</a> <a href="#L-53"> 53</a> <a href="#L-54"> 54</a> <a href="#L-55"> 55</a> <a href="#L-56"> 56</a> <a href="#L-57"> 57</a> <a href="#L-58"> 58</a> <a href="#L-59"> 59</a> <a href="#L-60"> 60</a> <a href="#L-61"> 61</a> <a href="#L-62"> 62</a> <a href="#L-63"> 63</a> <a href="#L-64"> 64</a> <a href="#L-65"> 65</a> <a href="#L-66"> 66</a> <a href="#L-67"> 67</a> <a href="#L-68"> 68</a> <a href="#L-69"> 69</a> <a href="#L-70"> 70</a> <a href="#L-71"> 71</a> <a href="#L-72"> 72</a> <a href="#L-73"> 73</a> <a href="#L-74"> 74</a> <a href="#L-75"> 75</a> <a href="#L-76"> 76</a> <a href="#L-77"> 77</a> <a href="#L-78"> 78</a> <a href="#L-79"> 79</a> <a href="#L-80"> 80</a> <a href="#L-81"> 81</a> <a href="#L-82"> 82</a> <a href="#L-83"> 83</a> <a href="#L-84"> 84</a> <a href="#L-85"> 85</a> <a href="#L-86"> 86</a> <a href="#L-87"> 87</a> <a href="#L-88"> 88</a> <a href="#L-89"> 89</a> <a href="#L-90"> 90</a> <a href="#L-91"> 91</a> <a href="#L-92"> 92</a> <a href="#L-93"> 93</a> <a href="#L-94"> 94</a> <a href="#L-95"> 95</a> <a href="#L-96"> 96</a> <a href="#L-97"> 97</a> <a href="#L-98"> 98</a> <a href="#L-99"> 99</a> <a href="#L-100">100</a> <a href="#L-101">101</a> <a href="#L-102">102</a> <a href="#L-103">103</a> <a href="#L-104">104</a> <a href="#L-105">105</a> <a href="#L-106">106</a> <a href="#L-107">107</a> <a href="#L-108">108</a> <a href="#L-109">109</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">using</span> <span class="nn">System</span><span class="p">;</span> </span><span id="L-2"><a name="L-2"></a><span class="k">using</span> <span class="nn">System.Data</span><span class="p">;</span> </span><span id="L-3"><a name="L-3"></a><span class="k">using</span> <span class="nn">System.Configuration</span><span class="p">;</span> </span><span id="L-4"><a name="L-4"></a><span class="k">using</span> <span class="nn">System.Web</span><span class="p">;</span> </span><span id="L-5"><a name="L-5"></a><span class="k">using</span> <span class="nn">System.Web.Security</span><span class="p">;</span> </span><span id="L-6"><a name="L-6"></a><span class="k">using</span> <span class="nn">System.Web.UI</span><span class="p">;</span> </span><span id="L-7"><a name="L-7"></a><span class="k">using</span> <span class="nn">System.Web.UI.HtmlControls</span><span class="p">;</span> </span><span id="L-8"><a name="L-8"></a><span class="k">using</span> <span class="nn">System.Web.UI.WebControls</span><span class="p">;</span> </span><span id="L-9"><a name="L-9"></a><span class="k">using</span> <span class="nn">System.Web.UI.WebControls.WebParts</span><span class="p">;</span> </span><span id="L-10"><a name="L-10"></a><span class="k">using</span> <span class="nn">DataSetToDoTableAdapters</span><span class="p">;</span> </span><span id="L-11"><a name="L-11"></a><span class="k">using</span> <span class="nn">System.ComponentModel</span><span class="p">;</span> </span><span id="L-12"><a name="L-12"></a> </span><span id="L-13"><a name="L-13"></a><span class="c1">/// &lt;summary&gt;</span> </span><span id="L-14"><a name="L-14"></a><span class="c1">/// Summary description for ClassBLL</span> </span><span id="L-15"><a name="L-15"></a><span class="c1">/// &lt;/summary&gt;</span> </span><span id="L-16"><a name="L-16"></a><span class="na">[Serializable, DataObject()]</span> </span><span id="L-17"><a name="L-17"></a><span class="k">public</span> <span class="k">class</span> <span class="nc">ClassBLL</span> </span><span id="L-18"><a name="L-18"></a><span class="p">{</span> </span><span id="L-19"><a name="L-19"></a> <span class="cp">#region [Class Members]</span> </span><span id="L-20"><a name="L-20"></a> </span><span id="L-21"><a name="L-21"></a> <span class="k">private</span> <span class="n">DBTableAdapter</span> <span class="n">_adapterDB</span><span class="p">;</span> </span><span id="L-22"><a name="L-22"></a> </span><span id="L-23"><a name="L-23"></a> <span class="cp">#endregion</span> </span><span id="L-24"><a name="L-24"></a> </span><span id="L-25"><a name="L-25"></a> <span class="cp">#region [Constrators]</span> </span><span id="L-26"><a name="L-26"></a> </span><span id="L-27"><a name="L-27"></a> <span class="c1">/// &lt;summary&gt;</span> </span><span id="L-28"><a name="L-28"></a> <span class="c1">/// Default constructor.</span> </span><span id="L-29"><a name="L-29"></a> <span class="c1">/// &lt;/summary&gt;</span> </span><span id="L-30"><a name="L-30"></a> <span class="k">public</span> <span class="nf">ClassBLL</span><span class="p">()</span> </span><span id="L-31"><a name="L-31"></a> <span class="p">{</span> </span><span id="L-32"><a name="L-32"></a> </span><span id="L-33"><a name="L-33"></a> <span class="p">}</span> </span><span id="L-34"><a name="L-34"></a> </span><span id="L-35"><a name="L-35"></a> <span class="cp">#endregion</span> </span><span id="L-36"><a name="L-36"></a> </span><span id="L-37"><a name="L-37"></a> <span class="cp">#region [Methods]</span> </span><span id="L-38"><a name="L-38"></a> </span><span id="L-39"><a name="L-39"></a> <span class="c1">/// &lt;summary&gt;</span> </span><span id="L-40"><a name="L-40"></a> <span class="c1">/// Delete an item.</span> </span><span id="L-41"><a name="L-41"></a> <span class="c1">/// &lt;/summary&gt;</span> </span><span id="L-42"><a name="L-42"></a> <span class="c1">/// &lt;param name=&quot;Original_Id&quot;&gt;Integer. ItemId.&lt;/param&gt;</span> </span><span id="L-43"><a name="L-43"></a> <span class="c1">/// &lt;returns&gt;Integer. Number of affected items.&lt;/returns&gt;</span> </span><span id="L-44"><a name="L-44"></a><span class="na"> [DataObjectMethodAttribute(DataObjectMethodType.Delete, true)]</span> </span><span id="L-45"><a name="L-45"></a> <span class="k">public</span> <span class="kt">int</span> <span class="nf">Delete</span><span class="p">(</span><span class="kt">int</span> <span class="n">Original_Id</span><span class="p">)</span> </span><span id="L-46"><a name="L-46"></a> <span class="p">{</span> </span><span id="L-47"><a name="L-47"></a> <span class="k">return</span> <span class="p">(</span><span class="n">AdapterDB</span><span class="p">.</span><span class="n">Delete</span><span class="p">(</span><span class="n">Original_Id</span><span class="p">));</span> </span><span id="L-48"><a name="L-48"></a> <span class="p">}</span> </span><span id="L-49"><a name="L-49"></a> </span><span id="L-50"><a name="L-50"></a> <span class="c1">/// &lt;summary&gt;</span> </span><span id="L-51"><a name="L-51"></a> <span class="c1">/// Insert a new item.</span> </span><span id="L-52"><a name="L-52"></a> <span class="c1">/// &lt;/summary&gt;</span> </span><span id="L-53"><a name="L-53"></a> <span class="c1">/// &lt;param name=&quot;?&quot;&gt;Type. Description.&lt;/param&gt;</span> </span><span id="L-54"><a name="L-54"></a> <span class="c1">/// &lt;returns&gt;Integer. Number of affected items.&lt;/returns&gt;</span> </span><span id="L-55"><a name="L-55"></a><span class="na"> [DataObjectMethodAttribute(DataObjectMethodType.Insert, true)]</span> </span><span id="L-56"><a name="L-56"></a> <span class="k">public</span> <span class="nf">cInsert</span><span class="p">(?)</span> </span><span id="L-57"><a name="L-57"></a> <span class="p">{</span> </span><span id="L-58"><a name="L-58"></a> <span class="k">return</span> <span class="p">(</span><span class="n">AdapterDB</span><span class="p">.</span><span class="n">Insert</span><span class="p">(?));</span> </span><span id="L-59"><a name="L-59"></a> <span class="p">}</span> </span><span id="L-60"><a name="L-60"></a> </span><span id="L-61"><a name="L-61"></a> <span class="c1">/// &lt;summary&gt;</span> </span><span id="L-62"><a name="L-62"></a> <span class="c1">/// Get item by its id.</span> </span><span id="L-63"><a name="L-63"></a> <span class="c1">/// &lt;/summary&gt;</span> </span><span id="L-64"><a name="L-64"></a> <span class="c1">/// &lt;param name=&quot;intItemId&quot;&gt;Integer. Item Id.&lt;/param&gt;</span> </span><span id="L-65"><a name="L-65"></a> <span class="c1">/// &lt;returns&gt;DBDataTable&lt;/returns&gt;</span> </span><span id="L-66"><a name="L-66"></a><span class="na"> [DataObjectMethodAttribute(DataObjectMethodType.Select, true)]</span> </span><span id="L-67"><a name="L-67"></a> <span class="k">public</span> <span class="n">DataSetDB</span><span class="p">.</span><span class="n">DBDataTable</span> <span class="n">GetItem</span><span class="p">(</span><span class="kt">int</span> <span class="n">intItemId</span><span class="p">)</span> </span><span id="L-68"><a name="L-68"></a> <span class="p">{</span> </span><span id="L-69"><a name="L-69"></a> <span class="k">return</span> <span class="p">(</span><span class="n">AdapterDB</span><span class="p">.</span><span class="n">GetDataById</span><span class="p">(</span><span class="n">intItemId</span><span class="p">));</span> </span><span id="L-70"><a name="L-70"></a> <span class="p">}</span> </span><span id="L-71"><a name="L-71"></a> </span><span id="L-72"><a name="L-72"></a> </span><span id="L-73"><a name="L-73"></a> <span class="c1">/// &lt;summary&gt;</span> </span><span id="L-74"><a name="L-74"></a> <span class="c1">/// Update an item.</span> </span><span id="L-75"><a name="L-75"></a> <span class="c1">/// &lt;/summary&gt;</span> </span><span id="L-76"><a name="L-76"></a> <span class="c1">/// &lt;param name=&quot;?&quot;&gt;Type. Description.&lt;/param&gt;</span> </span><span id="L-77"><a name="L-77"></a> <span class="c1">/// &lt;param name=&quot;original_Id&quot;&gt;Integer. Template id.&lt;/param&gt;</span> </span><span id="L-78"><a name="L-78"></a><span class="na"> [DataObjectMethodAttribute(DataObjectMethodType.Update, true)]</span> </span><span id="L-79"><a name="L-79"></a> <span class="k">public</span> <span class="kt">int</span> <span class="nf">Update</span><span class="p">(?,</span> <span class="kt">int</span> <span class="n">Original_Id</span><span class="p">)</span> </span><span id="L-80"><a name="L-80"></a> <span class="p">{</span> </span><span id="L-81"><a name="L-81"></a> <span class="k">return</span> <span class="p">(</span><span class="n">AdapterDB</span><span class="p">.</span><span class="n">Update</span><span class="p">(?,</span> <span class="n">Original_Id</span><span class="p">));</span> </span><span id="L-82"><a name="L-82"></a> <span class="p">}</span> </span><span id="L-83"><a name="L-83"></a> </span><span id="L-84"><a name="L-84"></a> <span class="cp">#endregion</span> </span><span id="L-85"><a name="L-85"></a> </span><span id="L-86"><a name="L-86"></a> <span class="cp">#region [Class Properties]</span> </span><span id="L-87"><a name="L-87"></a> </span><span id="L-88"><a name="L-88"></a> </span><span id="L-89"><a name="L-89"></a> </span><span id="L-90"><a name="L-90"></a> <span class="cp">#endregion</span> </span><span id="L-91"><a name="L-91"></a> </span><span id="L-92"><a name="L-92"></a> <span class="cp">#region [Data Adapters]</span> </span><span id="L-93"><a name="L-93"></a> </span><span id="L-94"><a name="L-94"></a> <span class="c1">/// &lt;summary&gt;</span> </span><span id="L-95"><a name="L-95"></a> <span class="c1">/// DB table adapter.</span> </span><span id="L-96"><a name="L-96"></a> <span class="c1">/// &lt;/summary&gt;</span> </span><span id="L-97"><a name="L-97"></a> <span class="k">public</span> <span class="n">DBTableAdapter</span> <span class="n">AdapterDB</span> </span><span id="L-98"><a name="L-98"></a> <span class="p">{</span> </span><span id="L-99"><a name="L-99"></a> <span class="k">get</span> </span><span id="L-100"><a name="L-100"></a> <span class="p">{</span> </span><span id="L-101"><a name="L-101"></a> <span class="k">if</span><span class="p">(</span><span class="n">_adapterDB</span><span class="p">==</span> <span class="k">null</span><span class="p">)</span> </span><span id="L-102"><a name="L-102"></a> <span class="n">_adapterDB</span> <span class="p">=</span> <span class="k">new</span> <span class="n">DBTableAdapter</span><span class="p">();</span> </span><span id="L-103"><a name="L-103"></a> </span><span id="L-104"><a name="L-104"></a> <span class="k">return</span><span class="p">(</span><span class="n">_adapterDB</span><span class="p">);</span> </span><span id="L-105"><a name="L-105"></a> <span class="p">}</span> </span><span id="L-106"><a name="L-106"></a> <span class="p">}</span> </span><span id="L-107"><a name="L-107"></a> </span><span id="L-108"><a name="L-108"></a> <span class="cp">#endregion</span> </span><span id="L-109"><a name="L-109"></a><span class="p">}</span> </span></pre></div> </td></tr></table>
bll, class, template