public bool UpdateWorkByWorkId(TeachingWorkModel updWork) { using (var db = new NpgsqlConnection(connectionString)) { string sqlCheck = "SELECT id FROM public.teaching_work " + "WHERE id = @ID"; string sql = "UPDATE public.teaching_work " + "SET teaching_plan=@TPL " + "WHERE id = @ID"; db.Open(); if (db.Query <string>(sqlCheck, new { ID = updWork.Id }).FirstOrDefault() == null) { return(false); } db.Execute(sql, new { TPL = updWork.TeachingPlan, ID = updWork.Id }); return(true); } }
public bool AddWork(TeachingWorkModel work) { using (var db = new NpgsqlConnection(connectionString)) { string sql = "INSERT INTO public.teaching_work(teaching_plan, teacher_id) " + "VALUES (@TPL, @TID)"; string sqlCheck = "SELECT id FROM public.lecturer " + "WHERE lecturer_id = @ID"; db.Open(); if (db.Query <string>(sqlCheck, new { ID = work.Id }).FirstOrDefault() == null) { return(false); } db.Execute(sql, new { TPL = work.TeachingPlan, TID = work.TeacherId }); return(true); } }