public bool Delete(UserAgentMapperDTO userAgentData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_UserAgentMaster";
foreach (AgentDTO agent in userAgentData.AgentList)
{
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserId", DbType.String, userAgentData.UserId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AgentId", DbType.Int32, agent.AgentId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
}
catch (Exception exp)
{
oDB = null;
userAgentData = null;
GF.LogError("UserAgentMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private UserAgentMapperDTO MapUnHookedAgentsToObject()
{
UserAgentMapperDTO userAgentMapperDTO = new UserAgentMapperDTO();
List <AgentDTO> newhookedAgentList = new List <AgentDTO>();
AgentDTO agent;
int[] selectedItems = lstUnHookedAgents.GetSelectedIndices();
userAgentMapperDTO.UserId = lstUsers.SelectedValue.ToString();
for (int i = 0; i < selectedItems.Length; i++)
{
agent = new AgentDTO();
agent.AgentId = Convert.ToInt32(lstUnHookedAgents.Items[selectedItems[i]].Value);
agent.AgentName = lstUnHookedAgents.Items[selectedItems[i]].Text;
newhookedAgentList.Add(agent);
}
userAgentMapperDTO.AgentList = newhookedAgentList;
return(userAgentMapperDTO);
}
private void FillHookedAgents()
{
UserAgentMapperMaster userAgentMapperMaster = new UserAgentMapperMaster();
lstHookedAgents.Items.Clear();
if (lstUsers.SelectedValue != null)
{
String userId = lstUsers.SelectedValue.ToString();
UserAgentMapperDTO userAgentMapperDto = userAgentMapperMaster.GetHookedAgents(userId);
ListItem l;
if (userAgentMapperDto != null && userAgentMapperDto.AgentList != null && userAgentMapperDto.AgentList.Count > 0)
{
for (int i = 0; i < userAgentMapperDto.AgentList.Count; i++)
{
l = new ListItem(userAgentMapperDto.AgentList[i].AgentName, userAgentMapperDto.AgentList[i].AgentId.ToString());
lstHookedAgents.Items.Add(l);
}
}
}
}
private UserAgentMapperDTO GetAgents(String query)
{
UserAgentMapperDTO userAgentMapperDTO = new UserAgentMapperDTO();
List <AgentDTO> hookedAgentList = new List <AgentDTO>();
AgentDTO hookedAgent = new AgentDTO();
DataSet ds;
ds = GetDataFromDB(query);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
hookedAgent = new AgentDTO();
hookedAgent.AgentId = ds.Tables[0].Rows[i][1] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i][1]);
hookedAgent.AgentName = ds.Tables[0].Rows[i][2] == DBNull.Value ? String.Empty : DataSecurityManager.Decrypt(Convert.ToString(ds.Tables[0].Rows[i][2]));
hookedAgentList.Add(hookedAgent);
}
}
userAgentMapperDTO.AgentList = hookedAgentList;
return(userAgentMapperDTO);
}
