[LEFT]using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace SOC
{
public class ClsDL_User
{
public SqlDataAdapter User_da;
public DataSet User_ds;
private SqlCommand User_cmd_ins;
private SqlCommand User_cmd_sel;
private SqlCommand User_cmd_del;
private SqlCommand User_cmd_upd;
public ClsDL_User()
{
#region SQL COMMAND & SQL DATA ADAPTER
User_da = new SqlDataAdapter();
User_cmd_sel = new SqlCommand();
User_cmd_ins = new SqlCommand();
User_cmd_del = new SqlCommand();
User_cmd_upd = new SqlCommand();
#endregion
#region DATASET
User_ds = new DataSet();
User_ds.Tables.Add("User");
#endregion
#region SELECT PART
User_cmd_sel.Connection = SQLCon.Con;
User_cmd_sel.CommandText = "Usr_User_Select";
User_cmd_sel.CommandType = System.Data.CommandType.StoredProcedure;
User_cmd_sel.Parameters.Add("@FullList", SqlDbType.Bit, 1);
User_da.SelectCommand = User_cmd_sel;
#endregion
#region INSERT PART
User_cmd_ins.Connection = SQLCon.Con;
User_cmd_ins.CommandText = "Usr_User_Insert";
User_cmd_ins.CommandType = CommandType.StoredProcedure;
User_cmd_ins.Parameters.Add("@User_Username", SqlDbType.NVarChar, 50, "User_Username");
User_cmd_ins.Parameters.Add("@User_Password", SqlDbType.NVarChar, 50, "User_Password");
User_cmd_ins.Parameters.Add("@User_Description", SqlDbType.NVarChar, 300, "User_Description");
User_cmd_ins.Parameters.Add("@IDF_LookAndFeel", SqlDbType.TinyInt, 1, "IDF_LookAndFeel");
User_cmd_ins.Parameters.Add("@IDF_Persons", SqlDbType.Decimal, 18, "IDF_Persons");
User_cmd_ins.Parameters.Add("@User_IsActive", SqlDbType.Bit, 1, "User_IsActive");
User_cmd_ins.Parameters.Add("@User_IsAdmin", SqlDbType.Bit, 1, "User_IsAdmin");
User_cmd_ins.Parameters.Add("@IDF_User", SqlDbType.Decimal, 18, "IDF_User");
User_cmd_ins.Parameters.Add("@SystemIP", SqlDbType.NVarChar, 15, "SystemIP");
User_cmd_ins.Parameters.Add("@Log_Year", SqlDbType.Int, 4, "Log_Year");
User_cmd_ins.Parameters.Add("@Log_Mon", SqlDbType.TinyInt, 1, "Log_Mon");
User_cmd_ins.Parameters.Add("@Log_Day", SqlDbType.TinyInt, 1, "Log_Day");
User_cmd_ins.Parameters.Add("@Log_Time", SqlDbType.NVarChar, 8, "Log_Time");
User_da.InsertCommand = User_cmd_ins;
System.Data.SqlClient.SqlParameter myParm = User_da.InsertCommand.Parameters.Add("@ID_User", SqlDbType.Decimal, 18, "ID_User");
myParm.Direction = ParameterDirection.Output;
#endregion
#region DELETE PART
User_cmd_del.Connection = SQLCon.Con;
User_cmd_del.CommandText = "Usr_User_Delete";
User_cmd_del.CommandType = System.Data.CommandType.StoredProcedure;
User_cmd_del.Parameters.Add("@ID_User", System.Data.SqlDbType.Decimal, 18, "ID_User");
User_cmd_del.Parameters.Add("@IDF_User", SqlDbType.Decimal, 18, "IDF_User");
User_cmd_del.Parameters.Add("@SystemIP", SqlDbType.NVarChar, 15, "SystemIP");
User_cmd_del.Parameters.Add("@Log_Year", SqlDbType.Int, 4, "Log_Year");
User_cmd_del.Parameters.Add("@Log_Mon", SqlDbType.TinyInt, 1, "Log_Mon");
User_cmd_del.Parameters.Add("@Log_Day", SqlDbType.TinyInt, 1, "Log_Day");
User_cmd_del.Parameters.Add("@Log_Time", SqlDbType.NVarChar, 8, "Log_Time");
User_da.DeleteCommand = User_cmd_del;
#endregion
#region UPDATE PART
User_cmd_upd.Connection = SQLCon.Con;
User_cmd_upd.CommandText = "Usr_User_Update";
User_cmd_upd.CommandType = CommandType.StoredProcedure;
User_cmd_upd.Parameters.Add("@ID_User", SqlDbType.Decimal, 18, "ID_User");
User_cmd_upd.Parameters.Add("@User_Username", SqlDbType.NVarChar, 50, "User_Username");
User_cmd_upd.Parameters.Add("@User_Password", SqlDbType.NVarChar, 50, "User_Password");
User_cmd_upd.Parameters.Add("@User_Description", SqlDbType.NVarChar, 300, "User_Description");
User_cmd_upd.Parameters.Add("@IDF_LookAndFeel", SqlDbType.TinyInt, 1, "IDF_LookAndFeel");
User_cmd_upd.Parameters.Add("@User_IsActive", SqlDbType.Bit, 1, "User_IsActive");
User_cmd_upd.Parameters.Add("@User_IsAdmin", SqlDbType.Bit, 1, "User_IsAdmin");
//User_cmd_upd.Parameters.Add("IDF_Persons", SqlDbType.Decimal, 18, "IDF_Persons");
User_cmd_upd.Parameters.Add("@IDF_User", SqlDbType.Decimal, 18, "IDF_User");
User_cmd_upd.Parameters.Add("@SystemIP", SqlDbType.NVarChar, 15, "SystemIP");
User_cmd_upd.Parameters.Add("@Log_Year", SqlDbType.Int, 4, "Log_Year");
User_cmd_upd.Parameters.Add("@Log_Mon", SqlDbType.TinyInt, 1, "Log_Mon");
User_cmd_upd.Parameters.Add("@Log_Day", SqlDbType.TinyInt, 1, "Log_Day");
User_cmd_upd.Parameters.Add("@Log_Time", SqlDbType.NVarChar, 8, "Log_Time");
User_da.UpdateCommand = User_cmd_upd;
#endregion
}
public void User_Select(bool FullList)
{
lock (SQLCon.Con)
{
this.User_ds.Tables["User"].Clear();
this.User_cmd_sel.Parameters["@FullList"].Value = FullList;
this.User_da.Fill(this.User_ds, "User");
}
}
}
}
[/LEFT]