public ActionResult Edit([Bind(Include = "id,Supervisors,Lecturers")] AllocatedLecturers allocatedLecturers)
{
int table_rows = db.AllocatedLecturers.Count(ac => ac.Supervisors.Equals(allocatedLecturers.Supervisors));
int t = db.Modules.Max(ac => ac.MaxCount);
if (db.AllocatedLecturers.Any(ac => ac.Supervisors.Equals(allocatedLecturers.Supervisors)) &&
db.AllocatedLecturers.Any(acd => acd.Lecturers.Equals(allocatedLecturers.Lecturers)))
{
TempData["exists"] = "exists";
return(RedirectToAction("Edit", "Groups1"));
}
if (t <= table_rows)
{
TempData["max"] = "max";
return(RedirectToAction("fuc", "Groups1"));
}
if (ModelState.IsValid)
{
db.Entry(allocatedLecturers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(allocatedLecturers));
}
public ActionResult Create([Bind(Include = "Supervisors,Lecturers")] AllocatedLecturers allocatedLecturers)
{
var vari = allocatedLecturers.Supervisors;
if (db.AllocatedLecturers.Any(ac => ac.Lecturers.Equals(allocatedLecturers.Lecturers)) && db.AllocatedLecturers.Any(acs => acs.Supervisors.Equals(allocatedLecturers.Supervisors)))
{
ModelState.AddModelError("Already exists", "Error");
return(RedirectToAction("Edit", "Groups1"));
}
if (ModelState.IsValid)
{
db.AllocatedLecturers.Add(allocatedLecturers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Supervisor = new SelectList(db.AllocatedLecturers, "GroupID", "Supervisor", allocatedLecturers.Supervisors);
ViewBag.Lecturers = new SelectList(db.AllocatedLecturers, "Lecturers", "Lecturers", allocatedLecturers.Lecturers);
return(View(allocatedLecturers));
}
public ActionResult DeleteConfirmed(int id)
{
AllocatedLecturers allocatedLecturers = db.AllocatedLecturers.Find(id);
db.AllocatedLecturers.Remove(allocatedLecturers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,Supervisors,Lecturers")] AllocatedLecturers allocatedLecturers)
{
if (ModelState.IsValid)
{
db.Entry(allocatedLecturers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(allocatedLecturers));
}
/// <summary>
/// Display the details of the Allocated Supervisors for each Groups
/// </summary>
/// <param name="id">Selected Group ID</param>
/// <returns>Allocated Lectrue Module</returns>
// GET: AllocatedLecturers/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AllocatedLecturers allocatedLecturers = db.AllocatedLecturers.Find(id);
if (allocatedLecturers == null)
{
return(HttpNotFound());
}
return(View(allocatedLecturers));
}
/// <summary>
/// Share the allocatedLecturers moudle that find by selected id
/// </summary>
/// <param name="id">Selected id</param>
/// <returns>Saving Supervisors for allocated lecturers</returns>
// GET: AllocatedLecturers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AllocatedLecturers allocatedLecturers = db.AllocatedLecturers.Find(id);
if (allocatedLecturers == null)
{
return(HttpNotFound());
}
ViewBag.Supervisors = new SelectList(db.Groups, "Supervisor", "Supervisor");
ViewBag.Lecturers = new SelectList(db.Lecturers, "Name", "Name");
return(View(allocatedLecturers));
}
public ActionResult Create([Bind(Include = "Supervisors,Lecturers")] AllocatedLecturers allocatedLecturers)
{
var vari = allocatedLecturers.Supervisors;
int table_rows = db.AllocatedLecturers.Count(ac => ac.Supervisors.Equals(allocatedLecturers.Supervisors));
int MaxAllocatedLecturers = db.Modules.Max(ac => ac.MaxCount);
if (MaxAllocatedLecturers <= table_rows)
{
TempData["max"] = "max";
return(RedirectToAction("fuc", "Groups1"));
}
if (db.AllocatedLecturers.Any(ac => ac.Lecturers.Equals(allocatedLecturers.Lecturers)) &&
db.AllocatedLecturers.Any(acs => acs.Supervisors.Equals(allocatedLecturers.Supervisors)))
{
TempData["exists"] = "exists";
return(RedirectToAction("Edit", "Groups1"));
}
else if (ModelState.IsValid)
{
string time = DateTime.Now.ToString("HH:mm:ss tt");
string query = "insert into dbo.Requests(Name,Request,Status,Loaded) values(@a1,@a2,@a3,@a4)";
List <object> parameterList = new List <object>();
parameterList.Add(new SqlParameter("@a1", allocatedLecturers.Lecturers));
parameterList.Add(new SqlParameter("@a2", Session["UserName"] + "Requests for a allocating on a Lecture panelCUT" + Session["Avatar"] + "CUT" + time + "CUT" + allocatedLecturers.id + "CUTAllocateLecturers"));
parameterList.Add(new SqlParameter("@a3", 2));
parameterList.Add(new SqlParameter("@a4", 2));
object[] parameters123 = parameterList.ToArray();
int rs = db.Database.ExecuteSqlCommand(query, parameters123);
db.AllocatedLecturers.Add(allocatedLecturers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(allocatedLecturers));
}
}
