private void loadRoom() { try { using (EFDBEntities1 db = new EFDBEntities1()) { comboRoom.DataSource = db.Rooms.ToList(); comboRoom.ValueMember = "RoomID"; comboRoom.DisplayMember = "RoomName"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void loadStdSubGr() { try { using (EFDBEntities1 db = new EFDBEntities1()) { combosubGr.DataSource = db.Academic1.ToList(); combosubGr.ValueMember = "Studid"; combosubGr.DisplayMember = "SubGroupId11"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void GridroomForGroupSub_DoubleClick(object sender, EventArgs e) { if (GridroomForGroupSub.CurrentRow.Index != -1) { ModelroomForGrSub.RsubGID = Convert.ToInt32(GridroomForGroupSub.CurrentRow.Cells["RsubGID"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { ModelroomForGrSub = db.RoomForGrSubs.Where(x => x.RsubGID == ModelroomForGrSub.RsubGID).FirstOrDefault(); combostdGr.Text = ModelroomForGrSub.stdG; combosubGr.Text = ModelroomForGrSub.stdsubG; comboRoom.Text = ModelroomForGrSub.roomNam; } Removebtn.Enabled = true; } }
//loadTime private void loadTime() { try { using (EFDBEntities1 db = new EFDBEntities1()) { combo_time.DataSource = db.Lectures.ToList(); combo_time.ValueMember = "LecID"; combo_time.DisplayMember = "Time"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void guna2Button2_Click(object sender, EventArgs e) { ModelroomForGrSub.stdG = combostdGr.Text.Trim(); ModelroomForGrSub.stdsubG = combosubGr.Text.Trim(); ModelroomForGrSub.roomNam = comboRoom.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.RoomForGrSubs.Add(ModelroomForGrSub); db.SaveChanges(); } loadData(); clear(); MessageBox.Show("Room Allocate Successfully"); }
private void guna2Button6_Click(object sender, EventArgs e) { modelroomForS.sesstionID = combosession.Text.Trim(); modelroomForS.RoomName = comboroom.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.RoomForSes.Add(modelroomForS); db.SaveChanges(); } loadData(); clear(); MessageBox.Show("Room Allocate Successfully"); }
private void DgvBuilding_DoubleClick(object sender, EventArgs e) { if (DgvBuilding.CurrentRow.Index != -1) { Modelbuil.BuildingID = Convert.ToInt32(DgvBuilding.CurrentRow.Cells["BuildingID"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { Modelbuil = db.Buildings.Where(x => x.BuildingID == Modelbuil.BuildingID).FirstOrDefault(); txtMbuildingName.Text = Modelbuil.BuildingName; txtMnumLect.Text = Modelbuil.Num_of_Lectu; txtMnumFloor.Text = Modelbuil.Num_of_Floors; txtMnumLab.Text = Modelbuil.Num_of_lab; } btnDelete.Enabled = true; } }
private void gridVTag_DoubleClick(object sender, EventArgs e) { if (gridVTag.CurrentRow.Index != -1) { modelTag1.TagID = Convert.ToInt32(gridVTag.CurrentRow.Cells["TagID"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { modelTag1 = db.AddTag11.Where(x => x.TagID == modelTag1.TagID).FirstOrDefault(); txtTagName.Text = modelTag1.TagName; txtTagCode.Text = modelTag1.TagCode; txtRelatedTag.Text = modelTag1.RelatedTag; } btnDeleteTag.Enabled = true; } }
private void guna2Button6_Click(object sender, EventArgs e) { modelconsec.Session1 = combosesse1.Text.Trim(); modelconsec.Session2 = cobosess2.Text.Trim(); modelconsec.RoomName = comboName.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.RoomFConsecSessis.Add(modelconsec); db.SaveChanges(); } loadData(); clear(); MessageBox.Show("Room Allocate Successfully"); }
private void NotAvailableTime_grid_DoubleClick(object sender, EventArgs e) { if (NotAvailableTime_grid.CurrentRow.Index != -1) { notAvailableTimeAlc.SessionID = Convert.ToInt32(NotAvailableTime_grid.CurrentRow.Cells["SessionID"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { notAvailableTimeAlc = db.NotAvTimes.Where(x => x.SessionID == notAvailableTimeAlc.SessionID).FirstOrDefault(); combo_select_Lec.Text = notAvailableTimeAlc.Selected_Lecturer; combo_select_group.Text = notAvailableTimeAlc.Selected_group; combo_select_subgroup.Text = notAvailableTimeAlc.Selected_subgroup; Combo_seect_sessionID.Text = notAvailableTimeAlc.Selected_sessionId; combo_time.Text = notAvailableTimeAlc.Time; } Delete_notAV_time.Enabled = true; } }
private void btnSaveStd_Click(object sender, EventArgs e) { modelAcad.AcademicYrSemester = txtAcaYear.Text.Trim(); modelAcad.Program1 = txtprogramme.Text.Trim(); modelAcad.GroupNumber = txtGroupNum.Value.ToString(); modelAcad.SubGroupNo11 = txtSubGroupNum.Value.ToString(); modelAcad.GroupId11 = txtGroupID.Text.Trim(); modelAcad.SubGroupId11 = txtSubGroupID.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.Academic1.Add(modelAcad); db.SaveChanges(); } clear(); MessageBox.Show("Added Successfully"); }
private void btndelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure to delete this record", "OPtion", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (EFDBEntities1 db = new EFDBEntities1()) { var entry = db.Entry(modelsession); if (entry.State == EntityState.Detached) { db.SessionNs.Attach(modelsession); db.SessionNs.Remove(modelsession); db.SaveChanges(); show_data_GridView(); MessageBox.Show(" Deleted Successfully"); } } } }
private void ManageRoom_Load(object sender, EventArgs e) { loadData(); label3.Text = DateTime.Now.ToLongDateString(); try { using (EFDBEntities1 db = new EFDBEntities1()) { ComboBoxbName.DataSource = db.Buildings.ToList(); ComboBoxbName.ValueMember = "BuildingID"; ComboBoxbName.DisplayMember = "BuildingName"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_save_addlocation_Click(object sender, EventArgs e) { modeladdLocation11.SessionID = combo_sessionID.Text.Trim(); modeladdLocation11.Date = guna2DateTimePicker1.Text.Trim(); modeladdLocation11.StartTime = combo_strtTime.Text.Trim(); modeladdLocation11.EndTime = Combo_endTime.Text.Trim(); modeladdLocation11.RoomID = combo_roomID.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.AddLocation11.Add(modeladdLocation11); db.SaveChanges(); } loadData(); clear(); MessageBox.Show("Location added Successfully"); }
private void guna2DataGridView1_MTS_DoubleClick(object sender, EventArgs e) { if (guna2DataGridView1_MTS.CurrentRow.Index != -1) { model.Lec_id = Convert.ToInt32(guna2DataGridView1_MTS.CurrentRow.Cells["Lec_id"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { model = db.add_time_slot.Where(x => x.Lec_id == model.Lec_id).FirstOrDefault(); combo_batchID.Text = model.Batch_id; combo_start_hrs.Text = model.start_time_hrs; combo_end_hrs.Text = model.end_time_hrs; combo_timeslots.Text = model.time_slot; guna2DateTimePicker1.Text = model.date.ToString(); } ATS_delete.Enabled = true; } }
private void AddLoc_GridView1_DoubleClick(object sender, EventArgs e) { if (AddLoc_GridView1.CurrentRow.Index != -1) { modeladdLocation11.Id = Convert.ToInt32(AddLoc_GridView1.CurrentRow.Cells["Id"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { modeladdLocation11 = db.AddLocation11.Where(x => x.Id == modeladdLocation11.Id).FirstOrDefault(); combo_sessionID.Text = modeladdLocation11.SessionID; guna2DateTimePicker1.Text = modeladdLocation11.Date; combo_strtTime.Text = modeladdLocation11.StartTime; Combo_endTime.Text = modeladdLocation11.EndTime; combo_roomID.Text = modeladdLocation11.RoomID; } btn_delete_addlocation.Enabled = true; } }
private void gridwiew_DoubleClick(object sender, EventArgs e) { if (gridwiew.CurrentRow.Index != -1) { modelsession.SessionId = Convert.ToInt32(gridwiew.CurrentRow.Cells["SessionId"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { modelsession = db.SessionNs.Where(x => x.SessionId == modelsession.SessionId).FirstOrDefault(); txtLect1.Text = modelsession.Lecture1; txtlect2.Text = modelsession.Lecture2; txtTag.Text = modelsession.Tag; txtGroup.Text = modelsession.GroupId; txtSub.Text = modelsession.Subject; txtNoStd.Text = modelsession.NoOfStudents; txtDuratio.Text = modelsession.Duraction; } btndelete.Enabled = true; } }
private void btn_save_notAvTime_Click(object sender, EventArgs e) { notAvailableTimeAlc.Selected_Lecturer = combo_select_Lec.Text.Trim(); //trim is use to remove sapases notAvailableTimeAlc.Selected_group = combo_select_group.Text.Trim(); //trim is use to remove sapases notAvailableTimeAlc.Selected_subgroup = combo_select_subgroup.Text.Trim(); notAvailableTimeAlc.Selected_sessionId = Combo_seect_sessionID.Text.Trim(); notAvailableTimeAlc.Time = combo_time.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.NotAvTimes.Add(notAvailableTimeAlc); db.SaveChanges(); } clear(); MessageBox.Show("Added Successfully"); clear(); loadData(); MessageBox.Show("added Successfully"); }
private void DataGridManagestd_DoubleClick(object sender, EventArgs e) { if (DataGridManagestd.CurrentRow.Index != -1) { modelAca.Studid = Convert.ToInt32(DataGridManagestd.CurrentRow.Cells["StudId"].Value); using (EFDBEntities1 db = new EFDBEntities1()) { modelAca = db.Academic1.Where(x => x.Studid == modelAca.Studid).FirstOrDefault(); txtAcYear.Text = modelAca.AcademicYrSemester; txtProgram.Text = modelAca.Program1; String groupnum = modelAca.GroupNumber; txtGroupNum.Value = Convert.ToInt32(groupnum); String Subgroupnum = modelAca.SubGroupNo11; txtSubGroupNum.Value = Convert.ToInt32(Subgroupnum); txtGruopId.Text = modelAca.GroupId11; txtSubGroupId.Text = modelAca.SubGroupId11; } btnDltMS.Enabled = true; } }
private void update_mangenotAV_time_Click(object sender, EventArgs e) { notAvailableTimeAlc.Selected_Lecturer = combo_select_Lec.Text.Trim();//trim is use to remove sapases notAvailableTimeAlc.Selected_group = combo_select_group.Text.Trim(); notAvailableTimeAlc.Selected_subgroup = combo_select_subgroup.Text.Trim(); notAvailableTimeAlc.Selected_sessionId = Combo_seect_sessionID.Text.Trim(); notAvailableTimeAlc.Time = combo_time.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { if (notAvailableTimeAlc.SessionID == 0) { } else { db.Entry(notAvailableTimeAlc).State = EntityState.Modified; db.SaveChanges(); } } }
private void ATS_save_Click(object sender, EventArgs e) { model.Batch_id = combo_batchID.SelectedItem.ToString(); model.date = guna2DateTimePicker1.Value; model.time_slot = combo_timeslots.SelectedItem.ToString(); model.start_time_hrs = combo_start_hrs.SelectedItem.ToString(); model.end_time_hrs = combo_end_hrs.SelectedItem.ToString(); using (EFDBEntities1 db = new EFDBEntities1()) { db.add_time_slot.Add(model); db.SaveChanges(); } loadData(); MessageBox.Show(" Added Successfully"); }
private void btnSave_Click(object sender, EventArgs e) { modelSession.Lecture1 = cboxLec1.Text.Trim(); modelSession.Lecture2 = cboxLec2.Text.Trim(); modelSession.Tag = cboxTag.Text.Trim(); modelSession.Subject = cboxSubject.Text.Trim(); modelSession.GroupId = cboxGroup.Text.Trim(); modelSession.NoOfStudents = tboxNoofstu.Text.Trim(); modelSession.Duraction = tboxDuration.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.SessionNs.Add(modelSession); db.SaveChanges(); } //clear(); MessageBox.Show("Session Saved Successfully"); }
private void btnUpdateTag_Click(object sender, EventArgs e) { modelTag1.TagName = txtTagName.Text.Trim(); modelTag1.TagCode = txtTagCode.Text.Trim(); modelTag1.RelatedTag = txtRelatedTag.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { if (modelTag1.TagID == 0) { } else { db.Entry(modelTag1).State = EntityState.Modified; db.SaveChanges(); } clear(); show_data_Gridview(); MessageBox.Show("Submitted Successfully"); } }
private void btnRemovee_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure to delete this record", "OPtion", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (EFDBEntities1 db = new EFDBEntities1()) { var entry = db.Entry(modelroomForS); if (entry.State == EntityState.Detached) { db.RoomForSes.Attach(modelroomForS); db.RoomForSes.Remove(modelroomForS); db.SaveChanges(); loadData(); clear(); MessageBox.Show("Room Deleted Successfully"); } } } }
private void Delete_notAV_time_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure to delete this record", "OPtion", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (EFDBEntities1 db = new EFDBEntities1()) { var entry = db.Entry(notAvailableTimeAlc); if (entry.State == EntityState.Detached) { db.NotAvTimes.Attach(notAvailableTimeAlc); db.NotAvTimes.Remove(notAvailableTimeAlc); db.SaveChanges(); loadData(); clear(); MessageBox.Show("Location Deleted Successfully"); } } } }
private void loadsesstion() { try { using (EFDBEntities1 db = new EFDBEntities1()) { combosesse1.DataSource = db.SessionNs.ToList(); combosesse1.ValueMember = "SessionId"; combosesse1.DisplayMember = "SessionId"; cobosess2.DataSource = db.SessionNs.ToList(); cobosess2.ValueMember = "SessionId"; cobosess2.DisplayMember = "SessionId"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_save_Click(object sender, EventArgs e) { if (txtbuilding_name.Text == "" || txtnum_floors.Text == "" || txt_num_lecture.Text == "" || txt_num_lab.Text == "") { MessageBox.Show("Fill all details"); } else { modelbuil.BuildingName = txtbuilding_name.Text.Trim();//trim is use to remove sapases modelbuil.Num_of_Floors = txtnum_floors.Text.Trim(); modelbuil.Num_of_Lectu = txt_num_lecture.Text.Trim(); modelbuil.Num_of_lab = txt_num_lab.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.Buildings.Add(modelbuil); db.SaveChanges(); } clear(); MessageBox.Show("Building Added Successfully"); } }
private void btn_save_Click(object sender, EventArgs e) { modelsub.Year = comboBoxyear.Text.Trim(); modelsub.Semester = semesterReadio; modelsub.Subject_Name = textSubName.Text.Trim(); modelsub.Subject_Code = textcode.Text.Trim(); modelsub.Lecture_Hours = numericUpDown1.Value.ToString(); modelsub.Tute_Hours = numericUpDown2.Value.ToString(); modelsub.Lab_Hours = numericUpDown3.Value.ToString(); modelsub.Evaluation_Hours = numericUpDown4.Value.ToString(); using (EFDBEntities1 db = new EFDBEntities1()) { db.Subject1.Add(modelsub); db.SaveChanges(); } clear(); MessageBox.Show(" Added Successfully"); LoadData(); }
private void btnUpdate_Click(object sender, EventArgs e) { Modelbuil.BuildingName = txtMbuildingName.Text.Trim();//trim is use to remove sapases Modelbuil.Num_of_Floors = txtMnumFloor.Text.Trim(); Modelbuil.Num_of_Lectu = txtMnumLect.Text.Trim(); Modelbuil.Num_of_lab = txtMnumLab.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { if (Modelbuil.BuildingID == 0) { } else { db.Entry(Modelbuil).State = EntityState.Modified; db.SaveChanges(); } clear(); show_data_GridView(); MessageBox.Show("Building Updated Successfully"); } }
private void btnRoomSave_Click(object sender, EventArgs e) { if (comboBuilding.Text == "" && txtRoomname.Text == "" || txtcapasity.Text == "") { MessageBox.Show("Fill all details"); } else { modelRoom.BuildingName = comboBuilding.Text.Trim(); modelRoom.RoomName = txtRoomname.Text.Trim(); modelRoom.RoomType = Roomtype; modelRoom.Capacity = txtcapasity.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.Rooms.Add(modelRoom); db.SaveChanges(); } clear(); MessageBox.Show("Room Added Successfully"); } }