public bool Update(TraineeMessageEntity traineeMessage)
{
try
{
tblTraineeMessage newTraineeMessage = new tblTraineeMessage();
newTraineeMessage.ID = traineeMessage.ID;
newTraineeMessage.TraineeID = traineeMessage.TraineeEntity.ID;
newTraineeMessage.PhoneNumber = traineeMessage.PhoneNumber;
newTraineeMessage.Message = traineeMessage.Message;
newTraineeMessage.Status = traineeMessage.Status;
newTraineeMessage.CreatedBy = traineeMessage.CreatedBy;
newTraineeMessage.CreatedDate = traineeMessage.CreatedDate;
newTraineeMessage.UpdatedBy = traineeMessage.UpdatedBy;
newTraineeMessage.UpdatedDate = traineeMessage.UpdatedDate;
TIMSDBEntities entity = new TIMSDBEntities();
tblTraineeMessage oldTraineeMessage = entity.tblTraineeMessages.Where(x => x.ID == traineeMessage.ID).FirstOrDefault();
entity.Entry(oldTraineeMessage).CurrentValues.SetValues(newTraineeMessage);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public bool Save(TraineeMessageEntity traineeMessage)
{
try
{
tblTraineeMessage TraineeMessage = new tblTraineeMessage();
TraineeMessage.ID = traineeMessage.ID;
TraineeMessage.TraineeID = traineeMessage.TraineeEntity.ID;
TraineeMessage.PhoneNumber = traineeMessage.PhoneNumber;
TraineeMessage.Message = traineeMessage.Message;
TraineeMessage.Status = traineeMessage.Status;
TraineeMessage.CreatedBy = traineeMessage.CreatedBy;
TraineeMessage.CreatedDate = traineeMessage.CreatedDate;
TraineeMessage.UpdatedBy = traineeMessage.UpdatedBy;
TraineeMessage.UpdatedDate = traineeMessage.UpdatedDate;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblTraineeMessages.Add(TraineeMessage);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public TraineeMessageEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblTraineeMessage TraineeMessage = entity.tblTraineeMessages.Where(x => x.ID == ID).FirstOrDefault();
TraineeMessageEntity traineeMessage = new TraineeMessageEntity();
traineeMessage.ID = TraineeMessage.ID;
traineeMessage.TraineeEntity = new TraineeEntity(TraineeMessage.tblTrainee);
traineeMessage.PhoneNumber = TraineeMessage.PhoneNumber;
traineeMessage.Message = TraineeMessage.Message;
traineeMessage.Status = TraineeMessage.Status;
traineeMessage.CreatedBy = TraineeMessage.CreatedBy;
traineeMessage.CreatedDate = TraineeMessage.CreatedDate;
traineeMessage.UpdatedBy = TraineeMessage.UpdatedBy;
traineeMessage.UpdatedDate = (DateTime)TraineeMessage.UpdatedDate;
return(traineeMessage);
}
catch (Exception ex)
{
return(null);
}
}
public List <TraineeMessageEntity> GetAll()
{
try
{
List <TraineeMessageEntity> TraineeMessageEntities = new List <TraineeMessageEntity>();
TIMSDBEntities entity = new TIMSDBEntities();
List <tblTraineeMessage> TraineeMessages = entity.tblTraineeMessages.ToList();
foreach (tblTraineeMessage TraineeMessage in TraineeMessages)
{
TraineeMessageEntity traineeMessage = new TraineeMessageEntity();
traineeMessage.ID = TraineeMessage.ID;
traineeMessage.TraineeEntity = new TraineeEntity(TraineeMessage.tblTrainee);
traineeMessage.PhoneNumber = TraineeMessage.PhoneNumber;
traineeMessage.Message = TraineeMessage.Message;
traineeMessage.Status = TraineeMessage.Status;
traineeMessage.CreatedBy = TraineeMessage.CreatedBy;
traineeMessage.CreatedDate = TraineeMessage.CreatedDate;
traineeMessage.UpdatedBy = TraineeMessage.UpdatedBy;
traineeMessage.UpdatedDate = (DateTime)TraineeMessage.UpdatedDate;
TraineeMessageEntities.Add(traineeMessage);
}
return(TraineeMessageEntities);
}
catch (Exception ex)
{
return(null);
}
}
public bool Delete(TraineeMessageEntity traineeMessage)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblTraineeMessage TraineeMessage = entity.tblTraineeMessages.Where(x => x.ID == traineeMessage.ID).FirstOrDefault();
entity.tblTraineeMessages.Remove(TraineeMessage);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
