public void LoadGrid()
{
//Cbo Load Session
var session = db.tblSessions.ToList();
tblSession tbl = new tblSession();
tbl.SessionName = "Choose Session";
session.Insert(0, tbl);
cboSessionId.DataSource = session;
cboSessionId.DisplayMember = "SessionName";
cboSessionId.ValueMember = "SessionId";
cboSessionId.SelectedIndex = 0;
//Cbo Load Faculty
var faculty = db.tblFaculties.ToList();
tblFaculty tbf = new tblFaculty();
tbf.FacultyDescription = "Choose Faculty";
faculty.Insert(0, tbf);
cboFacultyId.DataSource = faculty;
cboFacultyId.DisplayMember = "FacultyDescription";
cboFacultyId.ValueMember = "FacultyId";
cboFacultyId.SelectedIndex = 0;
//Selecting List of User & Displaying in Datagrid view
dataGridView1.DataSource = db.tblStudents.Select(x => new { StudentId = x.StudentId, StudentName = x.StudentName, Address = x.Address, ContactNumber = x.Contact, SessionName = x.tblSession.SessionName, Faculty = x.tblFaculty.FacultyDescription }).ToList();
}
public ActionResult DeleteConfirmed(string id)
{
tblFaculty tblFaculty = db.tblFaculties.Find(id);
// Instead of actually deleting, we set Active to false.
tblFaculty.FacultyActive = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void btnSave_Click(object sender, EventArgs e)
{
tblFaculty tb = new tblFaculty();
tb.FacultyDescription = txtFacultyDescription.Text;
db.tblFaculties.Add(tb);
if (db.SaveChanges() > 0)
{
MessageBox.Show("Faculty Added");
LoadGrid();
ClearData();
}
}
public ActionResult Edit([Bind(Include = "FacultyID,FacultyEmail,FacultySpecification,FacultyName,FacultyGender,FacultyJoiningDate")] tblFaculty tblFaculty)
{
if (ModelState.IsValid)
{
tblFaculty.FacultyActive = true;
db.Entry(tblFaculty).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FacultyID = new SelectList(db.tblUsers, "UserID", "UserName", tblFaculty.FacultyID);
return(View(tblFaculty));
}
// GET: Faculties/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblFaculty tblFaculty = db.tblFaculties.Find(id);
if (tblFaculty == null)
{
return(HttpNotFound());
}
return(View(tblFaculty));
}
// GET: Faculties/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblFaculty tblFaculty = db.tblFaculties.Find(id);
if (tblFaculty == null)
{
return(HttpNotFound());
}
ViewBag.FacultyID = new SelectList(db.tblUsers, "UserID", "UserName", tblFaculty.FacultyID);
return(View(tblFaculty));
}
public HttpResponseMessage Put([Bind(Include = "Faculty_Name,Model")] FacultyViewModel fvm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
var faculty = facDB.ListAll().Find(f => f.Id.Equals(fvm.Id));
string message = "Faculty Updated Successfully";
tblFaculty tb = db.tblFaculties.Where(s => s.Faculty_Id == fvm.Id).FirstOrDefault();
bool isexists = facDB.CheckFacultyNameExist(fvm.Faculty_Name);
if (isexists)
{
if (tb.Faculty_Name == fvm.Faculty_Name)
{
if (ModelState.IsValid)
{
facDB.Update(fvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
else
{
ModelState.AddModelError("Faculty_Name", "Faculty Name Already Exist");
}
}
if (ModelState.IsValid)
{
facDB.Update(fvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public ActionResult Create([Bind(Include = "FacultyName,FacultyEmail,FacultySpecification,FacultyGender")] tblFaculty tblFaculty)
{
if (ModelState.IsValid)
{
// Setting Active to true, because it is a new field.
tblFaculty.FacultyActive = true;
// Creating an ID for Faculty based on total records + 1.
int count = db.tblFaculties.Count(); count++;
tblFaculty.FacultyID = "faculty" + count; // Setting the Faculty ID
// Joining date set to current date.
tblFaculty.FacultyJoiningDate = DateTime.Today.Date.ToShortDateString();
db.tblFaculties.Add(tblFaculty);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FacultyID = new SelectList(db.tblUsers, "UserID", "UserName", tblFaculty.FacultyID);
return(View(tblFaculty));
}
