internal static DataTable AdapterFill(string sprocName)
{
DataTable dataTable = new DataTable();
try
{
using (SqlConnection con = new SqlConnection(_Connection))
{
SqlCommand cmd = new SqlCommand(sprocName, con);
cmd.CommandType = CommandType.StoredProcedure;
for (int index = 0; index < _ParamName.Count; index++)
{
cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]);
}
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dataTable);
}
}
}
catch (Exception ex)
{
DBCommands.RecordError(ex);
}
finally
{
EmptyParams();
}
return(dataTable);
}
internal static bool ExecuteNonQuery(string sprocName)
{
try
{
using (SqlConnection con = new SqlConnection(_Connection))
{
SqlCommand cmd = new SqlCommand(sprocName, con);
cmd.CommandType = CommandType.StoredProcedure;
for (int index = 0; index < _ParamName.Count; index++)
{
cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]);
}
con.Open();
cmd.ExecuteNonQuery();
return(true);
}
}
catch (Exception ex)
{
DBCommands.RecordError(ex);
return(false);
}
finally
{
EmptyParams();
}
}
public override bool UserInfoUpdate(UserInfo user)
{
DBCommands.PopulateParams("@UserName", user.UserName);
DBCommands.PopulateParams("@ProfileImage", user.ProfileImage);
DBCommands.PopulateParams("@GroupUsers", MapGroupListToTable(user.GroupUsers));
return(DBCommands.ExecuteNonQuery("p_UserInfo_Update"));
}
internal static string ExecuteScalar(string sprocName)
{
try
{
using (SqlConnection con = new SqlConnection(_Connection))
{
SqlCommand cmd = new SqlCommand(sprocName, con);
cmd.CommandType = CommandType.StoredProcedure;
for (int index = 0; index < _ParamName.Count; index++)
{
cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]);
}
con.Open();
var result = cmd.ExecuteScalar();
if (result != null)
{
return(result.ToString());
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
DBCommands.RecordError(ex);
return(null);
}
finally
{
EmptyParams();
}
}
public override DataTable UserGroupsGetActive()
{
return(DBCommands.AdapterFill("p_UserGroup_GetActive"));
}
public override DataTable GroupUsersGetByUserName(string userName)
{
DBCommands.PopulateParams("@UserName", userName);
return(DBCommands.AdapterFill("p_GroupUsers_GetByUserName"));
}
public override UserInfo UserInfoGetByUser(string userName)
{
DBCommands.PopulateParams("@UserName", userName);
return((UserInfo)DBCommands.DataReader("p_UserInfo_GetByUser", DBCommands.ObjectTypes.UserInfo));
}
public override DataTable UserInfoGetAll()
{
return(DBCommands.AdapterFill("p_UserInfo_GetAll"));
}