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