public bool UpdateAgent(AgentMaster a)
{
try
{
a.BookingStatusName = null;
tblAgentMaster agentOld = dbEntity.tblAgentMasters.Where(x => x.AgentID == a.AgentID).FirstOrDefault();
if (agentOld != null)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <AgentMaster, tblAgentMaster>().ForAllMembers(opts => opts.Condition((src, dest, srcMember) => srcMember != null));
});
IMapper mapper = config.CreateMapper();
//mapper.Map(p, projectOld, typeof(Projects), typeof(tblProject));
mapper.Map <AgentMaster, tblAgentMaster>(a, agentOld);
dbEntity.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
log.Error("Error :" + ex);
return(false);
}
}
public bool AddAgent(AgentMaster a)
{
try
{
var checkDuplicateAgentCode = dbEntity.tblAgentMasters.Where(x => x.AgentCode == a.AgentCode).FirstOrDefault();
if (checkDuplicateAgentCode == null)
{
a.BookingStatusName = null;
tblAgentMaster agentNew = new tblAgentMaster();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <AgentMaster, tblAgentMaster>().ForAllMembers(opts => opts.Condition((src, dest, srcMember) => srcMember != null));
});
IMapper mapper = config.CreateMapper();
//mapper.Map(p, projectOld, typeof(Projects), typeof(tblProject));
mapper.Map <AgentMaster, tblAgentMaster>(a, agentNew);
dbEntity.tblAgentMasters.Add(agentNew);
dbEntity.SaveChanges();
var agentID = dbEntity.tblAgentMasters.Where(x => x.AgenteMail == a.AgenteMail).Select(x => x.AgentID).FirstOrDefault();
var Projects = dbEntity.tblProjects.Where(x => x.BookingStatus == "O").ToList();
foreach (var project in Projects)
{
tblAgentProjectLevel agentProjectLevel = new tblAgentProjectLevel();
agentProjectLevel.AgentID = agentID;
agentProjectLevel.ProjectID = project.ProjectID;
agentProjectLevel.LevelID = 27;
agentProjectLevel.Status = "I";
agentProjectLevel.CreatedBy = a.CreatedBy;
agentProjectLevel.CreatedDate = a.CreatedDate;
dbEntity.tblAgentProjectLevels.Add(agentProjectLevel);
}
//tblAgentTotalPayment
dbEntity.SaveChanges();
a.isDuplicateAgentCode = false;
return(true);
}
else
{
a.isDuplicateAgentCode = true;
return(false);
}
}
catch (Exception ex)
{
log.Error("Error :" + ex);
return(false);
}
}