public int UpdateCustomerCourse(RequestModel <CustomerCourseModel> input)
{
var customerCourse = this.RepositoryContext.CustomerCourse
.Where(x => x.Id == input.RequestParameter.Id && x.Active == CommonConstants.ActiveStatus)
.FirstOrDefault();
if (customerCourse != null)
{
customerCourse.Name = input.RequestParameter.Name;
//customerCourse.VedicCourseId = input.RequestParameter.VedicCourseId;
//customerCourse.CourseTypeId = input.RequestParameter.CourseTypeId;
customerCourse.CourseDescription = input.RequestParameter.CourseDescription;
customerCourse.Duration = input.RequestParameter.Duration;
customerCourse.DurationUOM = input.RequestParameter.DurationUOM;
customerCourse.CourseCost = input.RequestParameter.CourseCost;
customerCourse.ModifiedBy = input.RequestParameter.UserId;
customerCourse.ModifiedDate = DateTime.Now;
//Save in database
this.RepositoryContext.Update(customerCourse);
// this.RepositoryContext.SaveChanges();
var SubjectHiearchyIdList = this.RepositoryContext.CustomerCourseSubject
.Where(x => x.CustomerId == input.CustomerId && x.CustomerCourseId == customerCourse.Id);
foreach (var subj in SubjectHiearchyIdList)
{
this.RepositoryContext.Remove(subj);
}
//this.RepositoryContext.SaveChanges();
foreach (int coursehierarchy in input.RequestParameter.CustomerSubjectHiearchyIdList)
{
CustomerCourseSubjectMappingDB customerCourseSubject = new CustomerCourseSubjectMappingDB
{
CreatedBy = input.RequestParameter.UserId,
CreatedDate = DateTime.Now,
Active = CommonConstants.ActiveStatus,
CustomerId = input.CustomerId.GetValueOrDefault(),
CustomerCourseId = customerCourse.Id,
CustomerSubjectHierarchyId = coursehierarchy
};
this.RepositoryContext.Add(customerCourseSubject);
}
//Save in database
this.RepositoryContext.SaveChanges();
}
return(CommonConstants.Success);
}
public int AddCustomerCourse(RequestModel <CustomerCourseModel> input)
{
//this.RepositoryContext.Database.BeginTransaction();
//Make db object
CustomerCourseDB customerCourse = new CustomerCourseDB
{
CreatedBy = input.RequestParameter.UserId,
CreatedDate = DateTime.Now,
Active = CommonConstants.ActiveStatus,
CourseCost = input.RequestParameter.CourseCost,
CourseDescription = input.RequestParameter.CourseDescription,
CourseTypeId = null,// input.RequestParameter.CourseTypeId,
Duration = input.RequestParameter.Duration,
DurationUOM = input.RequestParameter.DurationUOM,
VedicCourseId = null,// input.RequestParameter.VedicCourseId,
CustomerId = input.CustomerId.GetValueOrDefault(),
Name = input.RequestParameter.Name,
};
input.RequestParameter.Id = customerCourse.Id;
//Save in database
this.RepositoryContext.Add(customerCourse);
this.RepositoryContext.SaveChanges();
foreach (int coursehierarchy in input.RequestParameter.CustomerSubjectHiearchyIdList)
{
CustomerCourseSubjectMappingDB customerCourseSubject = new CustomerCourseSubjectMappingDB
{
CreatedBy = input.RequestParameter.UserId,
CreatedDate = DateTime.Now,
Active = CommonConstants.ActiveStatus,
CustomerId = input.CustomerId.GetValueOrDefault(),
CustomerCourseId = customerCourse.Id,
CustomerSubjectHierarchyId = coursehierarchy
};
this.RepositoryContext.Add(customerCourseSubject);
}
//Save in database
this.RepositoryContext.SaveChanges();
//this.RepositoryContext.Database.CommitTransaction();
return(customerCourse.Id);
}
