public void viewNotAllotStudentInfoButton_Click(object sender, EventArgs e)
{
//deleteIdtextBox.Text = "";
//string server = "ali";
//string database = "hallmanagement";
//string connectionString = string.Format("server={0};database={1};Integrated security=true;", server,
// database);
//connection = new SqlConnection(connectionString);
NewAllotDataAccess dataAccess = new NewAllotDataAccess();
List <StudentInfo> students = dataAccess.viewNotAllotStudentInfo();
studentNotAllotDataGridView.AutoGenerateColumns = false;
studentNotAllotDataGridView.DataSource = students;
studentNotAllotDataGridView.Columns[0].DataPropertyName = "st_Id";
studentNotAllotDataGridView.Columns[1].DataPropertyName = "st_Name";
//studentDataGridView.Columns[2].DataPropertyName = "st_FatherName";
//studentDataGridView.Columns[3].DataPropertyName = "st_MotherName";
studentNotAllotDataGridView.Columns[2].DataPropertyName = "st_Address";
studentNotAllotDataGridView.Columns[7].DataPropertyName = "st_Phone";
studentNotAllotDataGridView.Columns[8].DataPropertyName = "st_Email";
studentNotAllotDataGridView.Columns[3].DataPropertyName = "st_Dept";
studentNotAllotDataGridView.Columns[5].DataPropertyName = "st_Roll";
studentNotAllotDataGridView.Columns[4].DataPropertyName = "st_Cgpa";
studentNotAllotDataGridView.Columns[6].DataPropertyName = "st_Session";
studentNotAllotDataGridView.Columns[9].DataPropertyName = "st_Blood";
}
public void saveAllotCheck(NewAllotInfo aObj)
{
if (aObj.allot_room_no == -1 || aObj.allot_student_id == -1 || aObj.inDate == "")
{
MessageBox.Show("please fill up all properties successfully !!!");
}
else
{
NewAllotDataAccess dobj = new NewAllotDataAccess();
dobj.saveAllotment(aObj);
dobj.updateAvailableSeatInfo(aObj);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
NewAllotInfo Obj = new NewAllotInfo()
{
inDate = allotInDateTextBox.Text
};
//if (allotIdTextBox.Text == "" )
//{
// Obj.allot_id= -1;
//}
if (allotRoomNOTextBox.Text == "" || allotStudentIDTextBox.Text == "")
{
Obj.allot_room_no = -1;
}
//if (allotStudentID.Text == "")
//{
// Obj.allot_student_id = -1;
//}
else
{
//Obj.allot_id = Convert.ToInt32(allotIdTextBox.Text);
Obj.allot_room_no = Convert.ToInt32(allotRoomNOTextBox.Text);
Obj.allot_student_id = Convert.ToInt32(allotStudentIDTextBox.Text);
Obj.availabe_seat = Convert.ToInt32(allotAvailableSeatTextBox.Text);
}
NewAllotCheck ob = new NewAllotCheck();
ob.saveAllotCheck(Obj);
allotRoomNOTextBox.Clear();
allotStudentIDTextBox.Clear();
allotAvailableSeatTextBox.Clear();
allotInDateTextBox.Clear();
NewAllotDataAccess dataAc = new NewAllotDataAccess();
List <StudentInfo> students = dataAc.viewNotAllotStudentInfo();
studentNotAllotDataGridView.AutoGenerateColumns = false;
studentNotAllotDataGridView.DataSource = students;
NewAllotDataAccess dataAccess = new NewAllotDataAccess();
List <RoomInfo> rooms = dataAccess.viewRoomNotFillUpInfo();
roomNotFillUPDataGridView.AutoGenerateColumns = false;
roomNotFillUPDataGridView.DataSource = rooms;
}
public void viewAvailableSeatFillUpButton_Click(object sender, EventArgs e)
{
//deleteRoomTextBox.Text = "";
NewAllotDataAccess dataAccess = new NewAllotDataAccess();
List <RoomInfo> rooms = dataAccess.viewRoomNotFillUpInfo();
roomNotFillUPDataGridView.AutoGenerateColumns = false;
roomNotFillUPDataGridView.DataSource = rooms;
roomNotFillUPDataGridView.Columns[0].DataPropertyName = "rm_No";
roomNotFillUPDataGridView.Columns[1].DataPropertyName = "block_No";
roomNotFillUPDataGridView.Columns[2].DataPropertyName = "floor_No";
roomNotFillUPDataGridView.Columns[3].DataPropertyName = "available_Seat";
}
