private void InitObject()
{
Option = new List<Option>();
OptionAttribute = new List<OptionAttribute>();
OptionValue = new List<FirmInstitutionOptionValue>();
OptionAttributeValue = new List<FirmInstitutionOptionAttributeValue>();
FIOption = new List<FIOptionValueModel>();
ProfessionalAssociation = new FirmInstitutionProfessionalAssociation();
}
public static Boolean UpdateFirmInstitutionProfessionalAssociation(FirmInstitutionProfessionalAssociation _data)
{
bool IsNew = (_data.idFirmInstitutionProfessionalAssociation == null
|| _data.idFirmInstitutionProfessionalAssociation == 0);
using (UpsilabEntities updateContext = new UpsilabEntities())
{
FirmInstitutionProfessionalAssociation UpdateData;
if (IsNew)
{
UpdateData = new FirmInstitutionProfessionalAssociation();
}
else
{
UpdateData = updateContext.FirmInstitutionProfessionalAssociation.Where(d => d.idFirmInstitutionProfessionalAssociation.Equals(_data.idFirmInstitutionProfessionalAssociation)).FirstOrDefault();
}
UpdateData.idFirmInstitution = _data.idFirmInstitution;
UpdateData.idProfessionalAssociation = _data.idProfessionalAssociation;
UpdateData.City = _data.City;
UpdateData.HeadquartersAddress = _data.HeadquartersAddress;
UpdateData.MembershipNumber = _data.MembershipNumber;
UpdateData.PostCode = _data.PostCode;
UpdateData.Website = _data.Website;
System.Data.EntityState state = System.Data.EntityState.Modified;
if (IsNew)
{
updateContext.FirmInstitutionProfessionalAssociation.AddObject(UpdateData);
state = System.Data.EntityState.Added;
}
updateContext.ObjectStateManager.ChangeObjectState(UpdateData, state);
updateContext.SaveChanges();
}
return true;
}
public static FirmInstitution UpdateFirmInstitution(Guid idFirmInstitution, string fieldName, string fieldValue)
{
FirmInstitution firm = null;
try
{
using (UpsilabEntities db = new UpsilabEntities())
{
firm = db.FirmInstitution.Include("User")
.Where(f => f.idFirmInstitution.Equals(idFirmInstitution))
.SingleOrDefault();
if (firm != null)
{
if (fieldName.StartsWith("ProfessionalAssociation")) //target : FirmInstitutionProfessionalAssociation table
{
FirmInstitutionProfessionalAssociation firmInstitutionProfessionalAssociation = db.FirmInstitutionProfessionalAssociation.Where(d => d.idFirmInstitution == idFirmInstitution).FirstOrDefault(); ;
if (firmInstitutionProfessionalAssociation == null)
{
firmInstitutionProfessionalAssociation = new FirmInstitutionProfessionalAssociation()
{
idFirmInstitution = firm.idFirmInstitution
};
}
switch (fieldName)
{
case "ProfessionalAssociation.idProfessionalAssociation": firmInstitutionProfessionalAssociation.idProfessionalAssociation = Convert.ToInt32(fieldValue); break;
case "ProfessionalAssociation.MembershipNumber": firmInstitutionProfessionalAssociation.MembershipNumber = fieldValue; break;
case "ProfessionalAssociation.HeadquartersAddress": firmInstitutionProfessionalAssociation.HeadquartersAddress = fieldValue; break;
case "ProfessionalAssociation.PostCode": firmInstitutionProfessionalAssociation.PostCode = fieldValue; break;
case "ProfessionalAssociation.City": firmInstitutionProfessionalAssociation.City = fieldValue; break;
case "ProfessionalAssociation.Website": firmInstitutionProfessionalAssociation.Website = fieldValue; break;
}
if (firmInstitutionProfessionalAssociation.idFirmInstitutionProfessionalAssociation == 0)
{
db.FirmInstitutionProfessionalAssociation.AddObject(firmInstitutionProfessionalAssociation);
}
}
else //target : FirmInstitution table
{
switch (fieldName)
{
case "FirmInstitution.FirmInstitutionName": firm.FirmInstitutionName = fieldValue; break;
case "FirmInstitution.FirmStreet": firm.FirmStreet = fieldValue; break;
case "FirmInstitution.FirmPostCode": firm.FirmPostCode = fieldValue; break;
case "FirmInstitution.FirmCity": firm.FirmCity = fieldValue; break;
case "FirmInstitution.FirmPhone": firm.FirmPhone = fieldValue; break;
case "FirmInstitution.MobilePhone": firm.MobilePhone = fieldValue; break;
case "FirmInstitution.Fax": firm.Fax = fieldValue; break;
case "FirmInstitution.E_mail": firm.E_mail = fieldValue; break;
case "FirmInstitution.Website": firm.Website = fieldValue; break;
case "FirmInstitution.NAF_APE": firm.NAF_APE = fieldValue; break;
case "FirmInstitution.NAF": firm.NAF = fieldValue; break;
case "FirmInstitution.NumeroAssuranceQBE": firm.NumeroAssuranceQBE = fieldValue; break;
case "FirmInstitution.AgreementNumber": firm.AgreementNumber = fieldValue; break;
case "FirmInstitution.NumeroTVAIntracommunautaire": firm.NumeroTVAIntracommunautaire = fieldValue; break;
case "FirmInstitution.ShareCapital": firm.ShareCapital = fieldValue; break;
case "FirmInstitution.RegisteredInRegister": firm.RegisteredInRegister = fieldValue; break;
case "FirmInstitution.RCS": firm.RCS = fieldValue; break;
case "FirmInstitution.SIRET": firm.SIRET = fieldValue; break;
case "FirmInstitution.SIREN": firm.SIREN = fieldValue; break;
case "FirmInstitution.Logo": firm.Logo = fieldValue; break;
case "FirmInstitution.LogoAlign": firm.LogoAlign = fieldValue; break;
case "FirmInstitution.LeaderCivility": firm.LeaderCivility = fieldValue; break;
case "FirmInstitution.LeaderName": firm.LeaderName = fieldValue; break;
case "FirmInstitution.LeaderFirstName": firm.LeaderFirstName = fieldValue; break;
case "FirmInstitution.LeaderBirthDay": firm.LeaderBirthDay = Convert.ToDateTime(fieldValue); break;
case "FirmInstitution.LeaderPlaceOfBirth": firm.LeaderPlaceOfBirth = fieldValue; break;
case "FirmInstitution.LeaderFormation": firm.LeaderFormation = fieldValue; break;
case "FirmInstitution.LeaderCursusProfessional": firm.LeaderCursusProfessional = fieldValue; break;
case "FirmInstitution.RelationshipReponsableFunction": firm.RelationshipReponsableFunction = fieldValue; break;
case "FirmInstitution.MediatorName": firm.MediatorName = fieldValue; break;
case "FirmInstitution.MediatorZipCode": firm.MediatorZipCode = fieldValue; break;
case "FirmInstitution.claimsAddress": firm.claimsAddress = fieldValue; break;
case "FirmInstitution.claimsName": firm.claimsName = fieldValue; break;
case "FirmInstitution.claimsTel": firm.claimsTel = fieldValue; break;
case "FirmInstitution.claimsFax": firm.claimsFax = fieldValue; break;
case "FirmInstitution.claimsMail": firm.claimsMail = fieldValue; break;
case "FirmInstitution.Agregateur": firm.Agregateur = (fieldValue == "1") ? true : false; break;
case "FirmInstitution.CreditCount": firm.CreditCount = Convert.ToInt32(fieldValue); break;
case "FirmInstitution.AgregateurNoms":
if (!string.IsNullOrEmpty(firm.AgregateurNoms))
{
List<string> lstAgregateurNoms = firm.AgregateurNoms.Split(new char[] { '|' }).ToList();
lstAgregateurNoms.Remove(string.Empty);
if (lstAgregateurNoms.Contains(fieldValue))
{
lstAgregateurNoms.Remove(fieldValue);
}
else
{
lstAgregateurNoms.Add(fieldValue);
}
fieldValue = string.Join("|", lstAgregateurNoms.ToArray());
}
firm.AgregateurNoms = fieldValue;
break;
case "FirmInstitution.AgregateurAutre": firm.AgregateurAutre = fieldValue; break;
case "FirmInstitution.LeaderFonction": firm.LeaderFonction = fieldValue; break;
case "FirmInstitution.LegalForm":
firm.LegalForm = fieldValue;
if (fieldValue != "AUTRE")
{
firm.LegalForm_Other = null;
}
break;
case "FirmInstitution.LegalForm_Other": firm.LegalForm_Other = fieldValue; break;
case "FirmInstitution.TeamPresentation": firm.TeamPresentation = fieldValue; break;
case "FirmInstitution.TeamWorkMethod": firm.TeamWorkMethod = fieldValue; break;
case "FirmInstitution.ConflictOfInterstSystem": firm.ConflictOfInterstSystem = fieldValue; break;
case "FirmInstitution.DocumentFooterContent":
if (firm.DocumentFooterContent != fieldValue)
{
firm.DocumentFooterContent = fieldValue;
firm.DocumentFooterUpdatedByUser = true; //changed by user ?
}
break;
case "FirmInstitution.DocumentFooterUpdatedByUser":
if (fieldValue == "0")
{
firm.DocumentFooterUpdatedByUser = false;
}
else
{
firm.DocumentFooterUpdatedByUser = true;
}
break;
case "FirmInstitution.PresentationFile": firm.PresentationFile = fieldValue; break;
case "FirmInstitution.LegalInformationFile": firm.LegalInformationFile = fieldValue; break; //DER
case "FirmInstitution.IdSponsor": firm.IdSponsor = Convert.ToInt32(fieldValue); break;
}
}
db.SaveChanges();
}
}
}
catch (Exception ex)
{
Log.Log.AppendException(ex);
firm = null;
throw new Exception("SavingError");
}
return firm;
}
public ActionResult Index([ModelBinder(typeof(DevExpressEditorsBinder))] FIDetailModel _firmInstitution)
{
#region old Code
//var FirmInstitutionSession = SessionManager.GetFirmInstitutionSession();
//_firmInstitution.FirmInstitution.User.idUser = _firmInstitution.FirmInstitution.idUserCreated.Value;
//var _user = Business.User.UserBL.GetUserById(_firmInstitution.FirmInstitution.User.idUser);
//if (!UserBL.IsEmailUsed(_user.UserEmail, _user))
//{
// _user.UserName = _firmInstitution.FirmInstitution.User.UserName;
// _user.UserFirstName = _firmInstitution.FirmInstitution.User.UserFirstName;
// _user.DateOfBirth = _firmInstitution.FirmInstitution.User.DateOfBirth;
// _user.PlaceOfBirth = _firmInstitution.FirmInstitution.User.PlaceOfBirth;
// _user.TrainingOfficer = _firmInstitution.FirmInstitution.User.TrainingOfficer;
// _user.ProfessionalExperience = _firmInstitution.FirmInstitution.User.ProfessionalExperience;
// Business.User.UserBL.UpdateUser(_user);
//}
#endregion
var currentFirm = _firmInstitution.FirmInstitution;
//Mise à jour des informations du FirmInstitution
if (currentFirm.LegalForm != "AUTRE")
{
currentFirm.LegalForm_Other = null;
}
FirmInstitution firmInstitution = FirmInstitutionBL.UpdateFirmInstitution(currentFirm);
// Mise à jour des informations de l'Association professionnelle
var _association = FirmInstitutionBL.GetFirmInstitutionProfessionalAssociation(_firmInstitution.FirmInstitution.idFirmInstitution);
if (_association == null)
{
_association = new FirmInstitutionProfessionalAssociation();
_association.idFirmInstitution = _firmInstitution.FirmInstitution.idFirmInstitution;
}
_association.idProfessionalAssociation = _firmInstitution.ProfessionalAssociation.idProfessionalAssociation;
_association.MembershipNumber = _firmInstitution.ProfessionalAssociation.MembershipNumber;
_association.HeadquartersAddress = _firmInstitution.ProfessionalAssociation.HeadquartersAddress;
_association.PostCode = _firmInstitution.ProfessionalAssociation.PostCode;
_association.City = _firmInstitution.ProfessionalAssociation.City;
_association.Website = _firmInstitution.ProfessionalAssociation.Website;
FirmInstitutionBL.UpdateFirmInstitutionProfessionalAssociation(_association);
//Remettre le firm selectionné en session pour refléter les maj.
SessionManager.SetSelectedFirmInstitutionSession(firmInstitution);
return Index();
}
