public bool Update(TraineePaymentEntity traineePayment) { try { tblTraineePayment newTraineePayment = new tblTraineePayment(); newTraineePayment.ID = traineePayment.ID; newTraineePayment.TraineeCourseID = traineePayment.TraineeCourseEntity.ID; newTraineePayment.PaymentDate = traineePayment.PaymentDate; newTraineePayment.PaymentAmount = traineePayment.PaymentAmount; newTraineePayment.CreatedBy = traineePayment.CreatedBy; newTraineePayment.CreatedDate = traineePayment.CreatedDate; newTraineePayment.UpdatedBy = traineePayment.UpdatedBy; newTraineePayment.UpdatedDate = traineePayment.UpdatedDate; TIMSDBEntities entity = new TIMSDBEntities(); tblTraineePayment oldTraineePayment = entity.tblTraineePayments.Where(x => x.ID == traineePayment.ID).FirstOrDefault(); entity.Entry(oldTraineePayment).CurrentValues.SetValues(newTraineePayment); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public bool Save(TraineePaymentEntity traineePayment) { try { tblTraineePayment TraineePayment = new tblTraineePayment(); TraineePayment.ID = traineePayment.ID; TraineePayment.TraineeCourseID = traineePayment.TraineeCourseEntity.ID; TraineePayment.PaymentDate = traineePayment.PaymentDate; TraineePayment.PaymentAmount = traineePayment.PaymentAmount; TraineePayment.CreatedBy = traineePayment.CreatedBy; TraineePayment.CreatedDate = traineePayment.CreatedDate; TraineePayment.UpdatedBy = traineePayment.UpdatedBy; TraineePayment.UpdatedDate = traineePayment.UpdatedDate; TIMSDBEntities entity = new TIMSDBEntities(); entity.tblTraineePayments.Add(TraineePayment); entity.SaveChanges(); return(true); } catch (Exception ex) { throw; } }
public bool Delete(TraineePaymentEntity traineePayment) { try { TIMSDBEntities entity = new TIMSDBEntities(); tblTraineePayment TraineePayment = entity.tblTraineePayments.Where(x => x.ID == traineePayment.ID).FirstOrDefault(); entity.tblTraineePayments.Remove(TraineePayment); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public TraineePaymentEntity GetSingle(int ID) { try { TIMSDBEntities entity = new TIMSDBEntities(); tblTraineePayment TraineePayment = entity.tblTraineePayments.Where(x => x.ID == ID).FirstOrDefault(); TraineePaymentEntity traineePayment = new TraineePaymentEntity(); traineePayment.ID = TraineePayment.ID; traineePayment.TraineeCourseEntity = new TraineeCourseEntity(TraineePayment.tblTraineeCourse); traineePayment.PaymentDate = TraineePayment.PaymentDate; traineePayment.PaymentAmount = TraineePayment.PaymentAmount; traineePayment.CreatedBy = TraineePayment.CreatedBy; traineePayment.CreatedDate = TraineePayment.CreatedDate; traineePayment.UpdatedBy = TraineePayment.UpdatedBy; traineePayment.UpdatedDate = (DateTime)TraineePayment.UpdatedDate; return(traineePayment); } catch (Exception ex) { return(null); } }