public void Update(MainScholarship item) { using (APCRSHREntities context = new APCRSHREntities()) { var scholarship = context.MainScholarships.Where(a => a.ScholarshipID.Equals(item.ScholarshipID)).SingleOrDefault(); if (scholarship != null) { scholarship.HasSubmitted = item.HasSubmitted; scholarship.Organization = item.Organization; scholarship.Position = item.Position; scholarship.ReasonScholarship = item.ReasonScholarship; scholarship.Responsibility = item.Responsibility; scholarship.UpdatedBy = item.UpdatedBy; scholarship.UpdatedDate = DateTime.Now; scholarship.DurationOfWork = item.DurationOfWork; scholarship.SubmissionTitles = item.SubmissionTitles; //scholarship.UserID = item.UserID; scholarship.Status = item.Status; scholarship.ScholarshipPackage = item.ScholarshipPackage; context.SaveChanges(); } else { throw new Exception(string.Format("Scholarship id {0} invalid", item.ScholarshipID)); } } }
public object Insert(MainScholarship item) { using (APCRSHREntities context = new APCRSHREntities()) { context.MainScholarships.Add(item); context.SaveChanges(); return(item.ScholarshipID); } }
public DataModel.Response.FindItemReponse <DataModel.Model.MainScholarshipModel> FindByID(string id) { try { IMainScholarshipRepository mainScholarshipRepository = RepositoryClassFactory.GetInstance().GetMainScholarshipRepository(); MainScholarship scholarship = mainScholarshipRepository.FindByID(id); var _scholarship = MapperUtil.CreateMapper().Mapper.Map <MainScholarship, MainScholarshipModel>(scholarship); if (_scholarship != null) { IMailingAddressRepository mailingRepository = RepositoryClassFactory.GetInstance().GetMailingAddressRepository(); IUserSubmissionRepository userSubmissionRepository = RepositoryClassFactory.GetInstance().GetUserSubmissionRepository(); IList <MailingAddress> _mailings = mailingRepository.FindByUserID(_scholarship.UserID); IList <UserSubmission> _submissions = userSubmissionRepository.FindByUserID(_scholarship.UserID); if (_mailings != null && _mailings.Count > 0) { _scholarship.RegistrationNumber = _mailings.FirstOrDefault().RegistrationNumber; } if (_submissions != null && _submissions.Count > 0) { _scholarship.SubmissionNumber = _submissions.FirstOrDefault().SubmissionNumber; } } return(new FindItemReponse <MainScholarshipModel> { Item = _scholarship, ErrorCode = (int)ErrorCode.None, Message = string.Empty }); } catch (Exception ex) { return(new FindItemReponse <MainScholarshipModel> { ErrorCode = (int)ErrorCode.Error, Message = ex.Message }); } }
public FindItemReponse <MainScholarshipModel> FindByUserIDAndSubmission(string userID, string submissionNumber) { try { IMainScholarshipRepository mainScholarshipRepository = RepositoryClassFactory.GetInstance().GetMainScholarshipRepository(); MainScholarship scholarship = mainScholarshipRepository.FindByUserIDAndSubmission(userID, submissionNumber); var _scholarship = MapperUtil.CreateMapper().Mapper.Map <MainScholarship, MainScholarshipModel>(scholarship); return(new FindItemReponse <MainScholarshipModel> { Item = _scholarship, ErrorCode = (int)ErrorCode.None, Message = string.Empty }); } catch (Exception ex) { return(new FindItemReponse <MainScholarshipModel> { ErrorCode = (int)ErrorCode.Error, Message = ex.Message }); } }