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 int Save(TraineeCourseEntity traineeCourse)
{
try
{
tblTraineeCourse TraineeCourse = new tblTraineeCourse();
TraineeCourse.ID = traineeCourse.ID;
TraineeCourse.TraineeID = traineeCourse.TraineeEntity.ID;
TraineeCourse.CourseID = traineeCourse.CourseEntity.ID;
TraineeCourse.RegistrationDate = traineeCourse.RegistrationDate;
TraineeCourse.Duration = traineeCourse.Duration;
TraineeCourse.Cost = traineeCourse.Cost;
TraineeCourse.CreatedBy = traineeCourse.CreatedBy;
TraineeCourse.CreatedDate = traineeCourse.CreatedDate;
TraineeCourse.UpdatedBy = traineeCourse.UpdatedBy;
TraineeCourse.UpdatedDate = traineeCourse.UpdatedDate;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblTraineeCourses.Add(TraineeCourse);
entity.SaveChanges();
return(TraineeCourse.ID); //return currently created record ID
}
catch (Exception)
{
throw;
}
}
public List <TraineeCourseEntity> GetAll()
{
try
{
List <TraineeCourseEntity> TraineeCourseEntities = new List <TraineeCourseEntity>();
TIMSDBEntities entity = new TIMSDBEntities();
List <tblTraineeCourse> TraineeCourses = entity.tblTraineeCourses.ToList();
foreach (tblTraineeCourse TraineeCourse in TraineeCourses)
{
TraineeCourseEntity traineeCourse = new TraineeCourseEntity();
traineeCourse.ID = TraineeCourse.ID;
traineeCourse.TraineeEntity = new TraineeEntity(TraineeCourse.tblTrainee);
traineeCourse.CourseEntity = new CourseEntity(TraineeCourse.tblCourse);
traineeCourse.RegistrationDate = TraineeCourse.RegistrationDate;
traineeCourse.Duration = TraineeCourse.Duration;
traineeCourse.Cost = TraineeCourse.Cost;
traineeCourse.CreatedBy = TraineeCourse.CreatedBy;
traineeCourse.CreatedDate = TraineeCourse.CreatedDate;
traineeCourse.UpdatedBy = TraineeCourse.UpdatedBy;
traineeCourse.UpdatedDate = (DateTime)TraineeCourse.UpdatedDate;
TraineeCourseEntities.Add(traineeCourse);
}
return(TraineeCourseEntities);
}
catch (Exception ex)
{
return(null);
}
}
public bool Update(TraineeCourseEntity traineeCourse)
{
try
{
tblTraineeCourse newTraineeCourse = new tblTraineeCourse();
newTraineeCourse.ID = traineeCourse.ID;
newTraineeCourse.TraineeID = traineeCourse.TraineeEntity.ID;
newTraineeCourse.CourseID = traineeCourse.CourseEntity.ID;
newTraineeCourse.RegistrationDate = traineeCourse.RegistrationDate;
newTraineeCourse.Duration = traineeCourse.Duration;
newTraineeCourse.Cost = traineeCourse.Cost;
newTraineeCourse.CreatedBy = traineeCourse.CreatedBy;
newTraineeCourse.CreatedDate = traineeCourse.CreatedDate;
newTraineeCourse.UpdatedBy = traineeCourse.UpdatedBy;
newTraineeCourse.UpdatedDate = traineeCourse.UpdatedDate;
TIMSDBEntities entity = new TIMSDBEntities();
tblTraineeCourse oldTraineeCourse = entity.tblTraineeCourses.Where(x => x.ID == traineeCourse.ID).FirstOrDefault();
entity.Entry(oldTraineeCourse).CurrentValues.SetValues(newTraineeCourse);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public List <TraineeEntity> GetAll()
{
try
{
List <TraineeEntity> TraineeEntities = new List <TraineeEntity>();
TIMSDBEntities entity = new TIMSDBEntities();
List <tblTrainee> Trainees = entity.tblTrainees.ToList();
foreach (tblTrainee Trainee in Trainees)
{
TraineeEntity trainee = new TraineeEntity();
trainee.ID = Trainee.ID;
trainee.Fullname = Trainee.Fullname;
trainee.BirthDate = Trainee.BirthDate;
trainee.GenderEntity = new GenderEntity(Trainee.tblGender);
trainee.AcademicLevelEntity = new AcademicLevelEntity(Trainee.tblAcademicLevel);
trainee.BranchEntity = new BranchEntity(Trainee.tblBranch);
trainee.Address = Trainee.Address;
trainee.PhoneNumber = Trainee.PhoneNumber;
trainee.Photo = Trainee.Photo;
trainee.CreatedBy = Trainee.CreatedBy;
trainee.CreatedDate = Trainee.CreatedDate;
trainee.UpdatedBy = Trainee.UpdatedBy;
trainee.UpdatedDate = (DateTime)Trainee.UpdatedDate;
TraineeEntities.Add(trainee);
}
return(TraineeEntities);
}
catch (Exception ex)
{
return(null);
}
}
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 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 TraineeCourseEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblTraineeCourse TraineeCourse = entity.tblTraineeCourses.Where(x => x.ID == ID).FirstOrDefault();
TraineeCourseEntity traineeCourse = new TraineeCourseEntity();
traineeCourse.ID = TraineeCourse.ID;
traineeCourse.TraineeEntity = new TraineeEntity(TraineeCourse.tblTrainee);
traineeCourse.CourseEntity = new CourseEntity(TraineeCourse.tblCourse);
traineeCourse.RegistrationDate = TraineeCourse.RegistrationDate;
traineeCourse.Duration = TraineeCourse.Duration;
traineeCourse.Cost = TraineeCourse.Cost;
traineeCourse.CreatedBy = TraineeCourse.CreatedBy;
traineeCourse.CreatedDate = TraineeCourse.CreatedDate;
traineeCourse.UpdatedBy = TraineeCourse.UpdatedBy;
traineeCourse.UpdatedDate = (DateTime)TraineeCourse.UpdatedDate;
return(traineeCourse);
}
catch (Exception ex)
{
return(null);
}
}
public bool Update(TraineeEntity trainee)
{
try
{
tblTrainee newTrainee = new tblTrainee();
newTrainee.ID = trainee.ID;
newTrainee.Fullname = trainee.Fullname;
newTrainee.BirthDate = trainee.BirthDate;
newTrainee.GenderID = trainee.GenderEntity.ID;
newTrainee.AcademicLevelID = trainee.AcademicLevelEntity.ID;
newTrainee.BranchID = trainee.BranchEntity.ID;
newTrainee.Address = trainee.Address;
newTrainee.PhoneNumber = trainee.PhoneNumber;
newTrainee.Photo = trainee.Photo;
newTrainee.CreatedBy = trainee.CreatedBy;
newTrainee.CreatedDate = trainee.CreatedDate;
newTrainee.UpdatedBy = trainee.UpdatedBy;
newTrainee.UpdatedDate = trainee.UpdatedDate;
TIMSDBEntities entity = new TIMSDBEntities();
tblTrainee oldTrainee = entity.tblTrainees.Where(x => x.ID == trainee.ID).FirstOrDefault();
entity.Entry(oldTrainee).CurrentValues.SetValues(newTrainee);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw;
}
}
public List <TraineePaymentEntity> GetAll()
{
try
{
List <TraineePaymentEntity> TraineePaymentEntities = new List <TraineePaymentEntity>();
TIMSDBEntities entity = new TIMSDBEntities();
List <tblTraineePayment> TraineePayments = entity.tblTraineePayments.ToList();
foreach (tblTraineePayment TraineePayment in TraineePayments)
{
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;
TraineePaymentEntities.Add(traineePayment);
}
return(TraineePaymentEntities);
}
catch (Exception ex)
{
return(null);
}
}
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 TraineeEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblTrainee Trainee = entity.tblTrainees.Where(x => x.ID == ID).FirstOrDefault();
TraineeEntity trainee = new TraineeEntity();
trainee.ID = Trainee.ID;
trainee.Fullname = Trainee.Fullname;
trainee.BirthDate = Trainee.BirthDate;
trainee.GenderEntity = new GenderEntity(Trainee.tblGender);
trainee.AcademicLevelEntity = new AcademicLevelEntity(Trainee.tblAcademicLevel);
trainee.BranchEntity = new BranchEntity(Trainee.tblBranch);
trainee.Address = Trainee.Address;
trainee.PhoneNumber = Trainee.PhoneNumber;
trainee.Photo = Trainee.Photo;
trainee.CreatedBy = Trainee.CreatedBy;
trainee.CreatedDate = Trainee.CreatedDate;
trainee.UpdatedBy = Trainee.UpdatedBy;
trainee.UpdatedDate = (DateTime)Trainee.UpdatedDate;
return(trainee);
}
catch (Exception ex)
{
return(null);
}
}
public int Save(TraineeEntity trainee)
{
try
{
tblTrainee Trainee = new tblTrainee();
Trainee.ID = trainee.ID;
Trainee.Fullname = trainee.Fullname;
Trainee.BirthDate = trainee.BirthDate;
Trainee.GenderID = trainee.GenderEntity.ID;
Trainee.AcademicLevelID = trainee.AcademicLevelEntity.ID;
Trainee.BranchID = trainee.BranchEntity.ID;
Trainee.Address = trainee.Address;
Trainee.PhoneNumber = trainee.PhoneNumber;
Trainee.Photo = trainee.Photo;
Trainee.CreatedBy = trainee.CreatedBy;
Trainee.CreatedDate = trainee.CreatedDate;
Trainee.UpdatedBy = trainee.UpdatedBy;
Trainee.UpdatedDate = trainee.UpdatedDate;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblTrainees.Add(Trainee);
entity.SaveChanges();
return(Trainee.ID);
}
catch (Exception ex)
{
throw;
}
}
public bool Delete(RoleEntity role)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblRole Role = entity.tblRoles.Where(x => x.ID == role.ID).FirstOrDefault();
entity.tblRoles.Remove(Role);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public bool Delete(GenderEntity gender)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblGender Gender = entity.tblGenders.Where(x => x.ID == gender.ID).FirstOrDefault();
entity.tblGenders.Remove(Gender);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public bool Delete(AcademicLevelEntity academicLevel)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblAcademicLevel AcademicLevel = entity.tblAcademicLevels.Where(x => x.ID == academicLevel.ID).FirstOrDefault();
entity.tblAcademicLevels.Remove(AcademicLevel);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public bool Delete(BranchEntity Branch)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblBranch tblBranch = entity.tblBranches.Where(x => x.ID == Branch.ID).FirstOrDefault();
entity.tblBranches.Remove(tblBranch);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public bool Delete(TraineeCourseEntity traineeCourse)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblTraineeCourse TraineeCourse = entity.tblTraineeCourses.Where(x => x.ID == traineeCourse.ID).FirstOrDefault();
entity.tblTraineeCourses.Remove(TraineeCourse);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public RoleEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblRole Role = entity.tblRoles.Where(x => x.ID == ID).FirstOrDefault();
RoleEntity role = new RoleEntity();
role.ID = Role.ID;
role.Name = Role.Name;
return(role);
}
catch (Exception ex)
{
return(null);
}
}
public AcademicLevelEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblAcademicLevel AcademicLevel = entity.tblAcademicLevels.Where(x => x.ID == ID).FirstOrDefault();
AcademicLevelEntity academicLevel = new AcademicLevelEntity();
academicLevel.ID = AcademicLevel.ID;
academicLevel.Title = AcademicLevel.Title;
return(academicLevel);
}
catch (Exception ex)
{
return(null);
}
}
public BranchEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblBranch tblBranch = entity.tblBranches.Where(x => x.ID == ID).FirstOrDefault();
BranchEntity Branch = new BranchEntity();
Branch.ID = tblBranch.ID;
Branch.Name = tblBranch.Name;
return(Branch);
}
catch (Exception ex)
{
return(null);
}
}
public GenderEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblGender Gender = entity.tblGenders.Where(x => x.ID == ID).FirstOrDefault();
GenderEntity gender = new GenderEntity();
gender.ID = Gender.ID;
gender.Title = Gender.Title;
return(gender);
}
catch (Exception ex)
{
return(null);
}
}
public bool Save(BranchEntity Branch)
{
try
{
tblBranch tblBranch = new tblBranch();
tblBranch.ID = Branch.ID;
tblBranch.Name = Branch.Name;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblBranches.Add(tblBranch);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public bool Save(AcademicLevelEntity academicLevel)
{
try
{
tblAcademicLevel AcademicLevel = new tblAcademicLevel();
AcademicLevel.ID = academicLevel.ID;
AcademicLevel.Title = academicLevel.Title;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblAcademicLevels.Add(AcademicLevel);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public CourseEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblCourse Course = entity.tblCourses.Where(x => x.ID == ID).FirstOrDefault();
CourseEntity course = new CourseEntity();
course.ID = Course.ID;
course.Title = Course.Title;
course.Description = Course.Description;
return(course);
}
catch (Exception ex)
{
return(null);
}
}
public bool Save(GenderEntity gender)
{
try
{
tblGender Gender = new tblGender();
Gender.ID = gender.ID;
Gender.Title = gender.Title;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblGenders.Add(Gender);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public UserEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblUser User = entity.tblUsers.Where(x => x.ID == ID).FirstOrDefault();
UserEntity user = new UserEntity();
user.ID = User.ID;
user.Username = User.Username;
user.Password = User.Password;
return(user);
}
catch (Exception ex)
{
return(null);
}
}
public bool Save(RoleEntity role)
{
try
{
tblRole Role = new tblRole();
Role.ID = role.ID;
Role.Name = role.Name;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblRoles.Add(Role);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
