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); }