//--------------------------------------------------------------------
// Build the Insert command String
//--------------------------------------------------------------------
private String BuildInsertCommandTrainerLanguage(TrainerLanguage lan)
{
String command;
StringBuilder sb = new StringBuilder();
// use a string builder to create the dynamic string
sb.AppendFormat("Values('{0}', '{1}' )", lan.LCode.ToString(), lan.TrainerCode.ToString());
String prefix = "INSERT INTO SM_LanguageTrainer" + "(LCode , TrainerCode) ";
command = prefix + sb.ToString();
return(command);
}
public int UpdateTrainerLang([FromBody] TrainerLanguage[] t)
{
TrainerLanguage trainer = new TrainerLanguage();
return(trainer.UpdateTrainerLang(t));
}
// POST: api/TrainerLanguage
public int Post([FromBody] TrainerLanguage[] lan)
{
TrainerLanguage l = new TrainerLanguage();
return(l.insert(lan));
}
public List <TrainerLanguage> getTrainerLang(string trainerCode)
{
TrainerLanguage t = new TrainerLanguage();
return(t.GetTrainerLang(trainerCode));
}
