//To Add new AirlineOverrideTarget record
public int AddAirlineOverrideTarget(AirlineOverrideTarget airlineOverrideTarget)
{
try
{
int maxSequence;
if (db.AirlineOverrideTarget.Any())
{
var airlineOverrideTargetList = db.AirlineOverrideTarget.Where(o => o.AirlineOverrideId == airlineOverrideTarget.AirlineOverrideId).ToList();
if (airlineOverrideTargetList.Any())
{
int seq = airlineOverrideTargetList.Max(o => o.Sequence);
maxSequence = seq + 1;
}
else
{
maxSequence = 1;
}
}
else
{
maxSequence = 1;
}
airlineOverrideTarget.Sequence = maxSequence;
db.AirlineOverrideTarget.Add(airlineOverrideTarget);
db.SaveChanges();
return(1);
}
catch
{
return(-1);
}
}
//Get the details of a particular AirlineOverrideTarget
public AirlineOverrideTarget GetAirlineOverrideTargetData(string id)
{
try
{
Guid guid = new Guid(id);
AirlineOverrideTarget AirlineOverrideTarget = db.AirlineOverrideTarget.Find(guid);
return(AirlineOverrideTarget);
}
catch
{
return(null);
}
}
//To Update the records of a particluar AirlineOverrideTarget
public int UpdateAirlineOverrideTarget(AirlineOverrideTarget airlineOverrideTarget)
{
try
{
db.Entry(airlineOverrideTarget).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
catch
{
return(-1);
}
}
//To Delete the record of a particular AirlineOverrideTarget
public int DeleteAirlineOverrideTarget(string id)
{
try
{
Guid guid = new Guid(id);
AirlineOverrideTarget airlineOverrideTarget = db.AirlineOverrideTarget.Find(guid);
if (airlineOverrideTarget != null)
{
db.AirlineOverrideTarget.Remove(airlineOverrideTarget);
db.SaveChanges();
}
return(1);
}
catch
{
return(-1);
}
}