public async Task <CreateHITResponse> createHit(Survey survey, string reward, int maxSurveys)
{
CreateHITResponse response = new CreateHITResponse();
try
{
this._survey = survey;
AmazonMTurkClient client = this.getMTurkClient();
string questionXML = "";
CreateHITRequest hitRequest = new CreateHITRequest();
hitRequest.Title = this._survey.SurveyName;
hitRequest.Reward = reward;
hitRequest.Question = this.getExternalForm();
hitRequest.Description = this._survey.Notes;
hitRequest.AssignmentDurationInSeconds = 7200;
hitRequest.LifetimeInSeconds = 7200;
hitRequest.MaxAssignments = maxSurveys;
Qualification qualification = new Qualification();
qualification.QualificationTypeId = "00000000000000000071";
QualificationType qType = new QualificationType();
System.Threading.CancellationToken token = new System.Threading.CancellationToken();
response = await client.CreateHITAsync(hitRequest, token);
return(response);
}
catch (Exception e)
{
Console.Write(e);
return(response);
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
QualificationType qualificationType = await _ctx.QualificationTypes.FindAsync(id);
_ctx.QualificationTypes.Remove(qualificationType);
await _ctx.SaveChangesAsync();
return(RedirectToAction("Default"));
}
private void CreateEmployeeQualification(int employeeID, QualificationType qualificationType)
{
SqlCommand command = new SqlCommand("spInsertEmployeeQualification");
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@EmployeeID", employeeID));
command.Parameters.Add(new SqlParameter("@QualificationType", qualificationType.ToString()));
DatabaseController.ExecuteNonQuerySP(command);
}
public QualificationGrade Build(QualificationType qualificationType = null) => new QualificationGrade
{
Grade = "A",
QualificationType = qualificationType ?? new QualificationTypeBuilder().Build(),
IsAllowable = true,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
};
public async Task <ActionResult> Edit(QualificationType qualificationType)
{
if (ModelState.IsValid)
{
_ctx.Entry(qualificationType).State = EntityState.Modified;
await _ctx.SaveChangesAsync();
return(RedirectToAction("Default"));
}
return(View(qualificationType));
}
public void Should_Construct_QualificationType()
{
QualificationType qualificationType = new QualificationType();
_ = qualificationType.ID;
_ = qualificationType.Name;
_ = qualificationType.NameEn;
_ = qualificationType.IsDeleted;
_ = qualificationType.QualificationTypeCategories;
qualificationType.ShouldNotBeNull();
}
public bool Equals(Qualification other)
{
if (other == null)
{
return(false);
}
return(QualificationType.Equals(other.QualificationType) &&
Subject.Equals(other.Subject) &&
Grade.Equals(other.Grade) &&
Weighting.Equals(other.Weighting));
}
public async Task <ActionResult> Create(QualificationType qualificationType)
{
if (ModelState.IsValid)
{
_ctx.QualificationTypes.Add(qualificationType);
await _ctx.SaveChangesAsync();
return(RedirectToAction("Default"));
}
return(View(qualificationType));
}
public Qualification Build(QualificationType qualificationType = null, TlLookup subjectLookup = null) => new Qualification
{
TlLookup = subjectLookup ?? new TlLookupBuilder().BuildSubjectType(),
QualificationType = qualificationType ?? new QualificationTypeBuilder().Build(),
Code = "100/1976/5",
Title = "EDEXCEL Level 1/Level 2 GCSE in English Literature",
IsSendQualification = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
};
// GET: Admin/QualificationManagement/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
QualificationType qualificationType = await _ctx.QualificationTypes.FindAsync(id);
if (qualificationType == null)
{
return(HttpNotFound());
}
return(View(qualificationType));
}
public static QualificationType CreateQualificationType(ResultsAndCertificationDbContext _dbContext, string name, string subTitle, bool isActive, bool addToDbContext = true)
{
var qualificationType = new QualificationType
{
Name = name,
SubTitle = subTitle,
IsActive = isActive,
CreatedBy = "Test User"
};
if (addToDbContext)
{
_dbContext.Add(qualificationType);
}
return(qualificationType);
}
public ActionResult getCompanies()
{
var companies = companyManager.FindList();
string qt = Request.QueryString["QualificationType"];
string ql = Request.QueryString["QualificationLevel"];
string name = Request.QueryString["Name"];
if (qt != null && qt != "-1")
{
QualificationType t = (QualificationType)int.Parse(qt);
companies = companies.Where(c => c.Type1 == t || c.Type2 == t);
}
if (ql != null && ql != "-1")
{
QualificationLevel l = (QualificationLevel)int.Parse(ql);
companies = companies.Where(c => c.Level1 == l || c.Level2 == l);
}
if (name != null && name != "")
{
companies = companies.Where(c => c.Name.Contains(name));
}
companies = companies.OrderByDescending(c => c.ID);
var data = companies.Select(c => new
{
ID = c.ID,
Name = c.Name,
Type = c.Type1.ToString() + (c.Type2 == null ? "" : "/" + c.Type2.ToString()),
Level = c.Level1.ToString() + (c.Type2 == null ? "" : "/" + c.Level2.ToString()),
Number = c.Number1.ToString() + (c.Type2 == null ? "" : "/" + c.Number2.ToString()),
State = (c.ExpiryDate1 > DateTime.Now ? "有效" : "无效") + (c.Type2 == null ? "" : ("/" + (c.ExpiryDate2 > DateTime.Now ? "有效" : "无效"))),
Score = c.Score
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public IList <QualificationGrade> BuildList(QualificationType qualificationType = null)
{
qualificationType ??= new QualificationTypeBuilder().Build();
var qualificationGrades = new List <QualificationGrade>
{
new QualificationGrade
{
Grade = "A",
QualificationTypeId = qualificationType.Id,
IsAllowable = true,
IsSendGrade = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
},
new QualificationGrade
{
Grade = "B",
QualificationTypeId = qualificationType.Id,
IsAllowable = true,
IsSendGrade = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
},
new QualificationGrade
{
Grade = "C",
QualificationTypeId = qualificationType.Id,
IsAllowable = true,
IsSendGrade = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
},
new QualificationGrade
{
Grade = "D",
QualificationTypeId = qualificationType.Id,
IsAllowable = false,
IsSendGrade = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
},
new QualificationGrade
{
Grade = "E",
QualificationTypeId = qualificationType.Id,
IsAllowable = false,
IsSendGrade = true,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
}
};
return(qualificationGrades);
}
public IList <Qualification> BuildList(QualificationType qualificationType = null)
{
qualificationType ??= new QualificationTypeBuilder().Build();
var subjectLookupList = new TlLookupBuilder().BuildSubjectTypeList();
var englishSubject = subjectLookupList.FirstOrDefault(x => x.Code.Equals("Eng", System.StringComparison.InvariantCultureIgnoreCase));
var mathsSubject = subjectLookupList.FirstOrDefault(x => x.Code.Equals("Math", System.StringComparison.InvariantCultureIgnoreCase));
var qualificationList = new List <Qualification> {
new Qualification
{
TlLookupId = mathsSubject.Id,
TlLookup = mathsSubject,
QualificationTypeId = qualificationType.Id,
QualificationType = qualificationType,
Code = "500/7856/2",
Title = "AQA Level 1/Level 2 GCSE in Mathematics",
IsSendQualification = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
},
new Qualification
{
TlLookupId = englishSubject.Id,
TlLookup = englishSubject,
QualificationTypeId = qualificationType.Id,
QualificationType = qualificationType,
Code = "601/4292/3",
Title = "AQA Level 1/Level 2 GCSE (9-1) in English Language",
IsSendQualification = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
},
new Qualification
{
TlLookupId = mathsSubject.Id,
TlLookup = mathsSubject,
QualificationTypeId = qualificationType.Id,
QualificationType = qualificationType,
Code = "100/3432/8",
Title = "CCEA Advanced GCE in Mathematics",
IsSendQualification = false,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
},
new Qualification
{
TlLookupId = englishSubject.Id,
TlLookup = englishSubject,
QualificationTypeId = qualificationType.Id,
QualificationType = qualificationType,
Code = "500/8464/1",
Title = "Pearson Edexcel Functional Skills Qualification in English at Entry 3",
IsSendQualification = true,
IsActive = true,
CreatedBy = Constants.CreatedByUser,
CreatedOn = Constants.CreatedOn,
ModifiedBy = Constants.ModifiedByUser,
ModifiedOn = Constants.ModifiedOn
}
};
return(qualificationList);
}
public static Qualification CreateQualification(ResultsAndCertificationDbContext _dbContext, QualificationType qualificationType, TlLookup tlLookup, string code, string title, bool isSendQualification, bool isActive, bool addToDbContext = true)
{
if (qualificationType != null && tlLookup != null)
{
var qualification = new Qualification
{
QualificationTypeId = qualificationType.Id,
QualificationType = qualificationType,
TlLookupId = tlLookup.Id,
TlLookup = tlLookup,
Code = code,
Title = title,
IsSendQualification = isSendQualification,
IsActive = isActive,
CreatedBy = "Test User"
};
if (addToDbContext)
{
_dbContext.Add(qualification);
}
return(qualification);
}
return(null);
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
int id = (int)value;
return(QualificationType.GetQualificationTypeByID(id));
}
public static QualificationType CreateQualificationType(ResultsAndCertificationDbContext _dbContext, QualificationType qualificationType, bool addToDbContext = true)
{
if (qualificationType == null)
{
qualificationType = new QualificationTypeBuilder().Build();
}
if (addToDbContext)
{
_dbContext.Add(qualificationType);
}
return(qualificationType);
}
