// GET: Building/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_Building tb_Building = db.tb_Building.Find(id);
if (tb_Building == null)
{
return(HttpNotFound());
}
var isPresent = db.tb_SemesterTaught.Any(b => b.BuildingID == id);
if (isPresent)
{
ModelState.AddModelError("User Name Error", "This building can not be deleted from database because is presents in the current table of semester");
}
if (!ModelState.IsValid)
{
Error error = new Error();
List <string> errs = new List <string>();
foreach (var state in ModelState)
{
foreach (var err in state.Value.Errors)
{
error.errMsg += " " + err.ErrorMessage;
}
}
errs.Add("Warnings!" + error.errMsg);
ViewData["ErrorList"] = errs;
}
return(View(tb_Building));
}
public ActionResult DeleteConfirmed(int id)
{
var isPresent = db.tb_SemesterTaught.Any(b => b.BuildingID == id);
if (!isPresent)
{
tb_Building tb_Building = db.tb_Building.Find(id);
db.tb_Building.Remove(tb_Building);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: Building/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_Building tb_Building = db.tb_Building.Find(id);
if (tb_Building == null)
{
return(HttpNotFound());
}
ViewBag.CampusID = new SelectList(db.tb_Campus.OrderBy(c => c.CollegeCode).ThenBy(c => c.CampusName), "CampusID", "CampusName", tb_Building.CampusID);
return(View(tb_Building));
}
public ActionResult Edit([Bind(Include = "BuildingID,BuildingName,CampusID,ImagePath")] tb_Building model, HttpPostedFileBase file)
{
ViewBag.CampusID = new SelectList(db.tb_Campus, "CampusID", "CampusName", model.CampusID);
bool isFileSelected = false;
if (file != null && file.ContentLength > 0)
{
try
{
var extension = file.FileName.Split('.').Last().ToUpper();
if (extension != "PDF" && extension != "JPG")
{
ViewBag.Message = "Selected file type is not PDF or JPEG";
return(View(model));
}
string path = Path.Combine(Server.MapPath(MvcApplication.BuildingsFolder), file.FileName);
file.SaveAs(path);
ViewBag.Message = "File uploaded successfully";
isFileSelected = true;
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
return(View(model));
}
}
//else
//{
// ViewBag.Message = "You have not specified a file";
// return View(model);
//}
if (ModelState.IsValid)
{
if (isFileSelected)
{
model.ImagePath = file.FileName;
}
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult AddBuilding(HttpPostedFileBase file, [Bind(Include = "_CollegeID,_CampusID,_BuildingName")] AddBuildingModel model)
{
Error error = new Error();
error.errCode = ErrorDetail.Success;
error.errMsg = ErrorDetail.GetMsg(error.errCode);
List <string> errs = new List <string>();
model._Colleges = new List <SelectListItem>
{
new SelectListItem()
{
Value = "0", Text = "-- Select One --"
}
}.Concat(db.tb_College.Select(x => new SelectListItem
{
Value = x.CollegeID.ToString(), Text = x.CollegeName
}));
model._Campuses = new SelectList(db.tb_Campus.OrderBy(s => s.CampusName), "CampusID", "CampusName", model._CampusID);
model._tb_College = db.tb_College;
if (file != null && file.ContentLength > 0)
{
try
{
var extension = file.FileName.Split('.').Last().ToUpper();
if (extension != "PDF" && extension != "JPG")
{
ViewBag.Message = "Selected file type is not PDF or JPEG";
return(View(model));
}
string path = Path.Combine(Server.MapPath(MvcApplication.BuildingsFolder), file.FileName);
file.SaveAs(path);
ViewBag.Message = "File uploaded successfully";
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
else
{
ViewBag.Message = "You have not specified a file.";
return(View(model));
}
var buildings = db.tb_Building.Where(s => s.BuildingName.ToUpper() == model._BuildingName.ToUpper());
//Check dublicates
if (buildings.ToList().Count == 0)
{
tb_Building building = new tb_Building()
{
CampusID = model._CampusID,
BuildingName = model._BuildingName,
ImagePath = file.FileName
};
db.tb_Building.Add(building);
}
else
{
tb_Building building = buildings.FirstOrDefault();
building.CampusID = model._CampusID;
building.BuildingName = model._BuildingName;
building.ImagePath = file.FileName;
db.tb_Building.Attach(building);
}
try
{
db.SaveChanges();
model._tb_College = db.tb_College;
}
catch (Exception ex)
{
error.errCode = ErrorDetail.DataImportError;
error.errMsg = ErrorDetail.GetMsg(error.errCode);
errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg + ". " + ex.Message);
ViewData["ErrorList"] = errs;
return(View(model));
}
model._tb_College = db.tb_College;
return(View(model));
}
