public string PrepareSQLStringForInsertToDB() { string WhenDateForSqlString = !String.IsNullOrEmpty(WhenDate) ? "'" + (WhenDate.Substring(6, 4) + "-" + WhenDate.Substring(3, 2) + "-" + WhenDate.Substring(0, 2) + " 00:00:00'") : "null"; string VoteForSqlString = !String.IsNullOrEmpty(Vote) ? Vote : "null"; return("insert into ClassRoomTasks (WhenDate, Vote, TaskId, SubjectId) " + $"values ({WhenDateForSqlString}, {VoteForSqlString}, " + $"(select Id from ClassroomTaskTypes where Description = '{ClassRoomTaskType}')," + $"(select Id from Subjects where Description = '{SubjectDescritpion}')) "); }
public string PrepareSQLStringForUpdateToDB() { string WhenDateForSqlString = !String.IsNullOrEmpty(WhenDate) ? "'" + (WhenDate.Substring(6, 4) + "-" + WhenDate.Substring(3, 2) + "-" + WhenDate.Substring(0, 2) + " 00:00:00'") : "null"; string VoteForSqlString = !String.IsNullOrEmpty(Vote) ? Vote : "null"; return($"update ClassRoomTasks set WhenDate = {WhenDateForSqlString}, Vote = {VoteForSqlString}, " + $"TaskId = (select Id from ClassroomTaskTypes where Description = '{ClassRoomTaskType}'), " + $"SubjectId = (select Id from Subjects where Description = '{SubjectDescritpion}') " + $"where Id = {Id} "); }