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