public Agent selectAgent(Agent obj)
{
RealReportContext db = new RealReportContext();
try
{
IQueryable<Agent> AgentList = from agent in db.Agents
where agent.Agent_ID == obj.Agency_ID
select agent;
return (AgentList.ToList())[0];
}
catch (Exception ex)
{
return null;
}
}
public bool insertAgent(Agent obj)
{
using (RealReportContext db = new RealReportContext())
{
try
{
db.Agents.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public bool deleteAgent(Agent obj)
{
using (RealReportContext db = new RealReportContext())
{
try
{
IQueryable<Agent> AgentList = from agent in db.Agents
where agent.Agent_ID == obj.Agent_ID
select agent;
if ((AgentList.ToArray().Length > 0))
{
//Remove Dependencies
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
public bool updateAgent(Agent obj)
{
using (RealReportContext db = new RealReportContext())
{
try
{
IQueryable<Agent> AgentList = from agent in db.Agents
where agent.Agent_ID == obj.Agent_ID
select agent;
if ((AgentList.ToArray()).Length > 0)
{
foreach (Agent Agent in AgentList)
{
//Modify Attributes
}
#region Database Submission with Rollback
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}
