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);
}
}
