public bool fnIsExist(ProgramM programM)
{
string sSql = " SELECT COUNT([program_id]) " +
" FROM [MNDTprogram_master] " +
" WHERE [program_id] = '" + programM.program_id + "' ";
return(PublicApi.fnGetValue(sSql, "MNDT") == "1");
}
private void button1_Click(object sender, RoutedEventArgs e)
{
string FamA = textBoxFAM.Text;
string Imj = textBoxIM.Text;
string Otch = textBoxOT.Text;
int Kurs = textBoxKU.Text;
double Stip = textBoxST.Text;
string Gor = textBoxG.Text;
ProgramM infProgramM = new ProgramM(FamA, Imj, Otch, Kurs, Stip, Gor);
repository.Add(infProgramM);
Close();
}
public DataTable fnSelects(ProgramM programM)
{
string sSql = " SELECT [program_id], " +
" [name], " +
" [parent], " +
" [url] " +
" FROM [MNDTprogram_master] " +
" WHERE [parent] = 'ROOT' " +
" OR [program_id] IN (SELECT DISTINCT [program_id] " +
" FROM [MNDTprogram_details] " +
" WHERE [group_id] IN (SELECT DISTINCT [group_id] " +
" FROM [MNDTgroup_details] " +
" WHERE [id] = '" + programM.id + "')) ";
return(PublicApi.fnGetDt(sSql, "MNDT"));
}
