public JObject AgentsMangement(String connection, UserDefinedClasses.Agent agentsObj)
{
try
{
if (agentsObj.Mode == 1 || agentsObj.Mode == 3)
{
if (string.IsNullOrEmpty(Convert.ToString(agentsObj.Password)) != true)
{
string hashPassword = string.Empty;
byte[] bytesBefore = Encoding.Unicode.GetBytes(agentsObj.Password);
byte[] bytesAfter = HashAlgorithm.Create("SHA1").ComputeHash(bytesBefore);
hashPassword = Convert.ToBase64String(bytesAfter);
agentsObj.Password = hashPassword;
}
}
Press3.DataAccessLayer.Agent agentObject = new Press3.DataAccessLayer.Agent(connection);
DataSet ds = agentObject.AgentsManagement(agentsObj);
if (ds == null)
{
helper.CreateProperty(UDC.Label.MESSAGE, "No data returned from database");
helper.CreateProperty(UDC.Label.SUCCESS, false);
}
else
{
helper.ParseDataSet(ds);
}
}
catch (Exception ex)
{
Logger.Error("Exception In GetAgentStatuses " + ex.ToString());
}
return(helper.GetResponse());
}
private JObject AgentsManagement(HttpContext context)
{
JObject responseJObj = new JObject();
try
{
UserDefinedClasses.Agent agentsobj = new UserDefinedClasses.Agent();
agentsobj.Mode = Convert.ToInt32(context.Request["Mode"]);
agentsobj.AccountId = accountId;
if (Convert.ToInt32(context.Request["Mode"]) == 1 || Convert.ToInt32(context.Request["Mode"]) == 3)
{
agentsobj.Name = context.Request["FullName"].ToString();
agentsobj.FirstName = context.Request["FirstName"].ToString();
agentsobj.LastName = context.Request["LastName"].ToString();
agentsobj.Mobile = context.Request["Mobile"].ToString();
agentsobj.Email = context.Request["Email"].ToString();
agentsobj.Password = Convert.ToString(context.Request["Password"]);
agentsobj.RoleId = Convert.ToInt32(context.Request["Role"]);
agentsobj.PhoneType = Convert.ToInt32(context.Request["PhoneType"]);
agentsobj.Skills = context.Request["Skill"].ToString();
agentsobj.AccountStatusId = Convert.ToInt32(context.Request["ProfileStatus"]);
agentsobj.ReportingManagerIds = context.Request["ReportingManagers"].ToString();
agentsobj.ReportingSupervisorIds = context.Request["ReportingSupervisors"].ToString();
agentsobj.Id = Convert.ToInt32(context.Request["AgentId"]);
agentsobj.SipUserName = context.Request["SipUserName"].ToString();
agentsobj.SipUserPassword = Convert.ToString(context.Request["SipUserPassword"]);
agentsobj.gatewayID = Convert.ToInt32(context.Request["gatewayID"]);
agentsobj.PortNumber = context.Request["PortNumber"].ToString();
agentsobj.LoginType = Convert.ToInt32(context.Request["LoginType"]);
agentsobj.OutBoundAccessType = Convert.ToInt32(context.Request["OutBoundAccessType"]);
string str = Convert.ToString(context.Request["ProfileImage"]);
if (!String.IsNullOrEmpty(Convert.ToString(context.Request["ProfileImage"])))
{
Image _image = null;
MemoryStream mStream = new MemoryStream();
byte[] byteArr;
string tempStoragePath = HttpContext.Current.Server.MapPath("/Images/ProfileImages/");
string tempFileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".jpg";
byteArr = Convert.FromBase64String(context.Request["ProfileImage"].ToString().Replace(" ", "+").Replace("data:image/png;base64,", ""));
mStream = new MemoryStream(byteArr);
_image = Image.FromStream(mStream);
_image.Save(tempStoragePath + tempFileName);
agentsobj.ProfileImagePath = "/Images/ProfileImages/" + tempFileName;
}
}
else if (Convert.ToInt32(context.Request["Mode"]) == 2)
{
agentsobj.Id = Convert.ToInt32(context.Request["AgentId"]);
}
Press3.BusinessRulesLayer.Agent agentObject = new Press3.BusinessRulesLayer.Agent();
responseJObj = agentObject.AgentsMangement(MyConfig.MyConnectionString, agentsobj);
}
catch (Exception ex)
{
Logger.Error(ex.ToString());
}
return(responseJObj);
}
public DataSet AgentsManagement(UserDefinedClasses.Agent agentObj)
{
_cmd = new SqlCommand();
_da = new SqlDataAdapter();
_ds = new DataSet();
try
{
_cmd.CommandText = "AgentsManagement";
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Connection = Connection;
_cmd.Parameters.Add("@Mode", SqlDbType.TinyInt).Value = agentObj.Mode;
_cmd.Parameters.Add("@AccountId", SqlDbType.BigInt).Value = agentObj.AccountId;
_cmd.Parameters.Add("@AgentId", SqlDbType.BigInt).Value = agentObj.Id;
if (agentObj.Mode == 1 || agentObj.Mode == 3)
{
_cmd.Parameters.Add("@FullName", SqlDbType.VarChar, 200).Value = agentObj.Name;
_cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 100).Value = agentObj.FirstName;
_cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 100).Value = agentObj.LastName;
_cmd.Parameters.Add("@Email", SqlDbType.VarChar, 500).Value = agentObj.Email;
_cmd.Parameters.Add("@Mobile", SqlDbType.VarChar, 20).Value = agentObj.Mobile;
_cmd.Parameters.Add("@Password", SqlDbType.VarChar, 200).Value = agentObj.Password;
_cmd.Parameters.Add("@Role", SqlDbType.Int).Value = agentObj.RoleId;
_cmd.Parameters.Add("@DeviceType", SqlDbType.Int, 100).Value = agentObj.PhoneType;
_cmd.Parameters.Add("@AccountStatusId", SqlDbType.TinyInt).Value = agentObj.AccountStatusId;
_cmd.Parameters.Add("@Skills", SqlDbType.VarChar, -1).Value = agentObj.Skills;
_cmd.Parameters.Add("@SipUserName", SqlDbType.VarChar, 50).Value = agentObj.SipUserName;
_cmd.Parameters.Add("@SipUserPassword", SqlDbType.VarChar, 50).Value = agentObj.SipUserPassword;
_cmd.Parameters.Add("@gatewayID", SqlDbType.Int).Value = agentObj.gatewayID;
_cmd.Parameters.Add("@PortNumber", SqlDbType.VarChar, 20).Value = agentObj.PortNumber;
_cmd.Parameters.Add("@ProfileImagePath", SqlDbType.VarChar, 500).Value = agentObj.ProfileImagePath;
_cmd.Parameters.Add("@ReportingManagers", SqlDbType.VarChar, 500).Value = agentObj.ReportingManagerIds;
_cmd.Parameters.Add("@ReportingSupervisors", SqlDbType.VarChar, 500).Value = agentObj.ReportingSupervisorIds;
_cmd.Parameters.Add("@LoginType", SqlDbType.Int).Value = agentObj.LoginType;
_cmd.Parameters.Add("@OutBoundAccessType", SqlDbType.Int).Value = agentObj.OutBoundAccessType;
}
_cmd.Parameters.Add("@RetAgentId", SqlDbType.BigInt).Direction = ParameterDirection.Output;
_cmd.Parameters.Add("@Message", SqlDbType.VarChar, 200).Direction = ParameterDirection.Output;
_cmd.Parameters.Add("@Success", SqlDbType.Bit).Direction = ParameterDirection.Output;
_da.SelectCommand = _cmd;
_da.Fill(_ds);
if (_ds.Tables.Count > 0)
{
_ds.Tables[0].TableName = "AgentInformation";
}
if (_ds.Tables.Count > 1)
{
_ds.Tables[1].TableName = "AgentDeviceInformation";
}
_ds.Tables.Add(_helper.ConvertOutputParametersToDataTable(_cmd.Parameters));
}
catch (Exception ex)
{
Logger.Error(ex.ToString());
throw;
}
finally
{
Connection.Close();
_cmd = null;
}
return(_ds);
}
