// Create Lectures public int createLecture(lectureModel lectureData, bool feed, DateTime endDate) { int result = 0; using (myProjectEntities context = new myProjectEntities()) { lectureData.lecture_status = 1; Mapper.CreateMap <lectureModel, tblLecture>(); tblLecture newLec = Mapper.Map <lectureModel, tblLecture>(lectureData); context.tblLectures.Add(newLec); int qq = context.SaveChanges(); result = qq; if (feed) { feedbackModel feedModel = new feedbackModel(); feedModel.FK_Lecture_id = newLec.PK_Lecture_id; feedModel.end_date = endDate; qq = createFeedback(feedModel); } return(result); } }
public feedbackModel GetFeedbackByLectureId(int lectureId) { using (myProjectEntities context = new myProjectEntities()) { tblFeedback feed = context.tblFeedbacks.Where(q => q.FK_Lecture_id == lectureId).FirstOrDefault(); Mapper.CreateMap <tblFeedback, feedbackModel>(); feedbackModel result = Mapper.Map <tblFeedback, feedbackModel>(feed); return(result); } }
//Create new Feedback public int createFeedback(feedbackModel feedData) { int result = 0; using (myProjectEntities context = new myProjectEntities()) { Mapper.CreateMap <feedbackModel, tblFeedback>(); tblFeedback newFeed = Mapper.Map <feedbackModel, tblFeedback>(feedData); context.tblFeedbacks.Add(newFeed); int q = context.SaveChanges(); if (q > 0) { result = newFeed.PK_Feedback_id; } return(result); } }