//get PDF method
public List <vessel_owner_ref> getPDFVesselListDB(string vesselList)
{
vessel_owner_ref vessel_owner_ref = null;
List <vessel_owner_ref> VesselList = new List <vessel_owner_ref>();
try
{
if (!string.IsNullOrEmpty(vesselList))
{
List <string> vessels = vesselList.Split(',').ToList <string>();
foreach (string item in vessels)
{
if (item.Length == 14)
{
vessel_owner_ref = db.vessel_owner_ref.Where(v => v.vessel.registration.registration_code.Equals("IMUL-A-") && v.vessel.vessel_no.Equals(item.Substring(7, 4)) &&
v.vessel.district.district_code.Equals(item.Substring(11, 3).ToUpper())).FirstOrDefault();
if (vessel_owner_ref != null)
{
VesselList.Add(vessel_owner_ref);
}
}
}
VesselList.Sort((x, y) => x.vessel.vessel_pending_approval.CompareTo(y.vessel.vessel_pending_approval));
}
}
catch (Exception)
{
throw;
}
return(VesselList);
}
public ActionResult MultipleVessels(vessel_owner_ref vessel_owner_ref)
{
try
{
if (ModelState.IsValid)
{
int status = OwnersControllerManager.saveMultipleVessel(vessel_owner_ref);
if (status == 1)
{
return(RedirectToAction("Index"));
}
else
{
TempData["vessel_no"] = "This Vessel is already assign for this owner";
ViewBag.Registration = OwnersControllerManager.getRegistrationSelectList();
ViewBag.Districts = OwnersControllerManager.getDistrictsSelectList();
ViewBag.Applications = OwnersControllerManager.getApplicationSelectList();
}
}
return(View());
}
catch (Exception)
{
return(RedirectToAction("Error", "Home", new { error = "POST/Owners/MultipleVessels" }));
}
}
//GET: DistressReport/CreateVessel
public ActionResult CreateVessel(string SearchText)
{
vessel_owner_ref vessel_owner_ref = null;
try
{
ViewBag.Registration = DistressReportControllerManager.getRegistrationSelectList();
ViewBag.Districts = DistressReportControllerManager.getDistrictsSelectList();
ViewBag.Applications = DistressReportControllerManager.getApplicationSelectList();
if (SearchText != null && SearchText.Length != 0)
{
vessel_owner_ref = DistressReportControllerManager.getVessel(SearchText);
if (vessel_owner_ref != null)
{
TempData["vessel_id_found"] = "Vessel Found!";
TempData["note"] = "Note : In case of distinct Owner data or update data please contact Colombo MCS Center, you cannot update below data";
}
else
{
TempData["vessel_id_not_found"] = "Vessel Not Found Please Enter Data To Submit!";
}
}
return(View(vessel_owner_ref));
}
catch (Exception)
{
return(RedirectToAction("Error", "Home", new { error = "GET/DistressReport/CreateVessel" }));
}
}
//insert Multiple Vessel
public int saveMultipleVesselDB(vessel_owner_ref vessel_owner_ref)
{
int flag = 0;
try
{
var result = db.vessel_owner_ref.Where(o => o.owner_id == vessel_owner_ref.owner_id && o.owner.owner_status == 1).FirstOrDefault();
if (result != null)
{
var resultForUniqueVessel = db.vessel_owner_ref.Where(v => v.vessel.registration_id == vessel_owner_ref.vessel.registration_id &&
v.vessel.vessel_no.Equals(vessel_owner_ref.vessel.vessel_no) && v.vessel.district_id == vessel_owner_ref.vessel.district_id && v.vessel.vessel_status == 1 && v.owner_id == vessel_owner_ref.owner_id).FirstOrDefault();
if (resultForUniqueVessel == null)
{
db.vessel_owner_ref.Add(vessel_owner_ref);
db.SaveChanges();
flag = 1;
}
}
}
catch (Exception)
{
throw;
}
return(flag);
}
//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);
}
//get Vessel
public vessel_owner_ref getVesselDB(string SearchText)
{
vessel_owner_ref vesselOwner = null;
try
{
vesselOwner = db.vessel_owner_ref.Where(v => v.vessel.vessel_status == 1 && v.vessel.registration.registration_code.Equals(SearchText.Substring(0, 7)) &&
v.vessel.vessel_no.Contains(SearchText.Substring(7, 4)) && v.vessel.district.district_code.Contains(SearchText.Substring(11, 3))).FirstOrDefault();
}
catch (Exception)
{
throw;
}
return(vesselOwner);
}
//insert Multiple Vessel
public int saveMultipleVessel(vessel_owner_ref vessel_owner_ref)
{
try
{
vessel_owner_ref.vessel.vessel_created_date = DateTime.Now;
vessel_owner_ref.vessel.vessel_created_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.vessel.vessel_last_modified_date = DateTime.Now;
vessel_owner_ref.vessel.vessel_last_modified_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.vessel.vessel_status = 1;
return(OwnersService.saveMultipleVesselDB(vessel_owner_ref));
}
catch (Exception)
{
throw;
}
}
//delete method
public int deleteVessel(int id)
{
try
{
vessel_owner_ref vessel_owner_ref = VesselsService.getVesselDB(id); //get the existing vessel_owner_ref object to modify its status
vessel_owner_ref.vessel.vessel_last_modified_date = DateTime.Now;
vessel_owner_ref.vessel.vessel_last_modified_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.vessel.vessel_status = 0;
return(VesselsService.deleteVesselDB(id, vessel_owner_ref));
}
catch (Exception)
{
throw;
}
}
//insert Shared Ownership
public int saveSharedOwnership(vessel_owner_ref vessel_owner_ref)
{
try
{
vessel_owner_ref.owner.owner_created_date = DateTime.Now;
vessel_owner_ref.owner.owner_created_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.owner.owner_last_modified_date = DateTime.Now;
vessel_owner_ref.owner.owner_last_modified_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.owner.owner_status = 1;
return(VesselsService.saveSharedOwnershipDB(vessel_owner_ref));
}
catch (Exception)
{
throw;
}
}
//select method
public vessel_owner_ref getVesselDB(int id)
{
vessel_owner_ref vessel_owner_ref = null;
try
{
vessel_owner_ref = db.vessel_owner_ref.Where(v => v.vessel_id == id).FirstOrDefault();
if (vessel_owner_ref == null)
{
vessel_owner_ref = new vessel_owner_ref();
}
return(vessel_owner_ref);
}
catch (Exception)
{
throw;
}
}
//get owner data to Fax Message
public owner getOwnerForFaxDB(int distressReportId)
{
d_detail d_detail = null;
vessel_owner_ref vessel_owner_ref = null;
owner owner = null;
try
{
d_detail = db.d_detail.Where(d => d.d_detail_id == distressReportId).FirstOrDefault();
vessel_owner_ref = db.vessel_owner_ref.Where(vor => vor.vessel_id == d_detail.vessel_id).FirstOrDefault();
owner = db.owners.Where(o => o.owner_id == vessel_owner_ref.owner_id && o.owner_status == 1).FirstOrDefault();
}
catch (Exception)
{
throw;
}
return(owner);
}
//select method
public vessel_owner_ref getOwnerDB(int id)
{
vessel_owner_ref vessel_owner_ref = null;
try
{
vessel_owner_ref = db.vessel_owner_ref.Where(o => o.owner_id == id && o.owner.owner_status == 1).FirstOrDefault();
if (vessel_owner_ref == null)
{
vessel_owner_ref = new vessel_owner_ref();
}
}
catch (Exception)
{
throw;
}
return(vessel_owner_ref);
}
//select only vessel object for shared ownership page
public vessel_owner_ref getVesselOnlyDB(int id)
{
vessel_owner_ref vesselOwnerRef = new vessel_owner_ref();
try
{
vessel_owner_ref vessel = db.vessel_owner_ref.Where(v => v.vessel_id == id && v.vessel.vessel_status == 1).FirstOrDefault();
if (vessel != null)
{
//This will map only vessel object to new vessel_owner_ref
vesselOwnerRef.vessel = vessel.vessel;
vesselOwnerRef.vessel_id = vessel.vessel_id;
}
}
catch (Exception)
{
throw;
}
return(vesselOwnerRef);
}
//insert method
public int saveOwnerDB(vessel_owner_ref vessel_owner_ref)
{
int flag = 0;
try
{
var result = db.vessel_owner_ref.Where(o => o.owner.owner_nic == vessel_owner_ref.owner.owner_nic && o.owner.owner_status == 1).FirstOrDefault();
if (result == null)
{
db.vessel_owner_ref.Add(vessel_owner_ref);
db.SaveChanges();
flag = 1;
}
}
catch (Exception)
{
throw;
}
return(flag);
}
//delete method
public int deleteOwnerDB(int id, vessel_owner_ref vessel_owner_ref)
{
int flag = 0;
try
{
var result = db.vessel_owner_ref.Where(o => o.owner_id == id).FirstOrDefault();
if (result != null)
{
db.Entry(result).State = EntityState.Detached;
db.Entry(vessel_owner_ref).State = EntityState.Modified;
db.SaveChanges();
flag = 1;
}
}
catch (Exception)
{
throw;
}
return(flag);
}
//create vessel
public int createVessel(vessel_owner_ref vessel_owner_ref)
{
try
{
vessel_owner_ref.vessel.vessel_created_date = DateTime.Now;
vessel_owner_ref.vessel.vessel_created_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.vessel.vessel_last_modified_date = DateTime.Now;
vessel_owner_ref.vessel.vessel_last_modified_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.vessel.vessel_status = 1;
vessel_owner_ref.owner.owner_created_date = DateTime.Now;
vessel_owner_ref.owner.owner_created_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.owner.owner_last_modified_date = DateTime.Now;
vessel_owner_ref.owner.owner_last_modified_by = HttpContext.Current.User.Identity.Name;
vessel_owner_ref.owner.owner_status = 1;
return(DistressReportService.createVesselDB(vessel_owner_ref)); //this method will not return flag but vessel_id
}
catch (Exception)
{
throw;
}
}
public ActionResult SharedOwnership(vessel_owner_ref vessel_owner_ref)
{
try
{
if (ModelState.IsValid)
{
int status = VesselsControllerManager.saveSharedOwnership(vessel_owner_ref);
if (status == 1)
{
return(RedirectToAction("Index"));
}
else
{
TempData["owner_nic"] = "This Owner is already assign for this vessel";
}
}
return(View());
}
catch (Exception)
{
return(RedirectToAction("Error", "Home", new { error = "POST/Vessels/SharedOwnership" }));
}
}
public ActionResult CreateVessel(vessel_owner_ref vessel_owner_ref)
{
try
{
if (ModelState.IsValid)
{
int vessel_id = DistressReportControllerManager.createVessel(vessel_owner_ref);
if (vessel_id != 0)
{
return(RedirectToAction("Create", new { id = vessel_id }));
}
}
ViewBag.Registration = DistressReportControllerManager.getRegistrationSelectList();
ViewBag.Districts = DistressReportControllerManager.getDistrictsSelectList();
ViewBag.Applications = DistressReportControllerManager.getApplicationSelectList();
return(View());
}
catch (Exception)
{
return(RedirectToAction("Error", "Home", new { error = "POST/DistressReport/CreateVessel" }));
}
}
//insert Shared Ownership
public int saveSharedOwnershipDB(vessel_owner_ref vessel_owner_ref)
{
int flag = 0;
try
{
var result = db.vessel_owner_ref.Where(v => v.vessel_id == vessel_owner_ref.vessel_id && v.vessel.vessel_status == 1).FirstOrDefault();
if (result != null)
{
var resultForUniqueOwner = db.vessel_owner_ref.Where(o => o.owner.owner_nic == vessel_owner_ref.owner.owner_nic && o.owner.owner_status == 1 && o.vessel_id == vessel_owner_ref.vessel_id).FirstOrDefault();
if (resultForUniqueOwner == null)
{
db.vessel_owner_ref.Add(vessel_owner_ref);
db.SaveChanges();
flag = 1;
}
}
}
catch (Exception)
{
throw;
}
return(flag);
}
