public bool Delete(long id) { int recAffected = 0; DBConnectionString.Course objCourse = db.SingleOrDefault <DBConnectionString.Course>("select * from Courses where CourseId=@0", id); recAffected = objCourse.Delete(); if (recAffected > 0) { return(true); } else { return(false); } }
//public List<Course> GetCourses() //{ // string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName "; // sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on Courses.ModifiedBy=Users_1.UserId"; // List<Course> modelList = db.Query<Course>(sql).ToList(); // return modelList; //} //public Course GetCourses(long id) //{ // string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName "; // sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on Courses.ModifiedBy=Users_1.UserId "; // sql += "where CourseId=@0"; // Course objModel = db.Query<Course>(sql, id).FirstOrDefault(); // return objModel; //} public bool Create(Course objCourse) { int recAffected = 0; DBConnectionString.Course Course = new DBConnectionString.Course(); Course.CourseName = objCourse.CourseName; Course.CourseDescription = objCourse.CourseDescription; Course.OrganisationId = objCourse.OrganisationId; Course.CreatedBy = objCourse.CreatedBy; Course.InsertedOn = DateTime.Now; recAffected = Convert.ToInt32(Course.Insert()); if (recAffected > 0) { return true; } return false; }
//public List<Course> GetCourses() //{ // string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName "; // sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on Courses.ModifiedBy=Users_1.UserId"; // List<Course> modelList = db.Query<Course>(sql).ToList(); // return modelList; //} //public Course GetCourses(long id) //{ // string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName "; // sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on Courses.ModifiedBy=Users_1.UserId "; // sql += "where CourseId=@0"; // Course objModel = db.Query<Course>(sql, id).FirstOrDefault(); // return objModel; //} public bool Create(Course objCourse) { int recAffected = 0; DBConnectionString.Course Course = new DBConnectionString.Course(); Course.CourseName = objCourse.CourseName; Course.CourseDescription = objCourse.CourseDescription; Course.OrganisationId = objCourse.OrganisationId; Course.CreatedBy = objCourse.CreatedBy; Course.InsertedOn = DateTime.Now; recAffected = Convert.ToInt32(Course.Insert()); if (recAffected > 0) { return(true); } return(false); }