private void btnUpdateR_Click(object sender, EventArgs e) { modelLect.LectureName = tboxName.Text.Trim(); modelLect.EmpID = tboxID.Text.Trim(); modelLect.Faculty = cboxFaculty.Text.Trim(); modelLect.Department = cboxDepart.Text.Trim(); modelLect.Center = cboxCenter.Text.Trim(); modelLect.Building = cboxBuilding.Text.Trim(); modelLect.Level = cboxLevel.Text.Trim(); modelLect.Rank = tboxrank.Text.Trim(); modelLect.Day = cboxDate.Text.Trim(); modelLect.Time = tboxATime.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { if (modelLect.LecID == 0) { } else { db.Entry(modelLect).State = EntityState.Modified; db.SaveChanges(); } clear(); loadData(); MessageBox.Show("Lecture Updated Successfully"); } }
private void btnUpdate_Click(object sender, EventArgs e) { modelsession.Lecture1 = txtLect1.Text.Trim(); modelsession.Lecture2 = txtlect2.Text.Trim(); modelsession.Tag = txtTag.Text.Trim(); modelsession.Subject = txtSub.Text.Trim(); modelsession.GroupId = txtGroup.Text.Trim(); modelsession.NoOfStudents = txtNoStd.Text.Trim(); modelsession.Duraction = txtDuratio.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { if (modelsession.SessionId == 0) { } else { db.Entry(modelsession).State = EntityState.Modified; db.SaveChanges(); } show_data_GridView(); MessageBox.Show(" Updated Successfully"); } }
private void btnUpdateR_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()) { if (modelsub.SID == 0) { } else { db.Entry(modelsub).State = EntityState.Modified; db.SaveChanges(); } clear(); LoadData(); MessageBox.Show("Lecture Updated Successfully"); } }
private void btn_save_Click(object sender, EventArgs e) { modelLect.LectureName = tboxName.Text.Trim(); modelLect.EmpID = tboxID.Text.Trim(); modelLect.Faculty = cboxFaculty.Text.Trim(); modelLect.Department = cboxDepart.Text.Trim(); modelLect.Center = cboxCenter.Text.Trim(); modelLect.Building = cboxBuilding.Text.Trim(); modelLect.Level = cboxLevel.Text.Trim(); modelLect.Rank = tboxrank.Text.Trim(); modelLect.Day = cboxDate.Text.Trim(); modelLect.Time = tboxATime.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.Lectures.Add(modelLect); db.SaveChanges(); } clear(); MessageBox.Show("Lecture Added Successfully"); loadData(); }
private void btnUpdateMS_Click(object sender, EventArgs e) { modelAca.AcademicYrSemester = txtAcYear.Text.Trim(); modelAca.Program1 = txtProgram.Text.Trim(); modelAca.GroupNumber = txtGroupNum.Value.ToString(); modelAca.SubGroupNo11 = txtSubGroupNum.Value.ToString(); modelAca.GroupId11 = txtGruopId.Text.Trim(); modelAca.SubGroupId11 = txtSubGroupId.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { if (modelAca.Studid == 0) { } else { db.Entry(modelAca).State = EntityState.Modified; db.SaveChanges(); } clear(); Sho_data_gridView(); MessageBox.Show(" Updated Successfully"); } }
private void btnUpdateR_Click(object sender, EventArgs e) { //trim is use to remove sapases modelRoom.BuildingName = ComboBoxbName.Text.Trim(); modelRoom.RoomName = txtRoomName.Text.Trim(); modelRoom.RoomType = RoomtypeM; modelRoom.Capacity = txtCapacity.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { if (modelRoom.RoomID == 0) { } else { db.Entry(modelRoom).State = EntityState.Modified; db.SaveChanges(); } clear(); loadData(); MessageBox.Show("Room Updated Successfully"); } }
private void ATS_update_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()) { if (model.Lec_id == 0) { } else { db.Entry(model).State = EntityState.Modified; db.SaveChanges(); } clear(); loadData(); MessageBox.Show("Room Updated Successfully"); } }
private void btn_Update_addlocation_Click(object sender, EventArgs e) { modeladdLocation11.SessionID = combo_sessionID.Text.Trim();//trim is use to remove sapases 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()) { if (modeladdLocation11.Id == 0) { } else { db.Entry(modeladdLocation11).State = EntityState.Modified; db.SaveChanges(); } clear(); loadData(); MessageBox.Show("Location Updated Successfully"); } }
private void btnParSession_Click(object sender, EventArgs e) { int total = gridParellel.Rows.Cast <DataGridViewRow>().Where(p => Convert.ToBoolean(p.Cells["selected11"].Value) == true).Count(); if (total > 0) { string message = $"Are you sure want the add {total} row?"; if (total > 1) { message = $"Are you sure want the add {total} row?"; } if (MessageBox.Show(message, "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { for (int i = gridParellel.RowCount - 1; i >= 0; i--) { DataGridViewRow row = gridParellel.Rows[i]; if (Convert.ToBoolean(row.Cells["selected11"].Value) == true) { SessioId = row.Cells[0].Value.ToString(); Lect1 = row.Cells[1].Value.ToString(); Lect2 = row.Cells[2].Value.ToString(); Subj = row.Cells[3].Value.ToString(); SubtCode = row.Cells[4].Value.ToString(); tag = row.Cells[5].Value.ToString(); GroId = row.Cells[6].Value.ToString(); modelpara.SessionId = SessioId; modelpara.Lecture1 = Lect1; modelpara.Lecture2 = Lect2; modelpara.Subject = Subj; modelpara.SubjectCode = SubtCode; modelpara.Tag = tag; modelpara.GroupId = GroId; using (EFDBEntities1 db = new EFDBEntities1()) { db.parellelTables.Add(modelpara); db.SaveChanges(); } clear(); MessageBox.Show("Sessionid Added Successfully"); } } } } }
private void btnAllocate_Click(object sender, EventArgs e) { modelSFsub.subR = comboLoadSub.Text.Trim(); modelSFsub.roomR = comboLoadRoom.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.SubForRooms.Add(modelSFsub); db.SaveChanges(); } loadData(); clear(); MessageBox.Show("Room Allocate Successfully"); }
private void btnAllocate_Click(object sender, EventArgs e) { modelroomForLec.lecturName = comboLectName.Text.Trim(); modelroomForLec.RoomName = comboRoomname.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.RoomForLrctus.Add(modelroomForLec); db.SaveChanges(); } loadData(); clear(); MessageBox.Show("Room Allocate Successfully"); }
private void btnSaveAddtag_Click(object sender, EventArgs e) { addTagmodel.TagName = txtTagName.Text.Trim(); addTagmodel.TagCode = txtTagCode.Text.Trim(); addTagmodel.RelatedTag = txtRelatedTag.Text.Trim(); //remove the spaces (Trim function) using (EFDBEntities1 db = new EFDBEntities1()) { db.AddTag11.Add(addTagmodel); db.SaveChanges(); } Clear(); MessageBox.Show("Submitted Successfully"); }
private void btnAllocate_Click(object sender, EventArgs e) { modelRoomForTag.tagName = comboTag.Text.Trim(); modelRoomForTag.RoomName = comboRoom.Text.Trim(); using (EFDBEntities1 db = new EFDBEntities1()) { db.RoomForTags.Add(modelRoomForTag); db.SaveChanges(); } loadData(); clear(); MessageBox.Show("Room Allocate Successfully"); }
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 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 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 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 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 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 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 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 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 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 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 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 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"); } }