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); }