public bool Delete(int PNRID)
{
var result = from pgm in db.PassengerDetails
where (pgm.PNR_ID == PNRID
&& pgm.DATE_OF_TRAVEL.Year >= DateTime.Now.Year
&& pgm.DATE_OF_TRAVEL.DayOfYear > DateTime.Now.DayOfYear
)
select pgm;
if (result.Any())
{
CancelFareModels cfm = new CancelFareModels();
float value = cfm.GetValueOfCancellationFee(result.Single().DATE_OF_TRAVEL);
CancellationDetail cd = new CancellationDetail
{
CD_REFUND = (int)(result.Single().TRAIN_FARE - result.Single().TRAIN_FARE*value),
CD_TIME_CRT = DateTime.Now,
USER_ID = result.Single().LOGIN_ID,
FROM_TO = result.Single().FROM_TO
};
db.CancellationDetails.InsertOnSubmit(cd);
db.PassengerDetails.DeleteOnSubmit(result.Single());
db.SubmitChanges();
return true;
}
else {
return false;
}
}
partial void DeleteCancellationDetail(CancellationDetail instance);
partial void UpdateCancellationDetail(CancellationDetail instance);
partial void InsertCancellationDetail(CancellationDetail instance);
private void detach_CancellationDetails(CancellationDetail entity)
{
this.SendPropertyChanging();
entity.LoginDetail = null;
}
