public async Task <ApiResponse> Handle(AddQualificationDetailsCommand request, CancellationToken cancellationToken)
{
ApiResponse response = new ApiResponse();
try
{
QualificationDetails existrecord = await _dbContext.QualificationDetails.FirstOrDefaultAsync(x => x.QualificationName == request.QualificationName);
if (existrecord == null)
{
QualificationDetails obj = _mapper.Map <QualificationDetails>(request);
obj.IsDeleted = false;
await _dbContext.QualificationDetails.AddAsync(obj);
await _dbContext.SaveChangesAsync();
response.StatusCode = StaticResource.successStatusCode;
response.Message = "Success";
}
else
{
response.StatusCode = StaticResource.MandateNameAlreadyExistCode;
response.Message = "Qualification Name already exist.";
}
}
catch (Exception ex)
{
response.StatusCode = StaticResource.failStatusCode;
response.Message = ex.Message;
}
return(response);
}
public ActionResult Search(string prefix)
{
var countries = objOras.GetEducations().Where(p => p.DegreeName.ToUpper() == prefix.ToUpper());
int pageindex = 0;
var filter = countries.OrderBy(p => p.QualificationId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
if (filter.Count() > 0)
{
QualificationDetails obj = new QualificationDetails()
{
Status = true,
QualificationList = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
QualificationDetails obj = new QualificationDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.NoRecords : "No Records to display"
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
public async Task <IActionResult> Edit(EditQualificationViewModel model)
{
var id = User.FindFirstValue(ClaimTypes.NameIdentifier);
// bool ifExist = _context.QualificationDetails.Contains
if (ModelState.IsValid)
{
QualificationDetails quali = new QualificationDetails
{
ApplicantDetailsId = id,
TenthPercentage = model.TenthPercentage,
TwelthPercentage = model.TwelthPercentage,
HighestQualifcation = model.HighestQualifcation
};
}
if (id == null)
{
return(NotFound());
}
var qualification = await _context.QualificationDetails.FindAsync(id);
if (qualification == null)
{
return(NotFound());
}
//ViewData["QualifcationId"] = new SelectList(_context.QualificationDetails, "Id", "Id", qualification.ApplicantDetailsId);
return(View(qualification));
}
public ActionResult Update(tblQualification model)
{
var countries = objOras.GetEducations();
var test = countries.Where(p => p.DegreeName.ToUpper() == model.DegreeName.ToUpper()).FirstOrDefault();
QualificationDetails obj = new QualificationDetails();
if (test != null)
{
obj.Status = false;
obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.AlreadyExist : "Record already exist.";
}
else
{
obj.Status = true;
obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.UpdateSuccess : "Record updated successfully.";
objOras.Update(model);
}
int pageindex = 0;
var filter = countries.OrderBy(p => p.QualificationId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = countries;
Session["pageindex"] = 0;
obj.QualificationList = filter;
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public ActionResult QualificationLast()
{
var users = objOras.GetEducations();
QualificationDetails obj = new QualificationDetails();
int pageindex = Convert.ToInt32(Session["pageindex"]);
pageindex++;
obj.Status = true;
if (users != null)
{
Session["pageindex"] = pageindex;
if ((users.Count() % PageSize) == 0)
{
obj.QualificationList = users.OrderBy(p => p.QualificationId).Skip(users.Count() - 2).Take(PageSize);
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
int rem = users.Count() % PageSize;
obj.QualificationList = users.OrderBy(p => p.QualificationId).Skip(users.Count() - rem).Take(PageSize);
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(QualificationFirst());
}
}
public ActionResult QualificationPrev()
{
IQueryable <tblQualification> users = (IQueryable <tblQualification>)Session["users"];
if (users != null)
{
int pageindex = Convert.ToInt32(Session["pageindex"]);
if (pageindex > 0)
{
pageindex--;
var filter = users.OrderBy(p => p.QualificationId).Skip(pageindex * PageSize).Take(PageSize);
Session["pageindex"] = pageindex;
QualificationDetails obj = new QualificationDetails()
{
Status = true,
ErrorMessage = "",
QualificationList = filter,
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
else
{
QualificationDetails obj = new QualificationDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.FirstPage : "You are already on first page",
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(QualificationFirst());
}
}
public ActionResult QualificationFirst()
{
IQueryable <tblQualification> users = (IQueryable <tblQualification>)Session["users"];
int pageindex = 0;
var filter = users.OrderBy(p => p.QualificationId).Skip(pageindex * PageSize).Take(PageSize);
Session["users"] = users;
Session["pageindex"] = 0;
QualificationDetails obj = new QualificationDetails()
{
Status = true,
QualificationList = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public ActionResult QualificationNext()
{
IQueryable <tblQualification> users = (IQueryable <tblQualification>)Session["users"];
if (users != null)
{
int pageindex = Convert.ToInt32(Session["pageindex"]);
pageindex++;
var filter = users.OrderBy(p => p.QualificationId).Skip(pageindex * PageSize).Take(PageSize);
if (filter.Count() > 0)
{
Session["pageindex"] = pageindex;
QualificationDetails obj = new QualificationDetails()
{
Status = true,
ErrorMessage = "",
QualificationList = filter
};
return(Json(obj, JsonRequestBehavior.AllowGet));
//return Json(filter, JsonRequestBehavior.AllowGet);
}
else
{
QualificationDetails obj = new QualificationDetails()
{
Status = false,
ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.NoMoreInformationAvail : "आणखी माहिती उपलब्ध नाही"
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
else
{
return(QualificationFirst());
}
}
