public List <UserPersonModel> getUserPerson(UserPersonModel parameters)
{
PersonDA PersonDA = new PersonDA();
var resp = PersonDA.getUserPerson(parameters);
return(resp);
}
public ActionResult ValidateEmail(string email)
{
PersonServices PersonServ = new PersonServices();
bool ValidateEmail = true;
int? UserId = (SessionWeb.User != null) ? SessionWeb.User.UserId : null;
if (UserId != null && UserId > 0)
{
UserPersonModel UserCurrentData = PersonServ.getFirstUserPerson(new UserPersonModel()
{
UserId = UserId
});
if (email.ToUpper().Trim() == UserCurrentData.Email.ToUpper().Trim())
{
ValidateEmail = false;
}
}
if (ValidateEmail)
{
var result = PersonServ.ValidateExistingEmail(email);
if (result.Status == Status.Warning)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
Response.StatusDescription = EGULF.App_LocalResources.SingUp.MsgEmailExisting;
}
}
return(Json(new RequestResult <object>()
{
Status = Status.Success
}, JsonRequestBehavior.AllowGet));
}
public UserPersonModel getFirstUserPerson(UserPersonModel parameters)
{
PersonDA PersonDA = new PersonDA();
var resp = PersonDA.getUserPerson(parameters);
return(resp.FirstOrDefault());
}
public JsonResult SaveProfile(UserPersonModel parameters)
{
try
{
parameters.UserId = SessionWeb.User.UserId;
if (Request.Files.Count > 0)
{
var File = Request.Files[0];
parameters.FileName = File.FileName;
parameters.ContentType = File.ContentType;
parameters.File = File.InputStream;
}
PersonServices PersonServ = new PersonServices();
var result = PersonServ.SaveProfile(parameters);
return(Json(result));
}
catch (Exception ex)
{
return(Json(new RequestResult <object>()
{
Status = Status.Error, Message = ex.Message
}));
}
}
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 <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 FileModel GetUserImage(int UserId)
{
UserPersonModel parametersUserPerson = new UserPersonModel();
parametersUserPerson.UserId = UserId;
var responseUserPersonData = getFirstUserPerson(parametersUserPerson);
if (!string.IsNullOrEmpty(responseUserPersonData.FileName) && !String.IsNullOrEmpty(responseUserPersonData.Path))
{
FileServices FileServ = new FileServices();
var FileData = FileServ.GetFile(responseUserPersonData.Path + responseUserPersonData.FileName);
if (!string.IsNullOrEmpty(FileData.FileName))
{
return(FileData);
}
}
return(null);
}
public RequestResult <object> DeleteUserImage(int UserId)
{
TransactionOptions scopeOptions = new TransactionOptions();
//scopeOptions.IsolationLevel = IsolationLevel.ReadCommitted;
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, scopeOptions))
{
try
{
RequestResult <object> result = new RequestResult <object>();
UserPersonModel parametersUserPerson = new UserPersonModel();
parametersUserPerson.UserId = UserId;
var responseUserPersonData = getFirstUserPerson(parametersUserPerson);
if (responseUserPersonData.FileReferenceId != null || (!string.IsNullOrEmpty(responseUserPersonData.FileName) && !String.IsNullOrEmpty(responseUserPersonData.Path)))
{
result = RemoveUserImage(new UserPersonModel()
{
UserId = UserId
});
FileServices FileServ = new FileServices();
FileServ.DeleteFile(responseUserPersonData.Path + responseUserPersonData.FileName);
ts.Complete();
return(result);
}
return(new RequestResult <object>()
{
Status = Status.Success
});
}
catch (Exception ex)
{
ts.Dispose();
return(new RequestResult <object>()
{
Status = Status.Error, Message = ex.Message
});
}
}
}
public RequestResult <object> RemoveUserImage(UserPersonModel parameters)
{
PersonDA PersonDA = new PersonDA();
return(PersonDA.RemoveUserImage(parameters));
}
public RequestResult <object> SaveProfile(UserPersonModel parameters)
{
TransactionOptions scopeOptions = new TransactionOptions();
//scopeOptions.IsolationLevel = IsolationLevel.ReadCommitted;
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, scopeOptions))
{
try
{
FileModel parametersFile = new FileModel();
if (parameters.File != null && parameters.File.Length > 0)
{
ImagesServices ImageServ = new ImagesServices();
Stream ProcessedImage = ImageServ.ResizeProfileImage(parameters.File);
ProcessedImage.Position = 0;
var FileNameExtension = ".jpg";//Path.GetExtension(parameters.FileName);
parameters.FileName = "profileimage-" + parameters.UserId + FileNameExtension;
var ProfileImgPath = "users/" + parameters.UserId + "/images/profile/";
parametersFile.FileReferenceId = parameters.FileReferenceId ?? 0;
parametersFile.FileName = parameters.FileName;
parametersFile.ContentType = "image/jpeg"; //parameters.ContentType;
parametersFile.Path = ProfileImgPath;
parametersFile.FileContent = ProcessedImage; //parameters.File;
FileServices FileServ = new FileServices();
FileServ.SaveFile(parametersFile);
parameters.FileReferenceId = parametersFile.FileReferenceId;
}
//here we send person data
PersonDA PersonDA = new PersonDA();
PersonModel parametersPerson = new PersonModel();
parametersPerson.PersonId = parameters.PersonId;
parametersPerson.FirstName = parameters.FirstName;
parametersPerson.LastName = parameters.LastName;
parametersPerson.Email = parameters.Email;
parametersPerson.PhoneNumber = parameters.PhoneNumber;
parametersPerson.Skype = parameters.Skype;
parametersPerson.UserId = parameters.UserId;
parametersPerson.CompanyId = parameters.CompanyId;
parametersPerson.FileReferenceId = parameters.FileReferenceId;
RequestResult <object> responsePerson = PersonDA.insUpdPerson(parametersPerson);
if (responsePerson.Status == Status.Error)
{
throw new Exception(responsePerson.Message);
}
ts.Complete();
return(responsePerson);
}
catch (Exception ex)
{
ts.Dispose();
return(new RequestResult <object>()
{
Status = Status.Error, Message = ex.Message
});
}
}
}
public ActionResult Invitate(string mails)
{
try
{
if (string.IsNullOrEmpty(mails.Trim()))
{
return(Json(new RequestResult <object>()
{
Status = Status.Warning, Message = localResource.txt_invitation_empty
}));
}
InvitationCompanyServices invServ = new InvitationCompanyServices();
PersonServices persnServ = new PersonServices();
string[] mailsS = mails.Split(new Char[] { ',' });
RequestResult <object> result = new RequestResult <object>()
{
Status = Status.Success
};
string mailsNoSend = string.Empty;
foreach (var mail in mailsS)
{
var mailT = mail.Trim();
//Enviar invitación
if (!HasInvitation(mailT, UserCompanyId))
{
//si tiene CUENTA
UserPersonModel p = null;
if ((p = persnServ.getFirstUserPerson(new UserPersonModel()
{
Email = mailT
})) != null)
{
if (p.CompanyId != null)
{
mailsNoSend += "," + mail;
continue;
}
SendNotificationsInvite(p.PersonId, 2);
}
SendMailInvitation(mailT);
result = invServ.InsUpd(new InvitationCompanyModel()
{
CompanyId = UserCompanyId,
From = UserPerson.PersonId,
To = p == null ? null : p.PersonId,
CreatedAt = DateTime.Now,
Status = 0,
Email = mailT
});
}
if (HasRejectedInvitation)
{
mailsNoSend += "," + mail;
}
}
if (result == null || result.Status != Status.Success)
{
throw new Exception(string.Format("{0}: {1}", localResource.txt_error_invite, result.Message));
}
if (!string.IsNullOrEmpty(mailsNoSend))
{
return(Json(new RequestResult <object>()
{
Status = Status.Warning, Message = string.Format(localResource.txt_invitation_has_company, mailsNoSend.Substring(1))
}));
}
return(Json(result));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
Response.StatusDescription = ex.Message;
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Offer from Project to Vessel
/// Validations
/// Insert offer with Status NEW
/// Send alert to Vessel company owners
/// Send mail to Vessel company owners
/// </summary>
/// <param name="offer"></param>
/// <returns></returns>
public RequestResult <List <AlertModel> > InsComplete(OfferModel offer)
{
RequestResult <List <AlertModel> > resp = new RequestResult <List <AlertModel> >()
{
Status = Status.Success
};
OfferDA offerDA = new OfferDA();
VesselServices vesselServices = new VesselServices();
PersonServices personServices = new PersonServices();
AlertServices alertServices = new AlertServices();
List <AlertModel> lstAlertToSend = new List <AlertModel>();
MailServices MailServ = new MailServices();
ITemplate factory = new TemplateMessagesFactory();
TransactionOptions scopeOptions = new TransactionOptions();
////scopeOptions.IsolationLevel = IsolationLevel.ReadCommitted;
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, scopeOptions))
{
try
{
if (offer.Vessel.VesselId == null)
{
throw new Exception("VesselId REQUIRED");
}
if (offer.Project.ProjectId == null)
{
throw new Exception("ProjectId REQUIRED");
}
if (offer.ProjectAdmin.PersonId == null)
{
throw new Exception("ProjectAdmin.PersonId REQUIRED");
}
OfferModel val = new OfferModel();
List <OfferModel> lstVal = new List <OfferModel>();
val.Project.ProjectId = offer.Project.ProjectId;
val.Vessel.VesselId = offer.Vessel.VesselId;
lstVal = Get(val);
if (lstVal.Count > 0)
{
throw new Exception("STATUS_NOT_VALID");
}
VesselModel vessel = new VesselModel();
vessel.VesselId = offer.Vessel.VesselId;
vessel = vesselServices.Get(vessel).FirstOrDefault();
// Insert offer with Status NEW
var respOffer = offerDA.InsUpd(offer);
if (respOffer.Status != Status.Success)
{
throw new Exception(respOffer.Message);
}
// Send alert to Vessel company owners
//Listado de los usuarios de una compañía
UserPersonModel person = new UserPersonModel();
person.CompanyId = vessel.Company.CompanyId;
List <UserPersonModel> lst = personServices.getUserPerson(person);
Dictionary <string, string> values = new Dictionary <string, string>();
values.Add("IMO", vessel.Imo);
values.Add("VESSELNAME", vessel.Name);
AlertModel alert = alertServices.GetWithValues(6, values);
SystemVariableServices SVS = new SystemVariableServices();
Dictionary <string, string[]> param = new Dictionary <string, string[]>();
string EgulfUrl = SVS.GetSystemVariableValue("EgulfWeb");
param.Add("{Enfasis}", new string[] { vessel.Imo, vessel.Name });
param.Add("{Btn_url}", new string[] { EgulfUrl });
foreach (UserPersonModel personItem in lst)
{
AlertModel alertAux = alert.Clone();
alertAux.To = personItem.PersonId;
lstAlertToSend.Add(alertAux);
MailServ.SendMail(factory.GetTemplate(personItem.Email, "VesselOfferReceived", param));
}
var respAlert = alertServices.InsUpd(lstAlertToSend);
if (respAlert != null)
{
throw new Exception(respAlert.Message);
}
resp.Data = lstAlertToSend;
ts.Complete();
}
catch (Exception ex)
{
ts.Dispose();
resp = new RequestResult <List <AlertModel> >()
{
Status = Status.Error, Message = ex.Message
};
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
throw ex;
}
}
return(resp);
}
