public int Delete(PassengerOrders PassengerOrder, int UserIdentity)
{
try
{
using (var db = new HCMEntities())
{
PassengerOrders PassengerOrderObj = db.PassengerOrders.SingleOrDefault(x => x.PassengerOrderID.Equals(PassengerOrder.PassengerOrderID));
PassengerOrderObj.PassengerOrdersItineraries.ToList().ForEach(d => db.PassengerOrdersItineraries.Remove(d));
db.PassengerOrders.Remove(PassengerOrderObj);
return(db.SaveChanges(UserIdentity));
}
}
catch
{
throw;
}
}
public int Insert(PassengerOrders PassengerOrder)
{
try
{
using (var db = new HCMEntities())
{
db.PassengerOrders.Add(PassengerOrder);
db.SaveChanges();
return(PassengerOrder.PassengerOrderID);
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public int Update(PassengerOrders PassengerOrder)
{
try
{
using (var db = new HCMEntities())
{
PassengerOrders PassengerOrderObj = db.PassengerOrders.SingleOrDefault(x => x.PassengerOrderID.Equals(PassengerOrder.PassengerOrderID));
PassengerOrderObj.EmployeeCareerHistoryID = PassengerOrder.EmployeeCareerHistoryID;
PassengerOrderObj.TravellingDate = PassengerOrder.TravellingDate;
PassengerOrderObj.RankID = PassengerOrder.RankID;
PassengerOrderObj.TicketClassID = PassengerOrder.TicketClassID;
PassengerOrderObj.Going = PassengerOrder.Going;
PassengerOrderObj.Returning = PassengerOrder.Returning;
PassengerOrderObj.Reason = PassengerOrder.Reason;
PassengerOrderObj.LastUpdatedDate = PassengerOrder.LastUpdatedDate;
PassengerOrderObj.LastUpdatedBy = PassengerOrder.LastUpdatedBy;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
