public bool IsCurrentUserImpersonatingProgramManagerOnProject(int idProject, int idAssociate, int idImpersonated)
{
bool result = false;
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "authIsAssociateKeyUserImpersonatingManagerOnProject";
SqlParameter idProjectPar = new SqlParameter("@IdProject", idProject);
idProjectPar.DbType = DbType.Int32;
idProjectPar.Direction = ParameterDirection.Input;
command.Parameters.Add(idProjectPar);
SqlParameter idAssociatePar = new SqlParameter("@IdAssociate", idAssociate);
idAssociatePar.DbType = DbType.Int32;
idAssociatePar.Direction = ParameterDirection.Input;
command.Parameters.Add(idAssociatePar);
SqlParameter idImpersonatedPar = new SqlParameter("@IdImpersonated", idImpersonated);
idImpersonatedPar.DbType = DbType.Int32;
idImpersonatedPar.Direction = ParameterDirection.Input;
command.Parameters.Add(idImpersonatedPar);
result = Convert.ToBoolean(CurrentConnectionManager.ExecuteScalar(command));
return(result);
}
/// <summary>
/// Gets information about the user, if his inergy login exists in the database
/// </summary>
/// <param name="InergyLogin">the inergy login of the user</param>
/// <returns>a DataTable containing one row with information about the user, or an empty datatable if the user
/// does not have a valid inergy login</returns>
public DataTable GetUserDetails(string inergyLogin, int idCountry)
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "authVerifyLogin";
SqlParameter inergyLoginParameter = new SqlParameter("@InergyLogin", inergyLogin);
inergyLoginParameter.DbType = DbType.String;
inergyLoginParameter.Direction = ParameterDirection.Input;
SqlParameter idCountryParameter;
if (idCountry == ApplicationConstants.INT_NULL_VALUE)
{
idCountryParameter = new SqlParameter("@IdCountry", DBNull.Value);
}
else
{
idCountryParameter = new SqlParameter("@IdCountry", idCountry);
}
idCountryParameter.DbType = DbType.Int32;
idCountryParameter.Direction = ParameterDirection.Input;
command.Parameters.Add(inergyLoginParameter);
command.Parameters.Add(idCountryParameter);
return(CurrentConnectionManager.GetDataTable(command));
}
public DataSet SelectObjectForDisplay(IGenericEntity ent)
{
this.storedProcedures.Clear();
InitializeObject(ent);
if (!storedProcedures.ContainsKey("SelectObjectForDisplay"))
{
throw new NotImplementedException(ApplicationMessages.EXCEPTION_IMPLEMENT_SELECTOBJECT);
}
DBStoredProcedure selectSP = storedProcedures["SelectObjectForDisplay"];
SqlCommand cmd = selectSP.GetSqlCommand();
DataSet returnDS = null;
try
{
returnDS = CurrentConnectionManager.GetDataSet(cmd);
}
catch (SqlException exc)
{
throw new IndException(exc);
}
return(returnDS);
}
/// <summary>
/// 停止
/// </summary>
public void Stop()
{
if (IsWorking)
{
IsWorking = false;
Utility.Debuger.DebugLog("Socket Server:Stoping....");
CurrentConnectionManager.Each((client) =>
{
//服务器关闭
DisConnectClient(client, 0);
return(false);
});
CurrentConnectionManager.Clear();
MREvent.Set();
SendMREvent.Set();
AcceptThread.Join();
SendThread.Join();
SendThread = null;
AcceptThread = null;
_socket.Close();
_socket = null;
}
}
/// <summary>
///
/// </summary>
/// <param name="ent"></param>
public DataTable GetAsscoiateRoles()
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "authSelectProfile";
return(CurrentConnectionManager.GetDataTable(command));
}
/// <summary>
/// Inserts all work selected work packages (wppreselection screen) into temp table ##BUDGET_PRESELECTION_TEMP
/// </summary>
/// <param name="commandText"></param>
public void BulkInsert(string commandText)
{
SqlCommand bulkInsertCommand = new SqlCommand();
bulkInsertCommand.CommandType = CommandType.Text;
bulkInsertCommand.CommandText = commandText;
CurrentConnectionManager.ExecuteTextCommand(bulkInsertCommand);
}
/// <summary>
/// Gets information about the projects that this user is part of
/// </summary>
/// <param name="idCurrentUser">the id of the current user</param>
/// <returns>A DataTable containing information about the projects that this user is part of</returns>
public DataTable GetUserProjects(int idCurrentUser)
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "authSelectUserProjects";
SqlParameter idCurrentUserParameter = new SqlParameter("@IdUser", idCurrentUser);
idCurrentUserParameter.DbType = DbType.Int32;
idCurrentUserParameter.Direction = ParameterDirection.Input;
command.Parameters.Add(idCurrentUserParameter);
return(CurrentConnectionManager.GetDataTable(command));
}
public DataTable GetAssociateRole(int idAssociate)
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "authSelectRoles";
SqlParameter idAssociateParameter = new SqlParameter("@IdAssociate", idAssociate);
idAssociateParameter.DbType = DbType.Int32;
idAssociateParameter.Direction = ParameterDirection.Input;
command.Parameters.Add(idAssociateParameter);
return(CurrentConnectionManager.GetDataTable(command));
}
public DataTable GetUserCountries(string inergyLogin)
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "authSelectUserCountries";
SqlParameter inergyLoginParameter = new SqlParameter("@InergyLogin", inergyLogin);
inergyLoginParameter.DbType = DbType.String;
inergyLoginParameter.Direction = ParameterDirection.Input;
command.Parameters.Add(inergyLoginParameter);
return(CurrentConnectionManager.GetDataTable(command));
}
/// <summary>
/// method used to retrieve user settings from database
/// </summary>
/// <param name="associateId"></param>
public DataTable usrSelectUserSettings(int associateId)
{
DataTable dt = new DataTable();
try
{
SqlCommand cmd = new SqlCommand("usrSelectUserSettings");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssociateId", SqlDbType.Int).Value = associateId;
dt = CurrentConnectionManager.GetDataTable(cmd);
}
catch (SqlException ex)
{
throw new IndException(ex);
}
return(dt);
}
/// <summary>
/// Updates or inserts a new associate to a role
/// </summary>
/// <param name="idAssociate">the id of the associate</param>
/// <param name="idRole">the id of the role</param>
/// <returns>the number of affected rows (should be 1 )</returns>
public int SaveAssociateRole(int idAssociate, int idRole)
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "authUpdateAssociateRole";
SqlParameter idAssociateParameter = new SqlParameter("@IdAssociate", idAssociate);
idAssociateParameter.DbType = DbType.Int32;
idAssociateParameter.Direction = ParameterDirection.Input;
command.Parameters.Add(idAssociateParameter);
SqlParameter idRoleParameter = new SqlParameter("@IdRole", idRole);
idRoleParameter.DbType = DbType.Int32;
idRoleParameter.Direction = ParameterDirection.Input;
command.Parameters.Add(idRoleParameter);
return(CurrentConnectionManager.ExecuteStoredProcedure(command));
}
/// <summary>
/// method used to update user settings
/// </summary>
/// <param name=""></param>
/// <returns>return true if operation succeded</returns>
public bool usrInsertOrUpdateUserSettings(IUserSettings userSettings)
{
int returnValue;
try
{
SqlCommand cmd = new SqlCommand("usrInsertOrUpdateUserSettings");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AssociateId", SqlDbType.Int).Value = userSettings.AssociateId;
cmd.Parameters.Add("@AmountScaleOption", SqlDbType.Int).Value = userSettings.AmountScaleOption;
cmd.Parameters.Add("@NumberOfRecordsPerPage", SqlDbType.Int).Value = userSettings.NumberOfRecordsPerPage;
cmd.Parameters.Add("@CurrencyRepresentation", SqlDbType.Int).Value = userSettings.CurrencyRepresentation;
returnValue = CurrentConnectionManager.ExecuteStoredProcedure(cmd);
}
catch (SqlException ex)
{
throw new IndException(ex);
}
return(returnValue == 1);
}
private void OnAccpet(IAsyncResult ar)
{
MREvent.Set();
if (IsWorking)
{
Socket server = (Socket)ar.AsyncState;
Socket client = server.EndAccept(ar);
if (client != null)
{
client.NoDelay = true;
if (CurrentConnectionManager.Count >= MaxClient)
{
try
{
client.Close();
}
finally
{
}
}
else
{
var nClient = CurrentConnectionManager.CreateClient(client, this);
try
{
nClient.Socket.BeginReceive(nClient.Buffer, 0,
nClient.Buffer.Length,
SocketFlags.None,
new AsyncCallback(OnDataReceived), nClient);
OnConnect(nClient);
}
catch (Exception ex)
{
HandleException(nClient, ex);
}
}
}
}
}
public void Start()
{
OnStart();
IsWorking = true;
CurrentConnectionManager.Clear();
_socket = new Socket(IPAddress.Any.AddressFamily, SocketType.Stream, ProtocolType.Tcp);
//_socket.SendTimeout = 999;
//_socket.ReceiveTimeout = 999;
_socket.LingerState = new LingerOption(true, 10);
_socket.Bind(new IPEndPoint(IPAddress.Any, Port));
_socket.Listen(2000);
AcceptThread = new Thread(new ThreadStart(ThreadRun));
AcceptThread.IsBackground = true;
AcceptThread.Start();
SendThread = new Thread(new ThreadStart(SendMessage));
SendThread.IsBackground = true;
SendThread.Start();
Debuger.DebugLog("Server Listen at port:" + Port);
}
private bool HaveClient(Client client)
{
return(CurrentConnectionManager.Exisit(client));
}
private void RemoveClient(Client client)
{
client.Close();
CurrentConnectionManager.RemoveClient(client);
OnCloseConnection(client);
}
