public ActionResult AddOrEdit(Complain emp)
{
try
{
using (InfraDbEntities db = new InfraDbEntities())
{
if (emp.Id == 0)
{
db.Complains.Add(emp);
db.SaveChanges();
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
}
ViewBag.RoomId = new SelectList(db.Classrooms, "CId", "CRoomNo", emp.RoomId);
ViewBag.InfrustructureId = new SelectList(db.Infrustructures, "IId", "ITypes", emp.InfrustructureId);
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllComplain()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
IEnumerable <Complain> GetAllComplain()
{
using (InfraDbEntities db = new InfraDbEntities())
{
return(db.Complains.Include(c => c.Classroom).Include(c => c.Infrustructure).ToList <Complain>());
}
}
IEnumerable <Classroom> GetAllClassroom()
{
using (InfraDbEntities db = new InfraDbEntities())
{
return(db.Classrooms.ToList <Classroom>());
}
}
IEnumerable <Infrustructure> GetAllInfrustructure()
{
using (InfraDbEntities db = new InfraDbEntities())
{
return(db.Infrustructures.ToList <Infrustructure>());
}
}
public ActionResult AddOrEdit(int id = 0)
{
Classroom emp = new Classroom();
if (id != 0)
{
using (InfraDbEntities db = new InfraDbEntities())
{
emp = db.Classrooms.Where(x => x.CId == id).FirstOrDefault <Classroom>();
}
}
return(View(emp));
}
public ActionResult AddOrEdit(int id = 0)
{
Infrustructure emp = new Infrustructure();
if (id != 0)
{
using (InfraDbEntities db = new InfraDbEntities())
{
emp = db.Infrustructures.Where(x => x.IId == id).FirstOrDefault <Infrustructure>();
}
}
return(View(emp));
}
public ActionResult Delete(int id)
{
try
{
using (InfraDbEntities db = new InfraDbEntities())
{
Complain emp = db.Complains.Where(x => x.Id == id).FirstOrDefault <Complain>();
db.Complains.Remove(emp);
db.SaveChanges();
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllComplain()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(int id = 0)
{
Complain emp = new Complain();
Infrustructure infra = new Infrustructure();
Classroom croom = new Classroom();
ViewBag.infraId = infra.IId;
ViewBag.infraType = infra.ITypes;
if (id != 0)
{
using (InfraDbEntities db = new InfraDbEntities())
{
emp = db.Complains.Where(x => x.Id == id).FirstOrDefault <Complain>();
}
}
ViewBag.RoomId = new SelectList(db.Classrooms, "CId", "CRoomNo", emp.RoomId);
ViewBag.InfrustructureId = new SelectList(db.Infrustructures, "IId", "ITypes", emp.InfrustructureId);
return(View(emp));
}
public ActionResult AddOrEdit(Classroom croom)
{
try
{
using (InfraDbEntities db = new InfraDbEntities())
{
if (croom.CId == 0)
{
db.Classrooms.Add(croom);
db.SaveChanges();
}
else
{
db.Entry(croom).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllClassroom()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
