//--------------------------------------------------------------------
// Build the Insert command String
//--------------------------------------------------------------------
private String BuildInsertCommandTrainerQualification(TrainerQualification tQ)
{
String command;
StringBuilder sb = new StringBuilder();
// use a string builder to create the dynamic string
sb.AppendFormat("Values({0}, {1} ,{2}, '{3}', '{4}' )", tQ.TrainerCode.ToString(), tQ.QualificationTypeCode.ToString(), tQ.PopulationCode.ToString(), tQ.DocumentPath, tQ.FromDate);
String prefix = "INSERT INTO SM_TrainerQualification" + "(TrainerCode , QualificationTypeCode ,PopulationCode , DocumentPath, FromDate ) ";
command = prefix + sb.ToString();
return(command);
}
// POST: api/TrainerQualification
public int Post([FromBody] TrainerQualification [] tQ)
{
TrainerQualification t = new TrainerQualification();
return(t.insert(tQ));
}
public int DeleteRequest([FromBody] TrainerQualification tq)
{
TrainerQualification t = new TrainerQualification();
return(t.deleteTrainerQualifications(tq));
}
public int PutIsApprovedTrainer([FromBody] TrainerQualification [] tq)
{
TrainerQualification t = new TrainerQualification();
return(t.updateTrainerQualifications(tq));
}
public List <TrainerQualification> getTrainerQualifications(string trainerCode)
{
TrainerQualification t = new TrainerQualification();
return(t.GetTrainerQual(trainerCode));
}
