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