public ActionResult Create()
{
CountryServices countryServices = new CountryServices();
ProjectTypeServices projectTypeServices = new ProjectTypeServices();
ClasificationSocietyServices clasificationSocietyServices = new ClasificationSocietyServices();
PortServices portServices = new PortServices();
RegionServices regionServices = new RegionServices();
VesselTypeServices vesselTypeServices = new VesselTypeServices();
ViewBag.LstCountry = countryServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstProjectType = projectTypeServices.GetSelect(null).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstVesselType = vesselTypeServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstClasificationSociety = clasificationSocietyServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstPort = portServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstRegion = regionServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
return(View(new VesselViewModel()));
}
public ActionResult EditProjectType(int id)
{
var projectType = new ProjectType();
try
{
if (id < 1)
{
projectType.Error = "Invalid Selection!";
projectType.ErrorCode = -1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
var myViewObj = new ProjectTypeServices().GetProjectType(id);
if (myViewObj == null || myViewObj.ProjectTypeId < 1)
{
projectType.Error = "Project Type Information could not be retrieved.";
projectType.ErrorCode = -1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
Session["_projectType"] = myViewObj;
myViewObj.ErrorCode = myViewObj.ProjectTypeId;
return(Json(myViewObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
projectType.Error = "An unknown error was ProjectType Information could not be retrieved.";
projectType.ErrorCode = -1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
}
private List <ProjectType> GetProjectTypes()
{
var sectorList = new ProjectTypeServices().GetAllOrderedProjectTypes() ?? new List <ProjectType>();
if (!sectorList.Any())
{
return(new List <ProjectType>());
}
return(sectorList);
}
public ViewResult ProjectTypes()
{
var projectTypeList = new ProjectTypeServices().GetAllOrderedProjectTypes() ?? new List <ProjectType>();
if (!projectTypeList.Any())
{
ViewBag.Title = "Project Type SetUp";
return(View(projectTypeList));
}
projectTypeList.Remove(projectTypeList.Find(m => m.ProjectTypeId == (int)OtherNotAvailable.Not_Available));
ViewBag.Title = "Manage Project Types";
return(View(projectTypeList));
}
public ActionResult AddProjectType(ProjectType projectType)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (!ModelState.IsValid)
{
projectType.Error = "Please supply all required fields and try again";
projectType.ErrorCode = -1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(projectType);
if (wx.Code < 1)
{
projectType.Error = wx.Error;
projectType.ErrorCode = -1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
projectType.Name = projectType.Name;
var k = new ProjectTypeServices().AddProjectTypeCheckDuplicate(projectType);
if (k < 1)
{
if (k == -3)
{
projectType.Error = "Project Type already exists";
projectType.ErrorCode = -3;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
projectType.Error = "Process Failed! Please contact the Admin or try again later";
projectType.ErrorCode = 0;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
projectType.Error = "Record was added successfully";
projectType.ErrorCode = 1;
projectType.ProjectTypeId = k;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
projectType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
projectType.ErrorCode = 0;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(int Id)
{
CountryServices countryServices = new CountryServices();
ProjectTypeServices projectTypeServices = new ProjectTypeServices();
ClasificationSocietyServices clasificationSocietyServices = new ClasificationSocietyServices();
PortServices portServices = new PortServices();
RegionServices regionServices = new RegionServices();
VesselTypeServices vesselTypeServices = new VesselTypeServices();
VesselServices vesselServices = new VesselServices();
VesselViewModel model = new VesselViewModel();
//Desencriptamos y validamos permisos y existencia
VesselModel vessel = vesselServices.GetFirst(new VesselModel()
{
VesselId = Id
});
if (vessel == null || vessel.Company.CompanyId != SessionWeb.User.CompanyId)
{
return(RedirectToAction("Unauthorized", "Redirect"));
}
model.Vessel = vessel;
model.VesselSpecificInfo = vesselServices.GetSpecificInfo(Id);
model.SpecificInfo = vesselServices.GetSpecificInfoExtra(Id);
model.VesselCost = vesselServices.GetCost(Id);
ViewBag.LstCountry = countryServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstProjectType = projectTypeServices.GetSelect(null).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstVesselType = vesselTypeServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstClasificationSociety = clasificationSocietyServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstPort = portServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstRegion = regionServices.GetSelect(globalResources.Select).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
return(View("Create", model));
}
public ActionResult Create(int?id = 0)
{
ProjectTypeServices ProjectTypeServ = new ProjectTypeServices();
RegionServices RegionServ = new RegionServices();
SystemVariableServices SystemVarServ = new SystemVariableServices();
ViewBag.ProjectId = id;
ViewBag.LstProjectType = ProjectTypeServ.GetSelect(null).Select(x => new SelectListItem()
{
Value = x.Value, Text = x.Text
});
ViewBag.LstRegion = RegionServ.GetSelect(null).Select(x => new SelectListItem()
{
Value = x.Value, Text = x.Text
});
//ViewBag.ProjectCategoryType = JsonConvert.SerializeObject(SystemVarServ.GetSystemVariableValue("ProjectCategoryClasification"));
ViewBag.CabinSpecificationType = JsonConvert.SerializeObject(SystemVarServ.GetSystemVariableValue("CabinSpecificationTypes"));
ViewBag.LstProjectCategoryType = JsonConvert.SerializeObject(ProjectTypeServ.Get(new ProjectTypeModel()).ToList());
return(View());
}
public ActionResult Index()
{
ProjectServices ProjectServ = new ProjectServices();
ProjectTypeServices projectTypeServices = new ProjectTypeServices();
RegionServices regionServices = new RegionServices();
ViewBag.LstProjects = ProjectServ
.GetSelect(null, new EGullf.Services.Models.Operation.ProjectModel()
{
CompanyId = UserCompanyId ?? -1, Status = ProjectModel.STATUS_NEW
})
.Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstSuitability = projectTypeServices.GetSelect(null).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.LstRegion = regionServices.GetSelect(null).Select(x => new SelectListItem {
Value = x.Value, Text = x.Text
});
ViewBag.currentPersonId = SessionWeb.User.PersonId;
return(View());
}
public RequestResult <object> SaveProject(ProjectModel parameters)
{
TransactionOptions scopeOptions = new TransactionOptions();
//scopeOptions.IsolationLevel = IsolationLevel.ReadCommitted;
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, scopeOptions))
{
try
{
//here we save basic project info
var respSaveProjectBasicInfo = InsUpdProjectInfo(parameters);
if (respSaveProjectBasicInfo.Status == Status.Success)
{
SystemVariableServices SystemVariableServ = new SystemVariableServices();
Int16 TypeProject = Convert.ToInt16(SystemVariableServ.GetSystemVariableValue("TypeProject"));
var dataProjectBasicInfo = (ProjectModel)respSaveProjectBasicInfo.Data;
parameters.ProjectId = dataProjectBasicInfo.ProjectId;
//we save specific info
SpecificInformationServices SpecificInfoServ = new SpecificInformationServices();
SpecificInformationModel SpecificInfoModel = parameters;
SpecificInfoModel.MatchableId = parameters.ProjectId;
SpecificInfoModel.Type = TypeProject;
var respSaveProjectSpecificInfo = SpecificInfoServ.InsUpd(SpecificInfoModel);
if (respSaveProjectSpecificInfo.Status == Status.Success)
{
//we validate project category and only save cabin specifications if project category is personnel transportation
ProjectTypeServices ProjectTypeServ = new ProjectTypeServices();
ProjectTypeModel ProjectType = ProjectTypeServ.GetById(parameters.ProjectTypeId);
string CategoryPersonnelTransportation = SystemVariableServ.GetSystemVariableValue("CategoryPersonnelTransportation");
if (ProjectType.Category == CategoryPersonnelTransportation)
{
////at the end we save cabin specifications
//CabinSpecificationServices CabinSpecificationServ = new CabinSpecificationServices();
//foreach (var item in parameters.CabinSpecification.ToList())
//{
// item.ReferenceId = parameters.ProjectId;
// item.Type = TypeProject;
// var respSaveCabinSpecification = CabinSpecificationServ.InsUpd(item);
// if (respSaveCabinSpecification.Status == Status.Error)
// throw new Exception(respSaveCabinSpecification.Message);
//}
}
ts.Complete();
return(new RequestResult <object>()
{
Status = Status.Success, Data = parameters
});
}
else
{
throw new Exception(respSaveProjectSpecificInfo.Message);
}
}
else
{
//return respSaveProjectBasicInfo;
throw new Exception(respSaveProjectBasicInfo.Message);
}
}
catch (Exception ex)
{
ts.Dispose();
return(new RequestResult <object>()
{
Status = Status.Error, Message = ex.Message
});
}
}
}
public ActionResult EditProjectType(ProjectType projectType)
{
ModelState.Clear();
ViewBag.LoadStatus = "0";
try
{
if (Session["_projectType"] == null)
{
projectType.Error = "Session has expired";
projectType.ErrorCode = 0;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
var oldProjectType = Session["_projectType"] as ProjectType;
if (oldProjectType == null || oldProjectType.ProjectTypeId < 1)
{
projectType.Error = "Session has expired";
projectType.ErrorCode = 0;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
if (!ModelState.IsValid)
{
projectType.Error = "Please supply all required fields and try again";
projectType.ErrorCode = -1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
var wx = ValidateControl(projectType);
if (wx.Code < 1)
{
projectType.Error = wx.Error;
projectType.ErrorCode = -1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
oldProjectType.Name = projectType.Name;
oldProjectType.Description = projectType.Description;
var k = new ProjectTypeServices().UpdateProjectTypeCheckDuplicate(oldProjectType);
if (k < 1)
{
if (k == -3)
{
projectType.Error = "Project Type already exists";
projectType.ErrorCode = 0;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
projectType.Error = "Process Failed! Please contact the Admin or try again later";
projectType.ErrorCode = 0;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
projectType.Error = "Project Type Information was successfully updated";
projectType.ErrorCode = 1;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
projectType.Error = "An unknown error was encountered. Request could not be serviced. Please try again later.";
projectType.ErrorCode = 0;
return(Json(projectType, JsonRequestBehavior.AllowGet));
}
}
private Project ProcessRecord(DataRowView dv, ref string msg)
{
if (dv == null)
{
return(null);
}
try
{
var mInfo = new Project
{
Name = dv.Row["ProjectName"].ToString().Trim()
};
var companyName = dv.Row["CompanyName"].ToString().Trim();
if (string.IsNullOrEmpty(companyName))
{
msg = "Company Name is empty";
return(null);
}
var compId = new CompanyServices().GetCompanyId(companyName);
if (compId < 1)
{
msg = "Company information could not be processed.";
return(null);
}
mInfo.CompanyId = compId;
var projectType = dv.Row["ProjectType"].ToString().Trim();
if (string.IsNullOrEmpty(projectType))
{
msg = "project Type is empty";
return(null);
}
var projectTypeId = new ProjectTypeServices().GetProjectTypeId(projectType);
if (projectTypeId < 1)
{
msg = "Project Type information could not be processed.";
return(null);
}
mInfo.ProjectTypeId = projectTypeId;
var terrain = dv.Row["Terrain"].ToString().Trim();
if (string.IsNullOrEmpty(terrain))
{
msg = "Terrain is empty";
return(null);
}
var terrainId = new TerrainServices().GetTerrainId(terrain);
if (terrainId < 1)
{
msg = "Terrain information could not be processed.";
return(null);
}
mInfo.TerrainId = terrainId;
var sector = dv.Row["Sector"].ToString().Trim();
if (string.IsNullOrEmpty(sector))
{
msg = "Sector is empty";
return(null);
}
var sectorId = new SectorServices().GetSectorId(sector);
if (sectorId < 1)
{
msg = "Sector information could not be processed.";
return(null);
}
mInfo.SectorId = sectorId;
var duration = dv.Row["Duration(Months)"].ToString().Trim();
if (string.IsNullOrEmpty(duration))
{
msg = "Project Duration is empty";
return(null);
}
int outDur;
var durResult = int.TryParse(duration, out outDur);
if (!durResult || outDur < 1)
{
msg = "Project Duration is not Valid";
return(null);
}
mInfo.Duration = outDur;
double cost;
var costStr = double.TryParse(dv.Row["Cost(Million)"].ToString().Trim(), out cost);
if (!costStr || cost <= 0)
{
msg = "Invalid Project Cost";
return(null);
}
mInfo.Cost = cost;
if (!string.IsNullOrEmpty(dv.Row["Description"].ToString().Trim()))
{
mInfo.Description = dv.Row["Description"].ToString().Trim();
}
if (!string.IsNullOrEmpty(dv.Row["Objectives"].ToString().Trim()))
{
mInfo.ProjectObjectives = dv.Row["Objectives"].ToString().Trim();
}
if (!string.IsNullOrEmpty(dv.Row["CompletionStatus(Completed/UnCompleted)"].ToString().Trim()))
{
var tts = dv.Row["CompletionStatus(Completed/UnCompleted)"].ToString().Trim().ToLower();
if (tts == "completed")
{
mInfo.CompletionStatus = 1;
}
if (tts == "uncompleted")
{
mInfo.CompletionStatus = 0;
}
}
if (!string.IsNullOrEmpty(dv.Row["DateCompleted(yyyy/MM/dd)"].ToString().Trim()))
{
DateTime ddt;
var dtResult = DateTime.TryParse(dv.Row["DateCompleted(yyyy/MM/dd)"].ToString().Trim(), out ddt);
if (!dtResult)
{
msg = "Invalid Project Completion Date";
return(null);
}
mInfo.DateCompleted = ddt;
}
return(mInfo);
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
