public UserEducationDetail Add(UserEducationDetailUpsert obj)
{
string[] permittedExtensions = { ".jpg", ".jpeg", ".png", ".pdf" };
UserEducationDetail userEducationDetail = new UserEducationDetail();
var ext1 = Path.GetExtension(obj.HighSchoolDegree.FileName);
var ext2 = Path.GetExtension(obj.MinistryofHigherEducationDoc.FileName);
var ext3 = Path.GetExtension(obj.FinancialSupport.FileName);
if ((obj.HighSchoolDegree != null && permittedExtensions.Contains(ext1)))
{
userEducationDetail.HighSchoolDegree = ImageHelper.UploadImageFile(_hostEnvironment, "wwwroot/Uploads/UserEducationDetail/HighSchoolDegree", obj.HighSchoolDegree);
}
if ((obj.MinistryofHigherEducationDoc != null && permittedExtensions.Contains(ext2)))
{
userEducationDetail.MinistryofHigherEducationDoc = ImageHelper.UploadImageFile(_hostEnvironment, "wwwroot/Uploads/UserEducationDetail/MinistryofHigherEducationDoc", obj.MinistryofHigherEducationDoc);
}
if ((obj.FinancialSupport != null && permittedExtensions.Contains(ext3)))
{
userEducationDetail.FinancialSupport = ImageHelper.UploadImageFile(_hostEnvironment, "wwwroot/Uploads/UserEducationDetail/FinancialSupport", obj.FinancialSupport);
}
userEducationDetail.UserID = obj.UserID;
userEducationDetail.ILETSorTOEFL = obj.ILETSorTOEFL;
userEducationDetail.LastDegree = obj.LastDegree;
userEducationDetail.SchoolName = obj.SchoolName;
userEducationDetail.UnitsPassed = obj.UnitsPassed;
return(userEducationDetail);
}
public async Task <IActionResult> PutUserEducationDetail(int id, [FromForm] UserEducationDetailUpsert obj)
{
UserEducationDetail userEducationDetail = await _context.UserEducationDetail.FirstOrDefaultAsync(x => x.UserID == obj.UserID);
userEducationDetail = viewModel.Update(userEducationDetail, obj);
_context.Entry(userEducationDetail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserEducationDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Delete(UserEducationDetail userEducationDetail)
{
if (!string.IsNullOrEmpty(userEducationDetail.HighSchoolDegree))
{
ImageHelper.DeleteImage(_hostEnvironment, @"Uploads\UserEducationDetail\HighSchoolDegree", userEducationDetail.HighSchoolDegree.Replace("/Uploads/UserEducationDetail/HighSchoolDegree/", ""));
}
if (!string.IsNullOrEmpty(userEducationDetail.MinistryofHigherEducationDoc))
{
ImageHelper.DeleteImage(_hostEnvironment, @"Uploads\UserEducationDetail\MinistryofHigherEducationDoc", userEducationDetail.MinistryofHigherEducationDoc.Replace("/Uploads/UserEducationDetail/MinistryofHigherEducationDoc/", ""));
}
if (!string.IsNullOrEmpty(userEducationDetail.FinancialSupport))
{
ImageHelper.DeleteImage(_hostEnvironment, @"Uploads\UserEducationDetail\FinancialSupport", userEducationDetail.FinancialSupport.Replace("/Uploads/UserEducationDetail/FinancialSupport/", ""));
}
}
public async Task <ActionResult <UserEducationDetail> > PostUserEducationDetail([FromForm] UserEducationDetailUpsert obj)
{
if (ModelState.IsValid)
{
UserEducationDetail userEducationDetail = viewModel.Add(obj);
_context.UserEducationDetail.Add(userEducationDetail);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUserEducationDetail", new { id = userEducationDetail.ID }, userEducationDetail));
}
else
{
return(ValidationProblem());
}
}
public List <UserEducationDetail> Get(int userId)
{
var reader = this.GetReader($"select * from usereducationdetails where userId={userId}");
var userEducationDetails = new List <UserEducationDetail>();
while (reader.Read())
{
var userEducationDetail = new UserEducationDetail();
userEducationDetail.Qualification = reader.GetString(2);
userEducationDetail.Course = reader.GetString(3);
userEducationDetail.Specialization = reader.GetString(4);
userEducationDetail.InstituteName = reader.GetString(5);
userEducationDetail.Coursetype = reader.GetString(6);
userEducationDetail.PassingYear = reader.GetInt32(7);
userEducationDetails.Add(userEducationDetail);
}
return(userEducationDetails);
}
public UserEducationDetail Update(UserEducationDetail userEducationDetail, UserEducationDetailUpsert obj)
{
string[] permittedExtensions = { ".jpg", ".jpeg", ".png", ".pdf" };
userEducationDetail.ILETSorTOEFL = obj.ILETSorTOEFL;
userEducationDetail.LastDegree = obj.LastDegree;
userEducationDetail.SchoolName = obj.SchoolName;
userEducationDetail.UnitsPassed = obj.UnitsPassed;
if (obj.MinistryofHigherEducationDoc != null)
{
var ext = Path.GetExtension(obj.MinistryofHigherEducationDoc.FileName);
if (permittedExtensions.Contains(ext))
{
ImageHelper.DeleteImage(_hostEnvironment, @"Uploads\UserEducationDetail\MinistryofHigherEducationDoc", userEducationDetail.MinistryofHigherEducationDoc.Replace("/Uploads/UserEducationDetail/MinistryofHigherEducationDoc/", ""));
userEducationDetail.MinistryofHigherEducationDoc = ImageHelper.UploadImageFile(_hostEnvironment, "wwwroot/Uploads/UserEducationDetail/MinistryofHigherEducationDoc", obj.MinistryofHigherEducationDoc);
}
}
if (obj.FinancialSupport != null)
{
var ext = Path.GetExtension(obj.FinancialSupport.FileName);
if (permittedExtensions.Contains(ext))
{
ImageHelper.DeleteImage(_hostEnvironment, @"Uploads\UserEducationDetail\Recommendations", userEducationDetail.FinancialSupport.Replace("/Uploads/UserEducationDetail/FinancialSupport/", ""));
userEducationDetail.FinancialSupport = ImageHelper.UploadImageFile(_hostEnvironment, "wwwroot/Uploads/UserEducationDetail/FinancialSupport", obj.FinancialSupport);
}
}
if (obj.HighSchoolDegree != null)
{
var ext = Path.GetExtension(obj.HighSchoolDegree.FileName);
if (permittedExtensions.Contains(ext))
{
ImageHelper.DeleteImage(_hostEnvironment, @"Uploads\UserEducationDetail\HighSchoolDegree", userEducationDetail.HighSchoolDegree.Replace("/Uploads/UserEducationDetail/HighSchoolDegree/", ""));
userEducationDetail.HighSchoolDegree = ImageHelper.UploadImageFile(_hostEnvironment, "wwwroot/Uploads/UserEducationDetail/HighSchoolDegree", obj.HighSchoolDegree);
}
}
return(userEducationDetail);
}
public IActionResult Post(UserEducationDetail userEducationDetail)
{
this.UserEducationDetailDomain.Add(userEducationDetail);
return(Ok());
}
public Task DeleteAsync(UserEducationDetail parameters)
{
throw new NotImplementedException();
}
public HashSet <string> DeleteValidation(UserEducationDetail parameters)
{
return(ValidationMessages);
}
public async Task UpdateAsync(UserEducationDetail entity)
{
await Uow.RegisterDirtyAsync(entity);
await Uow.CommitAsync();
}
public HashSet <string> UpdateValidation(UserEducationDetail entity)
{
return(ValidationMessages);
}
public async Task AddAsync(UserEducationDetail entity)
{
await Uow.RegisterNewAsync(entity);
await Uow.CommitAsync();
}
public async Task <object> GetBy(UserEducationDetail parameters)
{
return(await Uow.Repository <UserEducationDetail>().FindByAsync(t => (t.UserId == parameters.UserId || t.UserEducationDetailId == parameters.UserEducationDetailId)));
//throw new NotImplementedException();
}
public Task <object> GetAsync(UserEducationDetail parameters)
{
throw new NotImplementedException();
}
public void Add(UserEducationDetail userEducationDetail)
{
this.ExecuteNonQuery($"insert into UserEducationDetails(UserId,Qualification,Course,Specialization,InstituteName,CourseType,PassingYear) values ({userEducationDetail.UserId},'{userEducationDetail.Qualification}','{userEducationDetail.Course}','{userEducationDetail.Specialization}','{userEducationDetail.InstituteName}','{userEducationDetail.Coursetype}',{userEducationDetail.PassingYear})");
}
