public List <UserPersonModel> getUserPerson(UserPersonModel parameters) { using (var db = new EGULFEntities()) { var result = db.sp_selUserPerson(parameters.PersonId, parameters.UserId, parameters.Username, parameters.Email, parameters.CompanyId) .Select(x => new UserPersonModel() { PersonId = x.PersonId, FirstName = x.FirstName, LastName = x.LastName, UserId = (int)x.UserId, Username = x.UserName, PhoneNumber = x.PhoneNumber, Email = x.Email, Skype = x.Skype, CompanyId = x.CompanyId, CompanyName = x.CompanyName, FileReferenceId = x.FileReferenceId, FileName = x.FileName, Path = x.Path, ContentType = x.ContentType }).ToList(); return(result); } }
public RequestResult <MessageModel> InsUpd(MessageModel model) { RequestResult <MessageModel> ER = new RequestResult <MessageModel>(); using (var db = new EGULFEntities()) { ObjectParameter Id = new ObjectParameter("MessageId", typeof(int?)); ObjectParameter CreatedAt = new ObjectParameter("CreatedAt", typeof(DateTime?)); ObjectParameter _Status = new ObjectParameter("Status", typeof(int?)); Id.Value = model.MessageId; CreatedAt.Value = model.CreatedAt; _Status.Value = model.Status; ER = db.sp_InsUpdMessage(Id, model.ReferenceId, model.From, model.To, _Status, model.Message, CreatedAt) .Select(x => new RequestResult <MessageModel>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message, Data = model }).FirstOrDefault(); if (ER.Status == Status.Success) { ER.Data.MessageId = Convert.ToInt32(Id.Value.ToString()); ER.Data.CreatedAt = Convert.ToDateTime(CreatedAt.Value); ER.Data.Status = Convert.ToInt32(_Status.Value.ToString()); } return(ER); } }
public List <MessageModel> Get(PagerModel pager, MessageModel filter) { using (var db = new EGULFEntities()) { var resp = db.sp_SelPagMessage( filter.MessageId, filter.ReferenceId, filter.From, filter.To, filter.Status, pager.Start, pager.Offset).ToList(); if (resp.Count() > 0) { var first = resp.FirstOrDefault(); pager.TotalRecords = first.TotalRecords.HasValue ? first.TotalRecords.Value : 0; } return((from x in resp select new MessageModel() { ReferenceId = x.ReferenceId, MessageId = x.MessageId, From = x.From, To = x.To, Status = x.Status, Message = x.Message, CreatedAt = x.CreatedAt, Alias = x.Alias }).ToList()); } }
public RequestResult <OfferModel> InsUpd(OfferModel model) { RequestResult <OfferModel> ER = new RequestResult <OfferModel>() { Status = Status.Success }; using (var db = new EGULFEntities()) { ObjectParameter Id = new ObjectParameter("OfferId", typeof(int?)); Id.Value = model.OfferId; ER = db.sp_InsUpdOffer(Id, model.Vessel.VesselId, model.Project.ProjectId, model.Status, model.VesselAdmin.PersonId, model.ProjectAdmin.PersonId, model.OfferReferenceId, model.Comment, model.UserModifiedId) .Select(x => new RequestResult <OfferModel>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message, Data = model }).FirstOrDefault(); if (ER.Status == Status.Success) { ER.Data.OfferId = Convert.ToInt32(Id.Value.ToString()); model.OfferId = Convert.ToInt32(Id.Value.ToString()); } return(ER); } }
public SpecificInformationModel GetByReferenceId(int ReferenceId, int Type) { using (var db = new EGULFEntities()) { var resp = db.sp_SelSpecificInfo( ReferenceId, Type).ToList(); return((from x in resp select new SpecificInformationModel() { MatchableId = x.MatchableId, BHP = x.BHP, SubtypeId = x.SubtypeId, BollardPullAhead = x.BollardPullAhead, BollardPullAstern = x.BollardPullAstern, NumberPassenger = x.NumberPassenger, AirCondition = x.AirCondition, MessRoom = x.MessRoom, ControlRoom = x.ControlRoom, ConferenceRoom = x.ConferenceRoom, Gymnasium = x.Gym, SwimingPool = x.Pool, Office = x.Office, Hospital = x.Hospital, CargoCapacity = x.CargoCapacity, PumpRates = x.PumpRates, Type = x.Type, BollardPull = x.BollardPull, TankCapacity = x.TankCapacity, DischargeRate = x.DischargeRate, PemexCheck = x.PemexCheck, DeckStrenght = x.DeckStrenght }).FirstOrDefault()); } }
public RequestResult <OfferCostModel> InsUpdCost(OfferCostModel model) { RequestResult <OfferCostModel> ER = new RequestResult <OfferCostModel>() { Status = Status.Success }; using (var db = new EGULFEntities()) { ObjectParameter Id = new ObjectParameter("OfferCostId", typeof(int?)); Id.Value = model.OfferCostId; ER = db.sp_InsUpdOfferCost(Id, model.OfferId, model.DailyRate) .Select(x => new RequestResult <OfferCostModel>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message, Data = model }).FirstOrDefault(); if (ER.Status == Status.Success) { ER.Data.OfferCostId = Convert.ToInt32(Id.Value.ToString()); } return(ER); } }
public VesselSpecificInfoModel GetSpecificInfo(int VesselId) { using (var db = new EGULFEntities()) { var data = db.sp_SelVesselSpecificInfo(VesselId).FirstOrDefault(); return(new VesselSpecificInfoModel() { VesselId = data.VesselId, GrossTonnage = data.GrossTonnage, NetTonnage = data.NetTonnage, BeamOverall = data.BeamOverall, LengthOverall = data.LengthOverall, MaximumLoadedDraft = data.MaximumLoadedDraft, FreeDeckArea = data.FreeDeckArea, DeckStrenght = data.DeckStrenght, FreshWaterCapacity = data.FreshWaterCapacity, FuelOilCapacity = data.FuelOilCapacity, BallastWaterCapacity = data.BallastWaterCapacity, MudCapacity = data.MudCapacity, CementTanksCapacity = data.CementTanksCapacity, OilRecoveryCapacity = data.OilRecoveryCapacity, WaterMarkerPlant = data.WaterMarkerPlant, HotWaterCalorifier = data.HotWaterCalorifier, SewageTreatmentPlant = data.SewageTreatmentPlant, CruisingSpeed = data.CruisingSpeed, MaximumSpeed = data.MaximumSpeed, DistanceCruisingSpeed = data.DistanceCruisingSpeed, DistanceMaxSpeed = data.DistanceMaxSpeed, FuelConsumptionCruisingSpeed = data.FuelConsumptionCruisingSpeed, FuelConsumptionMaxSpeed = data.FuelConsumptionMaxSpeed, DynamicPositionSystem = data.DynamicPositionSystem }); } }
public List <NotificationModel> Get(PagerModel pager, NotificationModel filter) { using (var db = new EGULFEntities()) { var resp = db.sp_SelPagNotification( filter.NotificationId, filter.Type, filter.Date, pager.Search, filter.Status, filter.SourceId, pager.Start, pager.Offset, pager.SortBy, pager.SortDir).ToList(); if (resp.Count() > 0) { var first = resp.FirstOrDefault(); pager.TotalRecords = first.TotalRecords.HasValue ? first.TotalRecords.Value : 0; } return((from x in resp select new NotificationModel() { NotificationId = x.NotificationId, Type = x.Type, Date = x.Date, Description = x.Description, Status = x.Status, SourceId = x.SourceId, }).ToList()); } }
public string GetSystemVariableValue(string VariableName) { using (var db = new EGULFEntities()) { SystemVariable VariableData = new SystemVariable(); VariableData = (from v in db.SystemVariable.ToList() where v.VariableName == VariableName select new SystemVariable { VariableId = v.VariableId, VariableName = v.VariableName, Value = v.Value, Entity = v.Entity, Description = v.Description }).FirstOrDefault(); if (VariableData.VariableName != null) { return(VariableData.Value); } else { return(null); } } }
public RequestResult <VesselAvailabilityModel> InsUpd(VesselAvailabilityModel model) { RequestResult <VesselAvailabilityModel> ER = new RequestResult <VesselAvailabilityModel>() { Status = Status.Success }; using (var db = new EGULFEntities()) { ObjectParameter Id = new ObjectParameter("AvailabilityVesselId", typeof(int?)); Id.Value = model.AvailabilityVesselId; ER = db.sp_InsUpdAvailabilityVessel( Id, model.VesselId, model.StartDate, model.EndDate, model.ReasonId, model.ReasonDescription ).Select(x => new RequestResult <VesselAvailabilityModel>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message, Data = model }).FirstOrDefault(); if (ER.Status == Status.Success) { ER.Data.VesselId = Convert.ToInt32(Id.Value.ToString()); } return(ER); } }
public List <InvitationCompanyModel> Get(PagerModel pager, InvitationCompanyModel filter) { using (var db = new EGULFEntities()) { var resp = db.sp_SelInvitationsByCompanyId(filter.CompanyId, pager.Search, pager.Start, pager.Offset, pager.SortBy, pager.SortDir).ToList(); if (resp.Count() > 0) { var first = resp.FirstOrDefault(); pager.TotalRecords = first.TotalRecords.HasValue ? first.TotalRecords.Value : 0; } //return new List<InvitationCompanyModel>(); return((from x in resp select new InvitationCompanyModel() { CompanyInvitationId = x.CompanyInvitationId, CompanyId = x.CompanyId, From = x.From, To = x.To, CreatedAt = x.created_at, Status = x.status, Email = x.Email, FirstName = x.FirstName, LastName = x.LastName, CompanyName = x.CompanyName }).ToList()); } }
public string getMasterEmailTemplate(string TemplateName) { using (var db = new EGULFEntities()) { EmailTemplateModel TemplateData = new EmailTemplateModel(); TemplateData = (from t in db.EmailTemplate.ToList() where t.Name == TemplateName select new EmailTemplateModel { EmailTemplateId = t.EmailTemplateId, Name = t.Name, Html = t.Html, Module = t.Module, Description = t.Description }).FirstOrDefault(); if (TemplateData.Name != null) { return(TemplateData.Html); } else { return(null); } } }
public List <CompanyModel> Get(PagerModel pager, CompanyModel filter) { using (var db = new EGULFEntities()) { var resp = db.sp_SelPagCompany(filter.CompanyId, filter.CompanyName, filter.RFC, filter.Address, filter.PhoneNumber, filter.Email, pager.Start, pager.Offset, pager.SortBy, pager.SortDir).ToList(); if (resp.Count() > 0) { var first = resp.FirstOrDefault(); pager.TotalRecords = first.TotalRecords.HasValue ? first.TotalRecords.Value : 0; } return((from x in resp select new CompanyModel() { CompanyId = x.CompanyId, CompanyName = x.CompanyName.Trim(), RFC = x.RFC.Trim(), Address = x.Address.Trim(), PhoneNumber = x.PhoneNumber.Trim(), Email = x.Email.Trim(), }).ToList()); } }
public List <AlertModel> Get(PagerModel pager, AlertModel filter) { using (var db = new EGULFEntities()) { var resp = db.sp_SelPagAlert( filter.AlertId, filter.AlertTemplateId, filter.From, filter.To, filter.Subject, filter.Body, filter.Status, pager.Start, pager.Offset, pager.SortBy, pager.SortDir).ToList(); if (resp.Count() > 0) { var first = resp.FirstOrDefault(); pager.TotalRecords = first.TotalRecords.HasValue ? first.TotalRecords.Value : 0; } return((from x in resp select new AlertModel() { AlertId = x.AlertId, AlertTemplateId = x.AlertTemplateId, From = x.From, To = x.To, Subject = x.Subject, Body = x.Body, Url = x.Url, Extra = x.Extra, Status = x.Status, CreatedAt = x.CreatedAt, UpdatedAt = x.UpdatedAt, TimeAgo = x.TimeAgo, Icon = x.Icon }).ToList()); } }
public RequestResult <object> InsUpd(AlertModel model) { RequestResult <object> ER = new RequestResult <object>(); using (var db = new EGULFEntities()) { ObjectParameter Id = new ObjectParameter("AlertId", typeof(int?)); Id.Value = model.AlertId; ER = db.sp_InsUpdAlert(Id, model.AlertTemplateId, model.From, model.To, model.Subject, model.Body, model.Url, model.Extra, model.Status, model.CreatedAt, model.UpdatedAt) .Select(x => new RequestResult <object>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message }).FirstOrDefault(); if (ER == null) { model.AlertId = Convert.ToInt32(Id.Value.ToString()); } return(ER); } }
public RequestResult <VesselModel> InsUpd(VesselModel model) { RequestResult <VesselModel> ER = new RequestResult <VesselModel>() { Status = Status.Success }; using (var db = new EGULFEntities()) { ObjectParameter Id = new ObjectParameter("VesselId", typeof(int?)); Id.Value = model.VesselId; ER = db.sp_InsUpdVessel(Id, model.Name, model.Imo, model.Country.CountryId, model.YearBuild, model.ClasificationSociety.ClasificationSocietyId, model.ClassNotation, model.ClassValidity, model.VesselType.VesselTypeId, model.HomePort.PortId, model.Image.FileReferenceId, model.Status, model.Location.Lat, model.Location.Lng, model.SuitabilityIds, model.UserModifiedId) .Select(x => new RequestResult <VesselModel>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message, Data = model }).FirstOrDefault(); if (ER.Status == Status.Success) { ER.Data.VesselId = Convert.ToInt32(Id.Value.ToString()); } return(ER); } }
public RequestResult <SpecificInformationModel> InsUpd(SpecificInformationModel model) { RequestResult <SpecificInformationModel> ER = new RequestResult <SpecificInformationModel>(); using (var db = new EGULFEntities()) { ObjectParameter Id = new ObjectParameter("MatchableId", typeof(int?)); Id.Value = model.MatchableId; ER = db.sp_InsUpdSpecificInfo(Id, model.BHP, model.SubtypeId, model.BollardPullAhead, model.BollardPullAstern, model.NumberPassenger, model.AirCondition, model.MessRoom, model.ControlRoom, model.ConferenceRoom, model.Gymnasium, model.SwimingPool, model.Office, model.Hospital, model.CargoCapacity, model.PumpRates, model.Type, model.BollardPull, model.TankCapacity, model.DischargeRate, model.PemexCheck, model.DeckStrenght) .Select(x => new RequestResult <SpecificInformationModel>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message }).FirstOrDefault(); if (ER.Status == Status.Success) { model.MatchableId = Convert.ToInt32(Id.Value.ToString()); } return(ER); } }
public RequestResult <object> RemoveUserImage(UserPersonModel parameters) { using (var db = new EGULFEntities()) { var result = db.sp_DelPersonFileReference(parameters.PersonId, parameters.UserId); return(new RequestResult <object>() { Status = Status.Success }); } }
public int ValAvailability(VesselAvailabilityModel model) { RequestResult <string> resp = new RequestResult <string>() { Status = Status.Success }; using (var db = new EGULFEntities()) { return((int)db.sp_ValAvailabilityVessel(model.VesselId, model.StartDate, model.EndDate).FirstOrDefault()); } }
public FileReferenceModel GetByReference(string reference) { using (var db = new EGULFEntities()) { return(db.sp_SelFileByReference(reference).Select(x => new FileReferenceModel() { ContentType = x.ContentType, FileName = x.FileName, FileReferenceId = x.FileReferenceId, Path = x.Path }).FirstOrDefault()); } }
public RequestResult <object> insUpdPerson(PersonModel parameters) { using (var db = new EGULFEntities()) { ObjectParameter personId = new ObjectParameter("personId", typeof(int?)); personId.Value = parameters.PersonId; var result = db.sp_insUpdPerson(personId, parameters.FirstName, parameters.LastName, parameters.UserId, parameters.PhoneNumber, parameters.Email, parameters.Skype, parameters.FileReferenceId, parameters.CompanyId).Select(x => new ErrorResult() { IsError = x.IsError, Message = x.Message, Line = x.Line, Subject = x.Subject }).FirstOrDefault(); if (result != null && !string.IsNullOrEmpty(result.Message)) { if (result.IsError == true) { return new RequestResult <object>() { Status = Status.Error, Message = result.Message } } ; else { return new RequestResult <object>() { Status = Status.Warning, Message = result.Message } }; } else { parameters.PersonId = Convert.ToInt32(personId.Value.ToString()); return(new RequestResult <object>() { Status = Status.Success, Data = parameters }); } } }
public List <ReasonAvailabilityModel> Get(ReasonAvailabilityModel filter) { using (var db = new EGULFEntities()) { return((from ct in db.ReasonAvailability where ct.ReasonAvailabilityId == filter.ReasonAvailabilityId || filter.ReasonAvailabilityId == null select new ReasonAvailabilityModel { ReasonAvailabilityId = ct.ReasonAvailabilityId, Reason = ct.Reason }).OrderBy(x => x.Reason).ToList()); } }
public List <ClasificationSocietyModel> Get(ClasificationSocietyModel filter) { using (var db = new EGULFEntities()) { return((from ct in db.ClasificationSociety where ct.ClasificationSocietyId == filter.ClasificationSocietyId || filter.ClasificationSocietyId == null select new ClasificationSocietyModel { ClasificationSocietyId = ct.ClasificationSocietyId, Name = ct.Name, Acronym = ct.Acronym }).OrderBy(x => x.Acronym).ToList()); } }
public List <ProjectTypeModel> GetSuitability(int VesselId) { using (var db = new EGULFEntities()) { var resp = db.sp_SelSuitability(VesselId).ToList(); return((from x in resp select new ProjectTypeModel() { ProjectTypeId = x.ProjectTypeId, Acronym = x.Acronym, Name = x.Name }).ToList()); } }
public List <VesselTypeModel> Get(VesselTypeModel filter) { using (var db = new EGULFEntities()) { return((from ct in db.VesselType where ct.VesselTypeId == filter.VesselTypeId || filter.VesselTypeId == null select new VesselTypeModel { VesselTypeId = ct.VesselTypeId, Name = ct.Name, Acronym = ct.Acronym }).ToList()); } }
public List <OfferModel> Get(OfferModel filter) { using (var db = new EGULFEntities()) { return(db.sp_SelOffer(filter.OfferId, filter.Vessel.VesselId, filter.Project.ProjectId) .Select(x => new OfferModel() { OfferId = x.OfferId, Status = x.Status, Vessel = new VesselModel() { VesselId = x.VesselId, Name = x.VesselName, Imo = x.IMO, Country = new CountryModel() { Name = x.CountryName }, HomePort = new PortModel() { Name = x.PortName }, Company = new CompanyModel() { CompanyId = x.VesselCompanyId } }, VesselAdmin = new PersonModel() { PersonId = x.VesselOwnerId, Email = x.VesselOwnerEmail }, Project = new ProjectModel() { Folio = x.Folio, ProjectId = x.ProjectId, StartDate = x.StartDate, EndDate = x.EndDate, CompanyId = x.ProjectCompanyId }, ProjectAdmin = new PersonModel() { PersonId = x.ProjectOwnerId, Email = x.ProjectOwnerEmail } }).ToList()); } }
public List <ProjectTypeModel> Get(ProjectTypeModel filter) { using (var db = new EGULFEntities()) { return((from ct in db.ProjectType where ct.ProjectTypeId == filter.ProjectTypeId || filter.ProjectTypeId == null select new ProjectTypeModel { ProjectTypeId = ct.ProjectTypeId, Name = ct.Name, Acronym = ct.Acronym, Category = ct.Category }).OrderBy(x => x.Acronym).ToList()); } }
public RequestResult <object> Del(string reference) { RequestResult <object> ER = new RequestResult <object>(); using (var db = new EGULFEntities()) { ER = db.sp_DelFileByReference(reference) .Select(x => new RequestResult <object>() { Status = (bool)x.IsError ? Status.Error : Status.Success, Message = x.Message }).FirstOrDefault(); } return(ER); }
public RequestResult <PersonModel> valExistingEmail(PersonModel parameters) { using (var db = new EGULFEntities()) { ObjectParameter personId = new ObjectParameter("personId", typeof(int?)); personId.Value = parameters.PersonId; var result = db.sp_valEmail(personId, parameters.Email); parameters.PersonId = Convert.ToInt32(personId.Value.ToString()); return(new RequestResult <PersonModel>() { Data = parameters }); } }
public List <VesselModel> VesselAvailableProject(int CompanyId, int ProjectId, int OfferId) { using (var db = new EGULFEntities()) { var queryResult = db.sp_SelVesselMatchedAvailable(CompanyId, ProjectId, OfferId).Select(x => new VesselModel() { VesselId = x.VesselId, VesselType = new VesselTypeModel() { Name = x.VesselType }, YearBuild = x.YearBuild, Country = new CountryModel() { Name = x.Country }, HomePort = new PortModel() { Name = x.HomePort, Region = new RegionModel() { Name = x.Region } }, Imo = x.IMO, Name = x.VesselName, SuitabilityDescription = x.VesselProjectTypes, Image = new FileModel() { FileName = x.FileName, Path = x.Path, ContentType = x.ContentType }, VesselCost = new VesselCostModel() { LodgingCost = x.LodgingCost, MealCost = x.MealCost, LaundryCost = x.MealCost, DailyMaxRate = x.DailyMaxRate } }).ToList(); return(queryResult); } }