private AgentDTO GetBookingAgent(int bookingId)
{
AgentDTO[] oAgentData = null;
string query = "select AgentId, AgentCode, AgentName, AgentEmailId from tblAgentMaster where 1=1 ";
query += " and AgentId = (select AgentId from tblBooking where BookingId = " + bookingId + ")";
query += " order by AgentEmailId";
DataSet ds;
ds = GetDataFromDB(query);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
oAgentData = new AgentDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oAgentData[i] = new AgentDTO();
oAgentData[i].AgentId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
oAgentData[i].AgentCode = Convert.ToString(ds.Tables[0].Rows[i][1]);
oAgentData[i].AgentName = Convert.ToString(ds.Tables[0].Rows[i][2]);
oAgentData[i].EmailId = Convert.ToString(ds.Tables[0].Rows[i][3]);
}
}
if (oAgentData != null && oAgentData.Length > 0)
{
return(oAgentData[0]);
}
else
{
return(null);
}
}
public int Insert(AgentDTO oAgentData)
{
DatabaseManager oDB;
int agentId = -1;
try
{
oDB = new DatabaseManager();
string sProcName = "up_Ins_AgentMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sAgentCode", DbType.String, oAgentData.AgentCode);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sAgentName", DbType.String, oAgentData.AgentName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AgentEmailId", DbType.String, DataSecurityManager.Encrypt(oAgentData.EmailId));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Password", DbType.String, DataSecurityManager.Encrypt(oAgentData.Password));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Category", DbType.String, DataSecurityManager.Encrypt(oAgentData.category));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Country", DbType.String, DataSecurityManager.Encrypt(oAgentData.country));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@localAgent", DbType.Byte, oAgentData.localagent);
<< << << < HEAD
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@CssPath", DbType.String, oAgentData.CssPath);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RedirectURL", DbType.String, oAgentData.RedirectURL);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@IsPaymentBypass", DbType.Boolean, (oAgentData.IsPaymentBypass));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AgentURL", DbType.String, (oAgentData.AgentURL));
public string InsertOrUpdate(AgentDTO agent)
{
try
{
var validate = Validate(agent);
if (!string.IsNullOrEmpty(validate))
{
return(validate);
}
if (ObjectExists(agent))
{
return(GenericMessages.DatabaseErrorRecordAlreadyExists);
}
agent.Synced = false;
_foreignAgentRepository.InsertUpdate(agent);
_unitOfWork.Commit();
return(string.Empty);
}
catch (Exception exception)
{
return(exception.Message);
}
}
public string Disable(AgentDTO agent)
{
if (agent == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
_foreignAgentRepository.Update(agent);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
iDbContext.Dispose();
}
return(stat);
}
public async Task <IdentityResult> AddAgent(AgentDTO dto)
{
IdentityUser agent = new IdentityUser(dto.UserName);
IdentityResult result = await _userManager.CreateAsync(agent, "Servicios*2019");
if (!result.Succeeded)
{
return(result);
}
result = await _userManager.SetPhoneNumberAsync(agent, dto.Phone);
if (!result.Succeeded)
{
return(result);
}
result = await _userManager.SetEmailAsync(agent, dto.UserName);
if (!result.Succeeded)
{
return(result);
}
result = await _userManager.AddToRoleAsync(agent, RTRoles.Agent);
return(result);
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
BALLogin bllog = new BALLogin();
DALLogin dllog = new DALLogin();
try
{
if (Login1.UserName.Trim().ToString() == "" || Login1.Password.Trim().ToString() == "")
{
e.Authenticated = false;
}
bllog.EmailId = Login1.UserName.Trim().ToString();
bllog.Password = Login1.Password.Trim().ToString();
AgentDTO agent = dllog.AgentLogin(bllog);
if (agent != null)
{
Session.Add("UserName", agent.AgentName);
Session.Add("UserCode", agent.AgentId);
Session.Add("AgentMailId", Login1.UserName.Trim().ToString());
Session.Add("Password", Login1.Password.Trim().ToString());
Response.Redirect("SearchProperty.aspx?Aid=" + agent.AgentId.ToString() + " ");
}
}
catch (Exception exp)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('" + exp.Message + "')", true);
throw exp;
}
}
public void Update(AgentDTO agent)
{
string path = Path.Combine(
environment.WebRootPath,
$"images\\{agent.Name}\\");
var map = Mapper.Map <Agent>(agent);
if (agent.ParentAgentId == null)
{
if (agent.ImageLogo != null)
{
var imageLogo = $"/images/{agent.Name}/{agent.ImageLogo.FileName}";
fileUploadService.Upload(path, agent.ImageLogo.FileName, agent.ImageLogo);
map.ImageLogo = imageLogo;
}
if (agent.ImagePromo != null)
{
var imagePromo = $"/images/{agent.Name}/{agent.ImagePromo.FileName}";
fileUploadService.Upload(path, agent.ImagePromo.FileName, agent.ImagePromo);
map.ImagePromo = imagePromo;
}
}
else
{
CheckParentAgentExistance(agent.ParentAgentId, out string logo, out string promo, out string text);
map.ImageLogo = logo;
map.ImagePromo = promo;
map.TextPromo = text;
}
Database.Agents.Update(map);
Database.Save();
}
public JsonResult Update(AgentDTO dto)
{
var manager = this.GetManagerFor<IAgentManager>();
var result = manager.Update(dto);
var resultDTO = new AgentDTO(result);
return Json(resultDTO);
}
public JsonResult Update(AgentDTO dto)
{
var manager = this.GetManagerFor <IAgentManager>();
var result = manager.Update(dto);
var resultDTO = new AgentDTO(result);
return(Json(resultDTO));
}
public static bool InsertAgencyWithAgents(string userName, string agencyName)
{
//try
//{
// userName = Singleton.User.UserName;
// agencyName = Singleton.Agency.AgencyName;
//}
//catch
//{
// userName = "******";
// agencyName = "Default Agency";
//}
try
{
IDbContext iDbContext = DbContextUtil.GetDbContextInstance();
var unitOfWork = new UnitOfWork(iDbContext);
AgencyDTO agency = new LocalAgencyService(true).GetLocalAgency();
IEnumerable <AgentDTO> agents = new ForeignAgentService(true, false).GetAll();
foreach (AgentDTO foreignAgentDTO in agents)
{
AgentDTO dto = foreignAgentDTO;
var agencyWithAgents = unitOfWork.Repository <AgencyAgentDTO>()
.Query()
.FilterList(f => f.AgentId == dto.Id && f.AgencyId == agency.Id)
.Get()
.FirstOrDefault();
if (agencyWithAgents != null)
{
continue;
}
agencyWithAgents = new AgencyAgentDTO
{
AgencyId = agency.Id,
AgentId = foreignAgentDTO.Id
};
unitOfWork.Repository <AgencyAgentDTO>().Insert(agencyWithAgents);
}
unitOfWork.Commit();
unitOfWork.Dispose();
return(true);
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "Insert Agency With Agents",
ex.Message + Environment.NewLine + ex.InnerException, userName, agencyName);
return(false);
}
}
public async Task <IActionResult> Update(AgentDTO agentDto, int id)
{
var agent = _mapper.Map <Agent>(agentDto);
agent.Id = id;
await _agentService.Update(agent, id);
return(Ok());
}
public async Task <IActionResult> Add(string UserName, string Phone)
{
AgentDTO dTO = new AgentDTO(UserName, Phone);
IdentityResult result = await _agentService.AddAgent(dTO);
if (result.Succeeded)
{
return(await BuildPartialView());
}
return(BadRequest());
}
public ServerAgentViewModel()
{
CleanUp();
var iDbContext = new ServerDbContextFactory().Create();
_unitOfWork = new UnitOfWorkServer(iDbContext);
SelectedAgent = new AgentDTO();
Agents = new ObservableCollection <AgentDTO>();
GetLiveAgents();
EditCommandVisibility = false;
}
private void ExecuteAddNewForeignAgentViewCommand()
{
SelectedAgent = new AgentDTO
{
Address = new AddressDTO
{
Country = CountryList.SaudiArabia,
City = EnumUtil.GetEnumDesc(CityList.Riyadh)
},
Header = new AttachmentDTO(),
Footer = new AttachmentDTO()
};
}
public async Task <JsonResult> UpdateAgent(AgentDTO dto)
{
var result = await this.PostAsync <AgentDTO>(this.GetAPIAddress("/api/console/Agent/Update"), new
{
dto = dto
});
return(Json(new
{
success = result.Info.IsValid,
error = result.Info.Errors
}));
}
public void AddAgent(AgentDTO agent)
{
Agent item = new Agent()
{
Id = Guid.NewGuid(),
CredId = new Guid(), //todo: save credentials
Endpoint = agent.Endpoint,
OsType = agent.OsType,
AgentVersion = agent.AgentVersion
};
ctx.Agents.Add(item);
ctx.SaveChanges();
}
public NHResult <Agent> Update(AgentDTO dto)
{
var agent = base.GetById(dto.Id);
agent.Name = dto.Name;
agent.TypeId = dto.TypeId;
agent.Address = dto.Address;
agent.Comment = dto.Comment;
agent.Priority = dto.Priority;
var result = base.SaveOrUpdate(agent);
return(result);
}
public NHResult <Agent> Create(AgentDTO dto)
{
var agent = new Agent
{
Name = dto.Name,
TypeId = dto.TypeId,
Address = dto.Address,
Priority = dto.Priority,
Comment = dto.Comment
};
var result = base.SaveOrUpdate(agent);
return(result);
}
public JsonResult GetAgent(int id, IEnumerable<string> query)
{
var queries = new Query[] { };
if (query != null)
{
queries = query.Select(q => new Query { Name = q }).ToArray();
}
var manager = this.GetManagerFor<IAgentManager>();
var result = manager.GetById(id);
var resultDTO = new AgentDTO(queries, result);
return Json(resultDTO);
}
/// <summary>
/// to convert to AgentDto
/// </summary>
/// <param name="memberobj"></param>
/// <param name="dealerobj"></param>
public static void MergeUserToAgentDto(User memberobj, User dealerobj)
{
var dto = new AgentDTO()
{
Dealer = string.IsNullOrEmpty(dealerobj.DealerNumber) ? null : MergeUserToDealerDto(dealerobj),
Id = memberobj.SyncUID,
Name = memberobj.UserName,
CmsFirstName = memberobj.UserName, //no other coloumn in db for firstname so take username
Email = memberobj.Email,
UserType = CmsUserType.AGENT,
Status = BoolValue.TRUE, //memberobj.IsApproved ? BoolValue.TRUE : BoolValue.FALSE,
//addtional proerties are there but this will be used on further.
};
Agent = dto;
}
public JsonResult GetAgent(int id, IEnumerable <string> query)
{
var queries = new Query[] { };
if (query != null)
{
queries = query.Select(q => new Query {
Name = q
}).ToArray();
}
var manager = this.GetManagerFor <IAgentManager>();
var result = manager.GetById(id);
var resultDTO = new AgentDTO(queries, result);
return(Json(resultDTO));
}
public IEnumerable <AgentDTO> GetAgents()
{
List <AgentDTO> agents = new List <AgentDTO>();
foreach (var item in ctx.Agents)
{
AgentDTO buff = new AgentDTO()
{
Id = item.Id,
Endpoint = item.Endpoint,
OsType = item.OsType,
AgentVersion = item.AgentVersion
};
agents.Add(buff);
}
return(agents);
}
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);
}
public ResultDTO AddAgent(AgentDTO agent)
{
try
{
Context.Agents.Add(new Agent
{
AgentId = agent.AgentId,
Name = agent.Name,
LastName = agent.LastName
});
SaveChanges();
return(new ResultDTO {
Success = true
});
}
catch (Exception ex) { return(new ResultDTO {
Success = false, Message = ex.Message
}); }
}
public AgentUserMapperDTO GetAgentUserEmailIds(int bookingId)
{
AgentDTO agentDto = GetBookingAgent(bookingId);
UserDTO[] userDto = null;
if (agentDto != null)
{
userDto = GetAgentUsers(agentDto.AgentId);
}
AgentUserMapperDTO agentUserMapperDTO = new AgentUserMapperDTO();
agentUserMapperDTO.Agent = agentDto;
if (userDto != null)
{
agentUserMapperDTO.UserList = new List <UserDTO>(userDto);
}
return(agentUserMapperDTO);
}
public AgentDTO AgentLoginForTouristEntry(BALLogin obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
string query = "select a.AgentId, AgentCode, AgentName, AgentEmailId, Password from tblAgentMaster a inner join tblBooking b on b.AgentId=a.AgentId where BookingID=" + obj.BookingId + " and AgentEmailId='" + DataSecurityManager.Encrypt(obj.EmailId) + "' and [password]='" + DataSecurityManager.Encrypt(obj.Password) + "'";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
cmd.Connection = cn;
cn.Open();
AgentDTO agent = null;
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
if (dt != null && dt.Rows.Count > 0)
{
agent = new AgentDTO();
agent.AgentId = dt.Rows[0]["AgentId"] != null?Convert.ToInt32(dt.Rows[0]["AgentId"]) : -1;
agent.AgentCode = dt.Rows[0]["AgentCode"] != null ? dt.Rows[0]["AgentCode"].ToString() : string.Empty;
agent.AgentName = dt.Rows[0]["AgentName"] != null?DataSecurityManager.Decrypt(dt.Rows[0]["AgentName"].ToString()) : string.Empty;
agent.EmailId = dt.Rows[0]["AgentEmailId"] != null?DataSecurityManager.Decrypt(dt.Rows[0]["AgentEmailId"].ToString()) : string.Empty;
agent.Password = dt.Rows[0]["Password"] != null?DataSecurityManager.Decrypt(dt.Rows[0]["Password"].ToString()) : string.Empty;
}
reader.Close();
cn.Close();
return(agent);
}
catch (Exception exp)
{
throw exp;
}
}
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);
}
public async Task <IHttpActionResult> PostAgent(Agent agent)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
agent.AgentCreatedDateTime = agent.AgentLastUpdatedDateTime = DateTime.Now;
db.Agents.Add(agent);
await db.SaveChangesAsync();
//load agent name
//db.Entry(agent).Reference(x => x.Agent).Load();
var agentDTO = new AgentDTO()
{
AgentId = agent.AgentId,
AgentName = agent.AgentName
};
return(CreatedAtRoute("DefaultApi", new { id = agent.AgentId }, agentDTO));
}
public AgentsList GetAgents()
{
List <AgentDTO> agents = new List <AgentDTO>();
foreach (var item in ctx.Agents)
{
AgentDTO buff = new AgentDTO()
{
Id = item.Id,
Endpoint = item.Endpoint,
OsType = item.OsType,
AgentVersion = item.AgentVersion,
IsEnabled = item.IsEnabled
};
agents.Add(buff);
}
AgentsList agentsList = new AgentsList();
agentsList.Agents = agents;
return(agentsList);
}
protected void btnGenarateToken_Click(object sender, EventArgs e)
{
lblError.Text = "";
AgentMaster oAgentMaster = new AgentMaster();
AgentDTO[] oAgentData = oAgentMaster.GetData(Convert.ToInt32(ddlAgent.SelectedValue));
string AgentCode = oAgentData[0].AgentCode.ToString();
string AgentPassword = oAgentData[0].Password.ToString();
if (AgentCode != "" && AgentPassword != "")
{
string Token = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(AgentCode + ":" + AgentPassword));
// byte[] byt = Encoding.ASCII.GetBytes(Token);
// byte[] data1 = Convert.FromBase64String(Token);
//string value = Encoding.ASCII.GetString(byt);
AgentDTO oAgentSaveData = new AgentDTO();
oAgentSaveData.AgentId = Convert.ToInt32(ddlAgent.SelectedValue);
oAgentSaveData.TokenNo = Token;
bool Agent = oAgentMaster.ApiAuthInsert(oAgentSaveData);
if (Agent)
{
lblError.Text = "Token Genarate Successfully";
}
else
{
lblError.Text = "This Agent Is Already Genarate Token";
}
}
else
{
lblError.Text = "This Agent Can't Genarate Token,Password or AgentCode Missing";
}
BindGrid();
}
public string Validate(AgentDTO agent)
{
if (null == agent)
{
return(GenericMessages.ObjectIsNull);
}
if (agent.Address == null)
{
return("Address " + GenericMessages.ObjectIsNull);
}
if (String.IsNullOrEmpty(agent.AgentName))
{
return(agent.AgentName + " " + GenericMessages.StringIsNullOrEmpty);
}
if (agent.AgentName.Length > 255)
{
return(agent.AgentName + " can not be more than 255 characters ");
}
return(string.Empty);
}
public IHttpActionResult AddAgent(AgentDTO agent)
{
var cred = new Credential()
{
Id = Guid.NewGuid(),
Login = agent.Login,
Password = agent.Password
};
Agent item = new Agent()
{
Id = Guid.NewGuid(),
CredId = cred.Id,
Endpoint = agent.Endpoint,
OsType = agent.OsType,
AgentVersion = agent.AgentVersion,
IsEnabled = false
};
ctx.Credentials.Add(cred);
ctx.Agents.Add(item);
ctx.SaveChanges();
return(Ok());
}