public bool insertAssignedGroups(AssignRooms assignTagRoom) { try { //string Query = "Insert into AssignTagRoom(group,tag,building,room) values(" + // "" + assignTagRoom.group + "," + // "'" + assignTagRoom.tag + "'," + // "'" + assignTagRoom.building + "'," + // "'" + assignTagRoom.room + "')"; int groupNonew = assignTagRoom.groupNo; string Query = "Insert into AssignTagRoom(groupNo,tag,building,room) values(" + groupNonew + ",'" + assignTagRoom.tag + "', '" + assignTagRoom.building + "', '" + assignTagRoom.room + "')"; SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); SqlDataReader myReader; DBConnection.OpenConnection(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { } DBConnection.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
//public List<AssignRooms> getAssignRoomToSubgroups() //{ // List<AssignRooms> listAssignRoom = new List<AssignRooms>(); // try // { // string Query = "Select tag,building,room,groupNo,subgroup from AssignTagRoom"; // SqlConnection DBConnection.connection = new SqlConnection(DBConnection.connectionString); // SqlCommand cmd = new SqlCommand(Query, DBConnection.connection); // SqlDataReader myReader; // DBConnection.OpenConnection(); // myReader = cmd.ExecuteReader(); // while (myReader.Read()) // { // AssignRooms objAssignedRoom = new AssignRooms(); // objAssignedRoom.tag = myReader["tag"].ToString(); // objAssignedRoom.building = myReader["building"].ToString(); // objAssignedRoom.room = myReader["room"].ToString(); // objAssignedRoom.groupNo = Convert.ToInt32(myReader["groupNo"].ToString()); // objAssignedRoom.subgroup = myReader["subgroup"].ToString(); // listAssignRoom.Add(objAssignedRoom); // } // } // catch (Exception ex) // { // } // return listAssignRoom; //} public List <AssignRooms> getAssignRoomToSubjects() { List <AssignRooms> listAssignRoom = new List <AssignRooms>(); try { string Query = "Select tag,building,room,subject from AssignTagRoom"; SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); SqlDataReader myReader; DBConnection.OpenConnection(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { AssignRooms objAssignedRoom = new AssignRooms(); objAssignedRoom.tag = myReader["tag"].ToString(); objAssignedRoom.building = myReader["building"].ToString(); objAssignedRoom.room = myReader["room"].ToString(); objAssignedRoom.subject = myReader["subject"].ToString(); listAssignRoom.Add(objAssignedRoom); } } catch (Exception ex) { } return(listAssignRoom); }
public bool insertAssignedLecturer(AssignRooms assignTagRoom) { try { string Query = "Insert into AssignTagRoom(lecturer,tag,building,room) " + "values(" + "'" + assignTagRoom.lecturer + "'," + "'" + assignTagRoom.tag + "'," + "'" + assignTagRoom.building + "'," + "'" + assignTagRoom.room + "')"; SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); SqlDataReader myReader; DBConnection.OpenConnection(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { } DBConnection.CloseConnection(); return(true); } catch (Exception ex) { return(false); } }
public List <AssignRooms> getAssignedRooms() { List <AssignRooms> listAssignRoom = new List <AssignRooms>(); try { string Query = "Select tag,building,room,lecturer, groupNo,subgroup,subject from AssignTagRoom"; SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection); SqlDataReader myReader; DBConnection.OpenConnection(); myReader = cmd.ExecuteReader(); while (myReader.Read()) { AssignRooms objAssignedRoom = new AssignRooms(); //objAssignedRoom.tag = myReader["tag"].ToString(); //objAssignedRoom.building = myReader["building"].ToString(); //objAssignedRoom.room = myReader["room"].ToString(); //objAssignedRoom.lecturer = myReader["lecturer"].ToString(); //objAssignedRoom.groupNo = Convert.ToInt32(myReader["groupNo"].ToString()); //if (myReader["subgroup"].ToString() == null) { objAssignedRoom.subgroup = "";} else { objAssignedRoom.subgroup = myReader["subgroup"].ToString(); } //objAssignedRoom.subject = myReader["subject"].ToString(); if (myReader["tag"].ToString() == null) { objAssignedRoom.tag = ""; } else { objAssignedRoom.tag = myReader["tag"].ToString(); } if (myReader["building"].ToString() == null) { objAssignedRoom.building = ""; } else { objAssignedRoom.building = myReader["building"].ToString(); } if (myReader["room"].ToString() == null) { objAssignedRoom.room = ""; } else { objAssignedRoom.room = myReader["room"].ToString(); } if (myReader["lecturer"].ToString() == null) { objAssignedRoom.lecturer = ""; } else { objAssignedRoom.lecturer = myReader["lecturer"].ToString(); } if (myReader["groupNo"].ToString() == "") { objAssignedRoom.groupNo = 0; } else { objAssignedRoom.groupNo = Convert.ToInt32(myReader["groupNo"].ToString()); } if (myReader["subgroup"].ToString() == null) { objAssignedRoom.subgroup = ""; } else { objAssignedRoom.subgroup = myReader["subgroup"].ToString(); } if (myReader["subject"].ToString() == null) { objAssignedRoom.subject = ""; } else { objAssignedRoom.subject = myReader["subject"].ToString(); } listAssignRoom.Add(objAssignedRoom); } } catch (Exception ex) { } return(listAssignRoom); }