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