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);
}
