private MC3DeptInfo GetInstanceInfoByDepartmentId(int department_id)
{
MC3DeptInfo _result = new MC3DeptInfo();
string sqlCommand = "SELECT company_guid FROM tbl_company WHERE company_id=" + department_id.ToString();
Database db = GetDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
IDataReader _reader = base.LoadFromSqlReader(dbCommand);
while (_reader.Read())
{
_result.InstanceId = (Guid)_reader[0];
break;
}
_reader.Close();
if (_result.InstanceId == Guid.Empty)
{
return(_result);
}
sqlCommand = "SELECT OrganizationId FROM Mc_Instance WHERE InstanceId='" + _result.InstanceId.ToString() + "'";
dbCommand = db.GetSqlStringCommand(sqlCommand);
_reader = base.LoadFromSqlReader(dbCommand);
while (_reader.Read())
{
_result.OrganizationId = (Guid)_reader[0];
break;
}
_reader.Close();
return(_result);
}
public virtual int IsLoginActive(int department_id, int user_id, string user_name)
{
int _result = -1;
Micajah.Common.Bll.Providers.LoginProvider _login = new Micajah.Common.Bll.Providers.LoginProvider();
Guid _loginId = _login.GetLoginId(user_name);
if (_loginId == Guid.Empty)
{
return(_result);
}
MC3DeptInfo _instInfo = GetInstanceInfoByDepartmentId(department_id);
if (_login.LoginIsActiveInOrganization(_loginId, _instInfo.OrganizationId))
{
_result = 1;
}
else
{
_result = 0;
}
Database db = GetDatabase();
string sqlCommand = "SELECT btUserInactive FROM tbl_LoginCompanyJunc WHERE company_id =" + department_id.ToString() + " AND id =" + user_id.ToString();
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
IDataReader _reader = base.LoadFromSqlReader(dbCommand);
if (_reader != null)
{
while (_reader.Read())
{
bool _res = (bool)_reader[0];
if (!_res)
{
_result = 1;
}
else
{
_result = 0;
}
break;
}
;
_reader.Close();
}
;
return(_result);
}
private MC3DeptInfo GetInstanceInfoByDepartmentId(int department_id)
{
MC3DeptInfo _result = new MC3DeptInfo();
string sqlCommand = "SELECT company_guid FROM tbl_company WHERE company_id=" + department_id.ToString();
Database db = GetDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
IDataReader _reader = base.LoadFromSqlReader(dbCommand);
while (_reader.Read())
{
_result.InstanceId = (Guid)_reader[0];
break;
}
_reader.Close();
if (_result.InstanceId == Guid.Empty) return _result;
sqlCommand = "SELECT OrganizationId FROM Mc_Instance WHERE InstanceId='" + _result.InstanceId.ToString() + "'";
dbCommand = db.GetSqlStringCommand(sqlCommand);
_reader = base.LoadFromSqlReader(dbCommand);
while (_reader.Read())
{
_result.OrganizationId = (Guid)_reader[0];
break;
}
_reader.Close();
return _result;
}
public virtual bool InactivateLogin
(
int UId,
int DId,
bool btAllTkt,
string user_name
)
{
bool _result = true;
MC3DeptInfo _instInfo = GetInstanceInfoByDepartmentId(DId);
if (_instInfo.OrganizationId == Guid.Empty)
{
return(false);
}
Micajah.Common.Bll.Providers.LoginProvider _login = new Micajah.Common.Bll.Providers.LoginProvider();
Guid _userId = _login.GetLoginId(user_name);
if (_userId == Guid.Empty)
{
return(false);
}
Micajah.Common.Bll.Organization _org = Micajah.Common.Bll.Providers.OrganizationProvider.GetOrganization(_instInfo.OrganizationId);
if (_org == null)
{
return(false);
}
Micajah.Common.Bll.Providers.UserProvider.UpdateUserActive(_userId, _org.OrganizationId, false);
// Create the Database object, using the default database service. The
// default database service is determined through configuration.
Database db = GetDatabase();
string sqlCommand = this.SchemaStoredProcedureWithSeparator + "sp_InactivateLogin";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
// Add procedure parameters
db.AddInParameter(dbCommand, "UId", DbType.Int32, UId);
db.AddInParameter(dbCommand, "DId", DbType.Int32, DId);
db.AddInParameter(dbCommand, "btAllTkt", DbType.Boolean, btAllTkt);
base.LoadFromSqlNoExec(dbCommand);
/*
* int ErrorCode = 0;
*
* string _error_code = db.GetParameterValue(dbCommand, "@RETURN_VALUE").ToString();
* if (_error_code.Length > 0)
* ErrorCode = Int32.Parse(_error_code);
* else
* ErrorCode = 0;
*
* if (ErrorCode == 1)
* _result = true;
*/
return(_result);
}
public virtual string UpdateLogin(
int code,
int DId,
int UId,
string user_email_old,
string user_password,
string user_firstname,
string user_lastname,
string user_title,
string user_email,
string Phone,
string MobilePhone,
int location_id,
string user_room,
int intUserType,
byte tintLevel,
string user_note,
bool btUpdateAcct,
int intAcctId,
int intAcctLocId,
int intSupGroupId,
bool btCallCentreRep,
string vchOrganization,
string LdapUserSID,
string LdapUserAccount
)
{
string _result = string.Empty;
MC3DeptInfo _instInfo = GetInstanceInfoByDepartmentId(DId);
Micajah.Common.Bll.Providers.LoginProvider _login = new Micajah.Common.Bll.Providers.LoginProvider();
Guid _loginId = _login.GetLoginId(user_email_old);
System.Collections.ArrayList groupIdList = bigWebApps.bigWebDesk.Data.Logins.GetUserGroups(_instInfo.OrganizationId, _instInfo.InstanceId, intUserType, _loginId);
Exception error = null;
try
{
if (_loginId == Guid.Empty)
{
Micajah.Common.Bll.Providers.UserProvider.AddUserToOrganization(user_email_old, user_email, user_firstname, user_lastname, null, Phone, MobilePhone, null, user_title, null, null, null, null, null, null, null, Micajah.Common.Bll.Support.ConvertListToString(groupIdList), _instInfo.OrganizationId, user_password, false, false);
}
else
{
Micajah.Common.Bll.Providers.UserProvider.UpdateUser(_loginId, user_email, user_firstname, user_lastname, null, Phone, MobilePhone, null, user_title, null, null, null, null, null, null, null, null, null, null, groupIdList, _instInfo.OrganizationId, false);
if (!string.IsNullOrEmpty(user_password))
{
_login.ChangePassword(_loginId, user_password);
}
}
}
catch (System.Net.Mail.SmtpException ex)
{
error = ex;
}
// Create the Database object, using the default database service. The
// default database service is determined through configuration.
Database db = GetDatabase();
string sqlCommand = this.SchemaStoredProcedureWithSeparator + "sp_UpdateLogin";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
// Add procedure parameters
db.AddInParameter(dbCommand, "code", DbType.Int32, code);
db.AddInParameter(dbCommand, "DId", DbType.Int32, DId);
db.AddInParameter(dbCommand, "UId", DbType.Int32, UId);
db.AddInParameter(dbCommand, "user_password", DbType.AnsiString, user_password);
db.AddInParameter(dbCommand, "user_firstname", DbType.AnsiString, user_firstname);
db.AddInParameter(dbCommand, "user_lastname", DbType.AnsiString, user_lastname);
db.AddInParameter(dbCommand, "user_title", DbType.AnsiString, user_title);
db.AddInParameter(dbCommand, "user_email", DbType.AnsiString, user_email);
db.AddInParameter(dbCommand, "Phone", DbType.AnsiString, Phone);
db.AddInParameter(dbCommand, "MobilePhone", DbType.AnsiString, MobilePhone);
db.AddInParameter(dbCommand, "location_id", DbType.Int32, location_id);
if (user_room.Length > 0)
{
db.AddInParameter(dbCommand, "user_room", DbType.AnsiString, user_room);
}
else
{
db.AddInParameter(dbCommand, "user_room", DbType.AnsiString, DBNull);
}
db.AddInParameter(dbCommand, "intUserType", DbType.Int32, intUserType);
if (tintLevel > 0)
{
db.AddInParameter(dbCommand, "tintLevel", DbType.Byte, tintLevel);
}
else
{
db.AddInParameter(dbCommand, "tintLevel", DbType.Byte, DBNull);
}
db.AddInParameter(dbCommand, "user_note", DbType.AnsiString, user_note);
db.AddInParameter(dbCommand, "btUpdateAcct", DbType.Boolean, btUpdateAcct);
if (intAcctId > 0)
{
db.AddInParameter(dbCommand, "intAcctId", DbType.Int32, intAcctId);
}
else
{
db.AddInParameter(dbCommand, "intAcctId", DbType.Int32, DBNull);
}
if (intAcctLocId > 0)
{
db.AddInParameter(dbCommand, "intAcctLocId", DbType.Int32, intAcctLocId);
}
else
{
db.AddInParameter(dbCommand, "intAcctLocId", DbType.Int32, DBNull);
}
if (intSupGroupId > 0)
{
db.AddInParameter(dbCommand, "intSupGroupId", DbType.Int32, intSupGroupId);
}
else
{
db.AddInParameter(dbCommand, "intSupGroupId", DbType.Int32, DBNull);
}
db.AddInParameter(dbCommand, "btCallCentreRep", DbType.Boolean, btCallCentreRep);
if (vchOrganization.Length > 0)
{
db.AddInParameter(dbCommand, "vchOrganization", DbType.AnsiString, vchOrganization);
}
else
{
db.AddInParameter(dbCommand, "vchOrganization", DbType.AnsiString, DBNull);
}
if (LdapUserSID.Length > 0)
{
db.AddInParameter(dbCommand, "LdapUserSID", DbType.AnsiString, LdapUserSID);
}
else
{
db.AddInParameter(dbCommand, "LdapUserSID", DbType.AnsiString, DBNull);
}
if (LdapUserAccount.Length > 0)
{
db.AddInParameter(dbCommand, "LdapUserAccount", DbType.AnsiString, LdapUserAccount);
}
else
{
db.AddInParameter(dbCommand, "LdapUserAccount", DbType.AnsiString, DBNull);
}
//NOT SUPPORTED BY EASY OBJECTS
//db.AddOutParameter(dbCommand, "@RETURN_VALUE", DbType.Int32, DBNull);
base.LoadFromSqlNoExec(dbCommand);
/*
* int ErrorCode=0;
*
* string _error_code = db.GetParameterValue(dbCommand, "@RETURN_VALUE").ToString();
* if (_error_code.Length > 0)
* ErrorCode = Int32.Parse(_error_code);
* else
* ErrorCode = 0;
*
* if (ErrorCode == 1)
* _result = "Email adress: " + user_email +" already exist.";
*/
if (error != null)
{
throw error;
}
return(_result);
}
