public void UpdateAgent(AgentModel agentModel)
{
using (AppTourEntities data = new AppTourEntities())
{
AGENTS current = data.AGENTS.SingleOrDefault(x => x.ID == agentModel.Id);
if (current != null)
{
try
{
current.NAME = agentModel.Name;
current.IS_ACTIVE = agentModel.IsActive;
current.LAST_EXECUTION_DATE = agentModel.LastExecutionDate;
current.MAX_REQUEST_PER_DAY = agentModel.MaxRequestPerDay;
current.PERIODICITY = agentModel.Periodicity;
current.RATING = agentModel.Rating;
current.LAST_REFERENCE = agentModel.LastReference;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public IHttpActionResult Update(AGENTS agent)
{
var jsonData = string.Empty;
try
{
AGENTS data = dbo.AGENTS.Where(x => x.AGENT_CODE == agent.AGENT_CODE).FirstOrDefault();
if (data != null)
{
data.AGENT_NAME = agent.AGENT_NAME;
data.COMMISSION = agent.COMMISSION;
data.COUNTRY = agent.COUNTRY;
data.PHONE_NO = agent.PHONE_NO;
data.WORKING_AREA = agent.WORKING_AREA;
dbo.SaveChanges();
jsonData = "Record updated Successfully";
}
}
catch (Exception ex) {
jsonData = ex.Message;
}
return(Ok(jsonData));
}
public IHttpActionResult Insert(AGENTS agent)
{
var JsonData = string.Empty;
try
{
var data = dbo.AGENTS.Where(x => x.AGENT_NAME.ToUpper() == agent.AGENT_NAME.ToUpper()).FirstOrDefault();
if (data != null)
{
JsonData = "agent already exist";
}
else
{
dbo.AGENTS.Add(agent);
dbo.SaveChanges();
JsonData = "record saved successfully";
}
}
catch (Exception ex) {
JsonData = ex.Message;
}
return(Ok(JsonData));
}
