//public List<Department> GetDepartments() //{ // string sql = "select Departments.DepartmentId,Departments.DepartmentName,Departments.DepartmentDesc,Departments.CreatedBy,Departments.CreatedDate,Departments.UpdatedBy,Departments.UpdatedDate, Organizations.OrganizationName,Users.Username as InsertedByName,Users_1.Username as ModifiedByName,Departments.OrganizationId "; // sql += "from Departments join Organizations on Departments.OrganizationId=Organizations.OrganizationId join Users on Departments.CreatedBy=Users.UserId left join Users as Users_1 on Departments.UpdatedBy=Users_1.UserId"; // List<Department> departmentList = db.Query<Department>(sql).ToList(); // return departmentList; //} //public Department GetDepartments(long id) //{ // string sql = "select Departments.DepartmentId,Departments.DepartmentName,Departments.DepartmentDesc,Departments.CreatedBy,Departments.CreatedDate,Departments.UpdatedBy,Departments.UpdatedDate, Organizations.OrganizationName,Users.Username as InsertedByName,Users_1.Username as ModifiedByName, Departments.OrganizationId "; // sql += "from Departments join Organizations on Departments.OrganizationId=Organizations.OrganizationId join Users on Departments.CreatedBy=Users.UserId left join Users as Users_1 on Departments.UpdatedBy=Users_1.UserId "; // sql += "where DepartmentId=@0"; // Department objDepartment = db.Query<Department>(sql, id).FirstOrDefault(); // return objDepartment; //} //public bool CreateDepartment(Department objDepartment) //{ // int recAffected = 0; // DBConnectionString.Department Department = new DBConnectionString.Department(); // Department.DepartmentName = objDepartment.DepartmentName; // Department.DepartmentDesc = objDepartment.DepartmentDesc; // Department.OrganizationId = objDepartment.OrganizationId; // Department.CreatedDate = DateTime.Now; // Department.CreatedBy = objDepartment.CreatedBy; // recAffected = Convert.ToInt32(Department.Insert()); // if (recAffected > 0) // { // return true; // } // return false; //} public bool UpdateDepartment(Department objDepartment) { int recAffected = 0; DBConnectionString.Department Department = new DBConnectionString.Department(); Department.DepartmentId = objDepartment.DepartmentId; Department.DepartmentName = objDepartment.DepartmentName; Department.DepartmentDesc = objDepartment.DepartmentDesc; Department.OrganizationId = objDepartment.OrganizationId; Department.CreatedDate = objDepartment.CreatedDate; Department.CreatedBy = objDepartment.CreatedBy; Department.UpdatedBy = objDepartment.UpdatedBy; Department.UpdatedDate = DateTime.Now; recAffected = Department.Update(); if (recAffected > 0) { return true; } return false; }