//create vessel public int createVesselDB(vessel_owner_ref vessel_owner_ref) { int vessel_id = 0; try { vessel getVesselObject = db.vessels.Where(v => v.registration_id == vessel_owner_ref.vessel.registration_id && v.vessel_no.Equals(vessel_owner_ref.vessel.vessel_no) && v.district_id == vessel_owner_ref.vessel.district_id && v.vessel_status == 1).FirstOrDefault(); //Vessel is not exist if (getVesselObject == null) { db.vessel_owner_ref.Add(vessel_owner_ref); //Save vessel and owner db.SaveChanges(); vessel getAboveVesselObject = db.vessels.Where(v => v.registration_id == vessel_owner_ref.vessel.registration_id && v.vessel_no.Equals(vessel_owner_ref.vessel.vessel_no) && v.district_id == vessel_owner_ref.vessel.district_id && v.vessel_status == 1).FirstOrDefault(); vessel_id = getAboveVesselObject.vessel_id; //return vessel id after the inserted } //Vessel is exist else { vessel_id = getVesselObject.vessel_id; //return vessel id that already created } } catch (Exception) { throw; } return(vessel_id); }
public ActionResult DeleteConfirmed(int id) { vessel vessel = db.vessels.Find(id); db.vessels.Remove(vessel); db.SaveChanges(); return(RedirectToAction("VesselList")); }
public ActionResult EditVessel([Bind(Include = "vesselID,VesselRegNo,ownerID,availWeight,availVolume,vesselName,enteredDate,enteredUser")] vessel vessel) { if (ModelState.IsValid) { db.Entry(vessel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("VesselList")); } ViewBag.ownerID = new SelectList(db.users, "userID", "username", vessel.ownerID); return(View(vessel)); }
//update method public int updateVessel(int id, vessel vessel) { try { vessel.vessel_last_modified_date = DateTime.Now; vessel.vessel_last_modified_by = HttpContext.Current.User.Identity.Name; return(VesselsService.updateVesselDB(id, vessel)); } catch (Exception) { throw; } }
// GET: vessels/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } vessel vessel = db.vessels.Find(id); if (vessel == null) { return(HttpNotFound()); } return(View(vessel)); }
public ActionResult AddVessel([Bind(Include = "vesselID,VesselRegNo,ownerID,availWeight,availVolume,vesselName,enteredDate,enteredUser")] vessel vessel) { if (ModelState.IsValid) { vessel.enteredUser = 1; vessel.enteredDate = DateTime.Now; db.vessels.Add(vessel); db.SaveChanges(); return(RedirectToAction("VesselList")); } ViewBag.ownerID = new SelectList(db.users, "userID", "username", vessel.ownerID); return(View(vessel)); }
// GET: vessels/Edit/5 public ActionResult EditVessel(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } vessel vessel = db.vessels.Find(id); if (vessel == null) { return(HttpNotFound()); } ViewBag.ownerID = new SelectList(db.users, "userID", "username", vessel.ownerID); return(View(vessel)); }
//update method public int updateVesselDB(int id, vessel vessel) { int flag = 0; try { var result = db.vessels.Where(v => v.vessel_id == id).FirstOrDefault(); if (result != null) { db.Entry(result).State = EntityState.Detached; db.Entry(vessel).State = EntityState.Modified; db.SaveChanges(); flag = 1; } } catch (Exception) { throw; } return(flag); }
//get Vessel Id For Renewal public licence getVesselIdForRenewalDB(string SearchText) { licence licence = new licence(); try { vessel Vessel = db.vessels.Where(v => v.vessel_status == 1 && v.registration.registration_code.Equals("IMUL-A-") && v.vessel_no.Contains(SearchText.Substring(7, 4)) && v.district.district_code.Contains(SearchText.Substring(11, 3))).FirstOrDefault(); //get the vessel object according to the searchText and that vessel_id will set to a new licence's vessel_id if (Vessel != null) { if (Vessel.vessel_id != 0) { licence.vessel_id = Vessel.vessel_id; //return vessel_id fixed licence object to the view } } } catch (Exception) { throw; } return(licence); }
public ActionResult Edit(int id, vessel vessel) { try { if (ModelState.IsValid) { int status = VesselsControllerManager.updateVessel(id, vessel); if (status == 1) { return(RedirectToAction("Index")); } } ViewBag.Registration = VesselsControllerManager.getRegistrationSelectList(); ViewBag.Districts = VesselsControllerManager.getDistrictsSelectList(); ViewBag.Applications = VesselsControllerManager.getApplicationSelectList(); return(View()); } catch (Exception ex) { return(RedirectToAction("Error", "Home", new { error = "POST/Vessels/Edit/int" })); } }
public Brewery() { HLT = new vessel(Vessels.HLT); MLT = new vessel(Vessels.MLT); BK = new vessel(Vessels.BK); Pump1 = new pump(); Pump2 = new pump(); }