public static ag_upsideo_compte Updatecompte(ag_upsideo_compte compte)
{
using (UpsilabEntities context = new UpsilabEntities())
{
if (compte.Idfrontcompte <= 0)
{
context.ag_upsideo_compte.AddObject(compte);
}
else
{
var comptetoupdate = context.ag_upsideo_compte.Where(c => c.Idfrontcompte == compte.Idfrontcompte).FirstOrDefault();
comptetoupdate.designation = compte.designation;
comptetoupdate.numcompte = compte.numcompte;
comptetoupdate.pea = compte.pea;
comptetoupdate.NomTitulaire1 = compte.NomTitulaire1;
comptetoupdate.idfrontfournisseur = compte.idfrontfournisseur;
comptetoupdate.dds = compte.dds;
comptetoupdate.dateacquisition = compte.dateacquisition;
comptetoupdate.valeuracquisition = compte.valeuracquisition;
comptetoupdate.typecontrat = compte.typecontrat;
comptetoupdate.totalcompte = compte.totalcompte;
comptetoupdate.fiscalite = compte.fiscalite;
//foreach (var propinfo in compte.GetType().GetProperties())
//{
// var comptepropertyvalue = propinfo.GetValue(compte, null);
// propinfo.SetValue(comptetoupdate, comptepropertyvalue, null);
//}
}
context.SaveChanges();
return compte;
}
}
public static ag_upsideo_compte Addcompte(ag_upsideo_compte compte)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.ag_upsideo_compte.AddObject(compte);
context.SaveChanges();
return compte;
}
}
public static ag_upsideo_cptrelsupports UpdateFondCapitalRisque(Guid idcgp, ag_upsideo_compte compte, int qte, double prixunitaire)
{
using (UpsilabEntities db = new UpsilabEntities())
{
var cgp = db.ag_upsideo_cgp.FirstOrDefault(x => x.idcgp == idcgp);
if (cgp == null)
return null;
db.Connection.Open();
using (var dbContextTransaction = db.Connection.BeginTransaction())
{
var nomsupport = "Fond capital risque";
var referentiel = db.ag_upsideo_referentiel.FirstOrDefault(x => x.nomsupport == nomsupport);
ag_upsideo_cptrelsupports cptesupport = null;
ag_upsideo_support support = null;
try
{
//
//Referentiel
//
if (referentiel == null)
{
referentiel = new ag_upsideo_referentiel { nomsupport = nomsupport, idtypesupport = 1, datevl = DateTime.Now, vl = 0 };
db.ag_upsideo_referentiel.AddObject(referentiel);
db.SaveChanges();
}
//
//Support
//
support = db.ag_upsideo_support.FirstOrDefault(x =>
x.idrefsupport == referentiel.idrefsupport &&
x.idcrmcabinet == cgp.idcrmcabinet &&
x.idtypesupport == 1 &&
x.nomsupport == nomsupport &&
x.deleted == "n"
);
if (support == null)
{
support = new ag_upsideo_support
{
idrefsupport = referentiel.idrefsupport,
idcrmcabinet = cgp.idcrmcabinet,
idtypesupport = 1,
nomsupport = referentiel.nomsupport,
deleted = "n",
datevl = DateTime.Now,
vl = 0,
Performance12mois = 0,
Performance3112 = 0,
Performance60mois = 0,
Vleuro = 0,
Volatilite12mois = 0,
Volatilite60mois = 0
};
db.ag_upsideo_support.AddObject(support);
db.SaveChanges();
}
//
//Compte
//
if (compte.Idfrontcompte <= 0)
{
db.ag_upsideo_compte.AddObject(compte);
}
else
{
var tmpcompte = db.ag_upsideo_compte.FirstOrDefault(x => x.Idfrontcompte == compte.Idfrontcompte);
tmpcompte.designation = compte.designation;
tmpcompte.totalcompte = compte.totalcompte;
tmpcompte.dds = compte.dds;
}
db.SaveChanges();
//
//Support Compte
//
cptesupport = db.ag_upsideo_cptrelsupports.FirstOrDefault(x => x.Idfrontcompte == compte.Idfrontcompte && x.idfrontsupport ==
support.idfrontsupport);
if (cptesupport == null)
{
cptesupport = new ag_upsideo_cptrelsupports
{
datemaj = DateTime.Now,
Idfrontcompte = compte.Idfrontcompte,
idfrontsupport = support.idfrontsupport,
pru = prixunitaire,
qte = qte
};
db.ag_upsideo_cptrelsupports.AddObject(cptesupport);
db.SaveChanges();
}
else
{
cptesupport.pru = prixunitaire;
cptesupport.qte = qte;
db.SaveChanges();
}
//
//
//
dbContextTransaction.Commit();
return cptesupport;
}
catch (Exception e)
{
dbContextTransaction.Rollback();
Log.Log.AppendException(e);
throw new Exception("SavingError");
}
}
}
}
//
// GET: /AgregInitialiseRevenus/
public string Index()
{
try
{
using (UpsilabEntities context = new UpsilabEntities())
{
// liste CustomerProspect
List<CustomerProspect> customers = CustomerProspectBL.GetCustomerProspectList(context);
Report report = null;
Report reportValues = null;
Guid idClient = Guid.Empty;
List<ReportOptionAttributeValue> listeReportImmoJouissance = null;
List<ReportOptionAttributeValue> listeReportImmoRapport = null;
List<ReportOptionAttributeValue> listeReportProfessionnel = null;
//boucle sur les clients
Guid currentAgregClientId = Guid.Empty;
foreach (CustomerProspect cp in customers)
{
//teste si client existe dans agreg si non on ajoute et maj customer -- ou ne rien faire
currentAgregClientId = cp.idAgregClient.HasValue ? cp.idAgregClient.Value : Guid.Empty;
if (!cp.idAgregClient.HasValue)
{
ag_upsideo_client agregClientToAdd = new ag_upsideo_client()
{
idclient = Guid.NewGuid(),
idcgp = cp.User1.idAgregCGP.Value,
nomclient = cp.User.UserName,
prenomclient = cp.User.UserFirstName,
adr = cp.Adress,
cp = cp.ZipCode,
ville = cp.City,
titre = cp.Title,
ddn = DateTime.Now,
deleted = "n"
};
context.ag_upsideo_client.AddObject(agregClientToAdd);
cp.idAgregClient = agregClientToAdd.idclient;
currentAgregClientId = agregClientToAdd.idclient;
}
//------------------
//Fournisseur de l'actif : comme il s'agit de données provenant du "Recueil/LAB", mettre "UPSIDEO" comme fournisseur fictif (pour chaque cabinet / etablissement)
//Get fournisseur
Guid idAgregCabinet = cp.FirmInstitution.ag_upsideo_cabinet.idcrmcabinet;
ag_upsideo_fournisseur agregFournisseur = context.ag_upsideo_fournisseur.Where(f => f.idcrmcabinet == cp.FirmInstitution.ag_upsideo_cabinet.idcrmcabinet
&& f.nomfournisseur == Business.Agreg.agupsideocompteBL.FournisseurUpsideo).FirstOrDefault();
if (agregFournisseur == null)
{
agregFournisseur = new ag_upsideo_fournisseur()
{
idcrmcabinet = idAgregCabinet,
nomfournisseur = Business.Agreg.agupsideocompteBL.FournisseurUpsideo,
cleAgreg = Business.Agreg.agupsideocompteBL.FournisseurUpsideo.ToLower(),
deleted = "n",
};
//TODO : to delete : normalement à faire lors de la souscription mais garder ce code pour test
//Insertion fournisseur avec un autre contexte
using (UpsilabEntities dbTemp = new UpsilabEntities())
{
dbTemp.ag_upsideo_fournisseur.AddObject(agregFournisseur);
dbTemp.SaveChanges();
}
}
//------------------
// obtenir le dernier repport pour chaque client (customerprospect)
report = new Report();
report = ReportBL.GetLatestReportByIdCustomerProspect(cp.idCustomer);
if (report != null)
{
//obtenir les donnés de report
reportValues = new Report();
reportValues = ReportBL.GetReportWithValues(report.idReport);
//obtenir ReportOptionAttributeValue
// idOptionAttribute = 204 (1. Immobilier de jouissance (résidence principale, résidence secondaire, terrain à bâtir ou non, etc.)
// idOptionAttribute = 205 (2. Immobilier de rapport (location, SICAFI, SIR, certificats immobiliers, sociétés immobilières, etc.)
// idOptionAttribute = 206 (c) Patrimoine professionnel (parts sociales, clientèle, fonds de commerce), compte courant, compte d’associé)
listeReportImmoJouissance = new List<ReportOptionAttributeValue>();
listeReportImmoRapport = new List<ReportOptionAttributeValue>();
listeReportProfessionnel = new List<ReportOptionAttributeValue>();
if (reportValues.ReportOptionAttributeValue != null && reportValues.ReportOptionAttributeValue.Count > 0)
{
listeReportImmoJouissance = reportValues.ReportOptionAttributeValue.Where(r => r.idOptionAttribute == 204).ToList();
listeReportImmoRapport = reportValues.ReportOptionAttributeValue.Where(r => r.idOptionAttribute == 205).ToList();
listeReportProfessionnel = reportValues.ReportOptionAttributeValue.Where(r => r.idOptionAttribute == 206).ToList();
dynamic customData = null;
string numcompteFictif = string.Empty;
int ligneImmoJ = 0;
int ligneImmoR = 0;
int lignePro = 0;
foreach (ReportOptionAttributeValue roav in listeReportImmoJouissance)
{
//les valeur dans receuil lab
customData = roav.CustomObjectValue;
//clé de maj pour les revenus dans la table ag_upsideo_compte
numcompteFictif = string.Format("{0}_{1}", roav.idOptionAttribute.ToString(), ligneImmoJ.ToString());
//pour tester les revenus
if (customData.Values["Description"] != null && customData.Values["Description"] != "")
{
//teste si existe déjà (maj) si no new
ag_upsideo_compte currentCompte = context.ag_upsideo_compte.Where(c => c.idclient == currentAgregClientId && c.numcompte == numcompteFictif).FirstOrDefault();
//update
if (currentCompte != null)
{
currentCompte.designation = customData.Values["Description"];
currentCompte.dateacquisition = customData.Values["AcquisitionDate"] != "" ? Convert.ToDateTime(customData.Values["AcquisitionDate"]) : null;
currentCompte.valeuracquisition = customData.Values["AcquisitionValue"] != "" ? Convert.ToDouble(customData.Values["AcquisitionValue"]) : null;
currentCompte.totalcompte = customData.Values["CurrentValue"] != "" ? Convert.ToDouble(customData.Values["CurrentValue"]) : null;
currentCompte.idfrontfournisseur = agregFournisseur.idfrontfournisseur;
currentCompte.type = "n"; //non gere
}
//new
else
{
currentCompte = new ag_upsideo_compte()
{
idclient = currentAgregClientId,
idcgp = cp.User1.idAgregCGP.Value,
idfrontfournisseur = agregFournisseur.idfrontfournisseur,
numcompte = numcompteFictif,
typecontrat = "bien immobilier",
deleted = "n",
designation = customData.Values["Description"],
dateacquisition = customData.Values["AcquisitionDate"] != "" ? Convert.ToDateTime(customData.Values["AcquisitionDate"]) : null,
valeuracquisition = customData.Values["AcquisitionValue"] != "" ? Convert.ToDouble(customData.Values["AcquisitionValue"]) : null,
totalcompte = customData.Values["CurrentValue"] != "" ? Convert.ToDouble(customData.Values["CurrentValue"]) : null,
type = "n", //non gere
};
context.ag_upsideo_compte.AddObject(currentCompte);
}
}
ligneImmoJ = ligneImmoJ + 1;
}
foreach (ReportOptionAttributeValue roav in listeReportImmoRapport)
{
customData = roav.CustomObjectValue;
numcompteFictif = string.Format("{0}_{1}", roav.idOptionAttribute.ToString(), ligneImmoR.ToString());
//pour tester les revenus
if (customData.Values["Description"] != null && customData.Values["Description"] != "")
{
//teste si existe déjà (maj) si no new
ag_upsideo_compte currentCompte = context.ag_upsideo_compte.Where(c => c.idclient == currentAgregClientId && c.numcompte == numcompteFictif).FirstOrDefault();
if (currentCompte != null)
{
currentCompte.designation = customData.Values["Description"];
currentCompte.dateacquisition = customData.Values["AcquisitionDate"] != "" ? Convert.ToDateTime(customData.Values["AcquisitionDate"]) : null;
currentCompte.valeuracquisition = customData.Values["AcquisitionValue"] != "" ? Convert.ToDouble(customData.Values["AcquisitionValue"]) : null;
currentCompte.totalcompte = customData.Values["CurrentValue"] != "" ? Convert.ToDouble(customData.Values["CurrentValue"]) : null;
currentCompte.idfrontfournisseur = agregFournisseur.idfrontfournisseur;
currentCompte.type = "n"; //non gere
}
else
{
currentCompte = new ag_upsideo_compte()
{
idclient = currentAgregClientId,
idcgp = cp.User1.idAgregCGP.Value,
idfrontfournisseur = agregFournisseur.idfrontfournisseur,
numcompte = numcompteFictif,
typecontrat = "bien immobilier",
deleted = "n",
designation = customData.Values["Description"],
dateacquisition = customData.Values["AcquisitionDate"] != "" ? Convert.ToDateTime(customData.Values["AcquisitionDate"]) : null,
valeuracquisition = customData.Values["AcquisitionValue"] != "" ? Convert.ToDouble(customData.Values["AcquisitionValue"]) : null,
totalcompte = customData.Values["CurrentValue"] != "" ? Convert.ToDouble(customData.Values["CurrentValue"]) : null,
type = "n", //non gere
};
context.ag_upsideo_compte.AddObject(currentCompte);
}
}
ligneImmoR = ligneImmoR + 1;
}
foreach (ReportOptionAttributeValue roav in listeReportProfessionnel)
{
customData = roav.CustomObjectValue;
numcompteFictif = string.Format("{0}_{1}", roav.idOptionAttribute.ToString(), lignePro.ToString());
//pour tester les revenus
if (customData.Values["Description"] != null && customData.Values["Description"] != "")
{
double capital = 0;
double.TryParse(customData.Values["OwnedCapital"], out capital);
//teste si existe déjà (maj) si no new
ag_upsideo_compte currentCompte = context.ag_upsideo_compte.Where(c => c.idclient == currentAgregClientId && c.numcompte == numcompteFictif).FirstOrDefault();
if (currentCompte != null)
{
currentCompte.designation = customData.Values["Description"];
currentCompte.totalcompte = customData.Values["OwnedCapital"] != "" ? capital : (double?)null;
currentCompte.idfrontfournisseur = agregFournisseur.idfrontfournisseur;
currentCompte.type = "n"; //non gere
}
else
{
currentCompte = new ag_upsideo_compte()
{
idclient = currentAgregClientId,
idcgp = cp.User1.idAgregCGP.Value,
idfrontfournisseur = agregFournisseur.idfrontfournisseur,
numcompte = numcompteFictif,
typecontrat = "professionels",
deleted = "n",
designation = customData.Values["Description"],
totalcompte = customData.Values["OwnedCapital"] != "" ? capital : (double?)null,
type = "n", //non gere
};
context.ag_upsideo_compte.AddObject(currentCompte);
}
}
lignePro = lignePro + 1;
}
}
}
}
context.SaveChanges();
}
}
catch (Exception ex)
{
Upsilab.Business.Log.Log.AppendException(ex);
return "Erreur : " + ex.Message;
}
return "OK";
}
/// <summary>
///
/// </summary>
/// <param name="reportIdDest"></param>
/// <param name="lstReportOptionValuesSource"></param>
public static int SaveReportOptionValue(Guid idReport, Upsilab.Data.Model.Option option, int idOptionAttribute, string value, string fieldType, string colomnName, int? lineNumber)
{
ReportOptionAttributeValue optionAttributeValue2 = null;
int idOption = option.idOption;
bool updateDateUpdated = false;
string completedStatus = Report.ReportBL.Status.Completed.ToString();
string waitingForClientUpdateStatus = Report.ReportBL.Status.WaitingForClientUpdate.ToString();
//Insert new OptionValue
using (UpsilabEntities db = new UpsilabEntities())
{
//Get current report
Data.Model.Report report = (from rep in db.Report
where rep.idReport == idReport
select rep).FirstOrDefault();
//Check if customer has completed report
var checkCompletedReport = (from rep in db.Report
where rep.CustomerProspect.idCustomer == report.CustomerProspect.idCustomer
&& rep.Status == completedStatus
select rep).FirstOrDefault();
if (checkCompletedReport != null)
{
updateDateUpdated = true;
}
//#9262 : Check if customer changes the info after Adviser request
if (!updateDateUpdated)
{
if (report.Status == waitingForClientUpdateStatus && SessionManager.GetUserSession().IsEndUser())
{
updateDateUpdated = true;
}
}
#region TEXTBOX, DROPDOWN : txt, dt, enum
//1- Save option attribute value (simple textbox / textarea)
if (fieldType == "txt" || fieldType == "dt" || fieldType == "enum")
{
ReportOptionAttributeValue optionAttributeValue = (from roav in db.ReportOptionAttributeValue.Include("ReportOptionValue")
where roav.idReport == idReport && roav.idOptionAttribute == idOptionAttribute
select roav).FirstOrDefault();
if (optionAttributeValue != null)
{
if (optionAttributeValue.Value != value) //update if not equal
{
optionAttributeValue.Value = value;
optionAttributeValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
optionAttributeValue.ReportOptionValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
}
else
{
//Do nothing if equal
}
optionAttributeValue2 = optionAttributeValue;
}
else if (!string.IsNullOrEmpty(value)) //Insert if value is not empty
{
//Check if reportOptionValue exists
ReportOptionValue optionValue = (from rov in db.ReportOptionValue
where rov.idReport == idReport && rov.idOption == idOption
select rov).FirstOrDefault();
if (optionValue == null) //insert option value
{
optionValue = new ReportOptionValue()
{
idReport = idReport,
idOption = idOption,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(optionValue);
//Insert parent
while (option.idParent.HasValue)
{
ReportOptionValue optionParentValue = (from rov in db.ReportOptionValue.Include("Option")
where rov.idReport == idReport && rov.idOption == option.idParent
select rov).FirstOrDefault();
if (optionParentValue == null)
{
optionParentValue = new ReportOptionValue()
{
idReport = idReport,
idOption = option.idParent.Value,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(optionParentValue);
//Check if this parent option has already parent ?
option = optionParentValue.Option;
}
else
{
optionParentValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
break;
}
}
}
//Insert optionattrubutevalue
ReportOptionAttributeValue newReportOptionAttributeValue = new ReportOptionAttributeValue()
{
idReport = idReport,
idOptionAttribute = idOptionAttribute,
idReportOptionValue = optionValue.idReportOptionValue,
Value = value,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionAttributeValue to DB : don't save yet
optionValue.ReportOptionAttributeValue.Add(newReportOptionAttributeValue);
optionAttributeValue2 = newReportOptionAttributeValue;
}
}
#endregion
#region RADIO BUTTON : rb
//2- Save option attribute value (Radio button)
else if (fieldType == "rb")
{
//Delete old rb
IList<ReportOptionValue> optionValues = (from rov in db.ReportOptionValue.Include("ReportOptionAttributeValue")
where rov.idReport == idReport && rov.Option.idParent == option.idParent
select rov).ToList();
//Delete option attribute values attached to option value
if (optionValues != null)
{
foreach (var optionValue in optionValues)
{
IList<ReportOptionAttributeValue> lstOptionAttributeValues = new List<ReportOptionAttributeValue>(optionValue.ReportOptionAttributeValue);
foreach (var item in lstOptionAttributeValues)
{
var optionAttrValueToBeDel = optionValue.ReportOptionAttributeValue.Where(oa => oa.idReportOptionAttributeValue == item.idReportOptionAttributeValue).FirstOrDefault();
db.ReportOptionAttributeValue.DeleteObject(optionAttrValueToBeDel);
}
db.ReportOptionValue.DeleteObject(optionValue);
//Delete child option value
IList<ReportOptionValue> lstOptionValuesChild = (from rov in db.ReportOptionValue.Include("ReportOptionAttributeValue")
where rov.idReport == idReport && rov.Option.idParent == optionValue.idOption
select rov).ToList();
if (lstOptionValuesChild != null)
{
foreach (var optionValueChild in lstOptionValuesChild)
{
lstOptionAttributeValues = new List<ReportOptionAttributeValue>(optionValueChild.ReportOptionAttributeValue);
foreach (var item in lstOptionAttributeValues)
{
var optionAttrValueToBeDel = optionValueChild.ReportOptionAttributeValue.Where(oa => oa.idReportOptionAttributeValue == item.idReportOptionAttributeValue).FirstOrDefault();
db.ReportOptionAttributeValue.DeleteObject(optionAttrValueToBeDel);
}
db.ReportOptionValue.DeleteObject(optionValueChild);
}
}
}
}
if (!string.IsNullOrEmpty(value) && value.ToLower() == "true")
{
//Insert new rb
ReportOptionValue newOptionValue = new ReportOptionValue()
{
idReport = idReport,
idOption = idOption,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(newOptionValue);
//Insert parent ??
while (option.idParent.HasValue)
{
ReportOptionValue optionParentValue = (from rov in db.ReportOptionValue.Include("Option")
where rov.idReport == idReport && rov.idOption == option.idParent
select rov).FirstOrDefault();
if (optionParentValue == null)
{
optionParentValue = new ReportOptionValue()
{
idReport = idReport,
idOption = option.idParent.Value,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(optionParentValue);
//Check if this parent option has already parent ?
option = optionParentValue.Option;
}
else
{
optionParentValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
break;
}
}
}
}
#endregion
#region CHECKBOX : chk
//3- Save option attribute value (Checkbox)
else if (fieldType == "chk")
{
ReportOptionValue optionValue;
if (value == "false")
{
//Delete old chk
optionValue = (from rov in db.ReportOptionValue.Include("ReportOptionAttributeValue")
where rov.idReport == idReport && rov.idOption == idOption
select rov).FirstOrDefault();
//Delete option attribute values attached to option value
if (optionValue != null)
{
IList<ReportOptionAttributeValue> lstOptionAttributeValues = new List<ReportOptionAttributeValue>(optionValue.ReportOptionAttributeValue);
foreach (var item in lstOptionAttributeValues)
{
var optionAttrValueToBeDel = optionValue.ReportOptionAttributeValue.Where(oa => oa.idReportOptionAttributeValue == item.idReportOptionAttributeValue).FirstOrDefault();
db.ReportOptionAttributeValue.DeleteObject(optionAttrValueToBeDel);
}
db.ReportOptionValue.DeleteObject(optionValue);
//Delete child option value
IList<ReportOptionValue> lstOptionValuesChild = (from rov in db.ReportOptionValue.Include("ReportOptionAttributeValue")
where rov.idReport == idReport && rov.Option.idParent == optionValue.idOption
select rov).ToList();
if (lstOptionValuesChild != null)
{
foreach (var optionValueChild in lstOptionValuesChild)
{
lstOptionAttributeValues = new List<ReportOptionAttributeValue>(optionValueChild.ReportOptionAttributeValue);
foreach (var item in lstOptionAttributeValues)
{
var optionAttrValueToBeDel = optionValueChild.ReportOptionAttributeValue.Where(oa => oa.idReportOptionAttributeValue == item.idReportOptionAttributeValue).FirstOrDefault();
db.ReportOptionAttributeValue.DeleteObject(optionAttrValueToBeDel);
}
db.ReportOptionValue.DeleteObject(optionValueChild);
}
}
}
}
else if (value == "true")
{
//Insert new chk
optionValue = new ReportOptionValue()
{
idReport = idReport,
idOption = idOption,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(optionValue);
//Insert parent ??
while (option.idParent.HasValue)
{
ReportOptionValue optionParentValue = (from rov in db.ReportOptionValue.Include("Option")
where rov.idReport == idReport && rov.idOption == option.idParent
select rov).FirstOrDefault();
if (optionParentValue == null)
{
optionParentValue = new ReportOptionValue()
{
idReport = idReport,
idOption = option.idParent.Value,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(optionParentValue);
//Check if this parent option has already parent ?
option = optionParentValue.Option;
}
else
{
optionParentValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
break;
}
}
}
}
#endregion
#region CUSTOM DATATYPE
//4- Custom datatype
else
{
//pour agreg
ReportOptionAttributeValue agregOptionAttributeValue = null;
//
ReportOptionValue optionValue = (from rov in db.ReportOptionValue.Include("ReportOptionAttributeValue")
where rov.idReport == idReport && rov.idOption == idOption
select rov).FirstOrDefault();
IList<ReportOptionAttributeValue> lstOptionAttributeValues = new List<ReportOptionAttributeValue>();
//Option value ?
if (optionValue != null)
{
lstOptionAttributeValues = new List<ReportOptionAttributeValue>(optionValue.ReportOptionAttributeValue);
lstOptionAttributeValues = lstOptionAttributeValues.Where(oav => oav.idOptionAttribute == idOptionAttribute).ToList();
}
else if (!string.IsNullOrEmpty(value))
{
optionValue = new ReportOptionValue()
{
idReport = idReport,
idOption = idOption,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(optionValue);
//Insert parent
while (option.idParent.HasValue)
{
ReportOptionValue optionParentValue = (from rov in db.ReportOptionValue.Include("Option")
where rov.idReport == idReport && rov.idOption == option.idParent
select rov).FirstOrDefault();
if (optionParentValue == null)
{
optionParentValue = new ReportOptionValue()
{
idReport = idReport,
idOption = option.idParent.Value,
Value = string.Empty,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
//Add ReportOptionValue to DB : don't save yet
db.ReportOptionValue.AddObject(optionParentValue);
//Check if this parent option has already parent ?
option = optionParentValue.Option;
}
else
{
optionParentValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
break;
}
}
}
//Get target option attribute
if (lineNumber.HasValue && lineNumber.Value < lstOptionAttributeValues.Count)
{
//Line already in database
ReportOptionAttributeValue reportOptionAttrValue = lstOptionAttributeValues[lineNumber.Value];
dynamic customData = reportOptionAttrValue.CustomObjectValue;
if (customData != null)
{
bool isTheSameValue = CustomObject.IsTheSameValue(customData, colomnName, value);
if (!isTheSameValue)
{
CustomObject.SetValueByPropertyName(customData, colomnName, value);
reportOptionAttrValue.CustomObjectValue = customData;
reportOptionAttrValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
reportOptionAttrValue.ReportOptionValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
//pour agreg
agregOptionAttributeValue = reportOptionAttrValue;
//
}
}
optionAttributeValue2 = reportOptionAttrValue;
}
else
{
//Get Custom datatype columns
List<string> customAttribute = OptionBL.GetCustomAttributeNames(fieldType);
if (customAttribute.Count > 0)
{
dynamic customData = new Upsilab.Data.Model.CustomObject();
dynamic customDataEmpty = new Upsilab.Data.Model.CustomObject();
foreach (string itemColumnName in customAttribute)
{
string _strVal = string.Empty;
if (itemColumnName == colomnName)
{
_strVal = value;
}
CustomObject.SetValueByPropertyName(customData, itemColumnName, _strVal);
CustomObject.SetValueByPropertyName(customDataEmpty, itemColumnName, string.Empty);
}
ReportOptionAttributeValue optionAttributeValue = null;
bool createOptionAttr = true;
if (!lineNumber.HasValue && lstOptionAttributeValues.Count > 0)
{
createOptionAttr = false;
optionAttributeValue = optionValue.ReportOptionAttributeValue.Where(oav => oav.idOptionAttribute == idOptionAttribute).FirstOrDefault();
optionAttributeValue2 = optionAttributeValue;
}
else if (lineNumber.HasValue)
{
//Create empty lines
// while (lstOptionAttributeValues.Count < lineNumber.Value)
{
optionAttributeValue = new ReportOptionAttributeValue()
{
idReport = idReport,
idOptionAttribute = idOptionAttribute,
idReportOptionValue = optionValue.idReportOptionValue,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
optionAttributeValue.CustomObjectValue = customDataEmpty;
lstOptionAttributeValues.Add(optionAttributeValue);
optionValue.ReportOptionAttributeValue.Add(optionAttributeValue);
}
}
//if (optionAttributeValue == null)
if (createOptionAttr)
{
//Add new line
//Insert optionattrubutevalue
optionAttributeValue = new ReportOptionAttributeValue()
{
idReport = idReport,
idOptionAttribute = idOptionAttribute,
idReportOptionValue = optionValue.idReportOptionValue,
DateCreated = DateTime.Now,
DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null
};
optionAttributeValue.CustomObjectValue = customData;
//pour agreg
agregOptionAttributeValue = optionAttributeValue;
optionAttributeValue2 = agregOptionAttributeValue;
//
}
else
{
customData = optionAttributeValue.CustomObjectValue;
if (customData != null)
{
bool isTheSameValue = CustomObject.IsTheSameValue(customData, colomnName, value);
if (!isTheSameValue)
{
CustomObject.SetValueByPropertyName(customData, colomnName, value);
optionAttributeValue.CustomObjectValue = customData;
optionAttributeValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
optionAttributeValue.ReportOptionValue.DateUpdated = (updateDateUpdated) ? DateTime.Now : (DateTime?)null;
//pour agreg
agregOptionAttributeValue = optionAttributeValue;
//
}
}
}
//Add ReportOptionAttributeValue to DB : don't save yet
optionValue.ReportOptionAttributeValue.Add(optionAttributeValue);
optionAttributeValue2 = optionAttributeValue;
}
}
#region Save patrimoine from Recueil/lab to Agregateur
//update/add ag_upsideo_compte
//if (report.CustomerProspect.User1.idLicenseAgreg.HasValue && report.CustomerProspect.User1.idAgregCGP.HasValue
// && (idOptionAttribute == 204 || idOptionAttribute == 205 || idOptionAttribute == 206)
// && report.CustomerProspect.FirmInstitution.ag_upsideo_cabinet != null)
if (report.CustomerProspect.User1.HasAggregatorLicense() && report.CustomerProspect.User1.idAgregCGP.HasValue
&& (idOptionAttribute == 204 || idOptionAttribute == 205 || idOptionAttribute == 206)
&& report.CustomerProspect.FirmInstitution.ag_upsideo_cabinet != null)
{
//Les ids en cours : agregCabinet, agregCGP et agregClient
Guid idAgregCGP = report.CustomerProspect.User1.idAgregCGP.Value;
Guid idAgregCabinet = report.CustomerProspect.FirmInstitution.ag_upsideo_cabinet.idcrmcabinet;
Guid currentAgregClientId = Guid.Empty;
if (report.CustomerProspect.idAgregClient.HasValue)
{
currentAgregClientId = report.CustomerProspect.idAgregClient.Value;
}
else
{
ag_upsideo_client clientAgregToAdd = new ag_upsideo_client()
{
idclient = Guid.NewGuid(),
idcgp = idAgregCGP,
nomclient = report.CustomerProspect.User.UserName,
prenomclient = report.CustomerProspect.User.UserFirstName,
adr = report.CustomerProspect.Adress,
cp = report.CustomerProspect.ZipCode,
ville = report.CustomerProspect.City,
titre = report.CustomerProspect.Title,
ddn = DateTime.Now,
deleted = "n"
};
db.ag_upsideo_client.AddObject(clientAgregToAdd);
report.CustomerProspect.idAgregClient = clientAgregToAdd.idclient;
currentAgregClientId = clientAgregToAdd.idclient;
}
//Fournisseur de l'actif : comme il s'agit de données provenant du "Recueil/LAB", mettre "UPSIDEO" comme fournisseur fictif (pour chaque cabinet / etablissement)
//Get fournisseur
ag_upsideo_fournisseur agregFournisseur = db.ag_upsideo_fournisseur.Where(f => f.idcrmcabinet == report.CustomerProspect.FirmInstitution.ag_upsideo_cabinet.idcrmcabinet
&& f.nomfournisseur == Business.Agreg.agupsideocompteBL.FournisseurUpsideo).FirstOrDefault();
if (agregFournisseur == null)
{
agregFournisseur = new ag_upsideo_fournisseur()
{
idcrmcabinet = idAgregCabinet,
nomfournisseur = Business.Agreg.agupsideocompteBL.FournisseurUpsideo,
cleAgreg = Business.Agreg.agupsideocompteBL.FournisseurUpsideo.ToLower(),
deleted = "n",
};
//TODO : to delete : normalement à faire lors de la souscription mais garder ce code pour test
//Insertion fournisseur avec un autre contexte
using (UpsilabEntities dbTemp = new UpsilabEntities())
{
dbTemp.ag_upsideo_fournisseur.AddObject(agregFournisseur);
dbTemp.SaveChanges();
}
}
//num compte fictif dans table compte Agreg
string numCompteFictif = string.Empty;
numCompteFictif = string.Format("{0}_{1}", idOptionAttribute.ToString(), lineNumber.Value.ToString());
//teste si existe déjà (maj) si no new
ag_upsideo_compte currentCompte = db.ag_upsideo_compte.Where(c => c.idclient == currentAgregClientId && c.numcompte == numCompteFictif).FirstOrDefault();
//maj
if (currentCompte != null && agregOptionAttributeValue != null)
{
switch (idOptionAttribute)
{
case 204:
case 205:
{
currentCompte.designation = agregOptionAttributeValue.CustomObjectValue.Values["Description"];
currentCompte.dateacquisition = agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionDate"] != "" ? Convert.ToDateTime(agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionDate"]) : null;
currentCompte.valeuracquisition = agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionValue"] != "" ? Convert.ToDouble(agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionValue"]) : null;
currentCompte.totalcompte = agregOptionAttributeValue.CustomObjectValue.Values["CurrentValue"] != "" ? Convert.ToDouble(agregOptionAttributeValue.CustomObjectValue.Values["CurrentValue"]) : null;
currentCompte.idfrontfournisseur = agregFournisseur.idfrontfournisseur;
currentCompte.type = "n"; //pour l'instant : non géré
}
break;
case 206:
currentCompte.designation = agregOptionAttributeValue.CustomObjectValue.Values["Description"];
currentCompte.totalcompte = agregOptionAttributeValue.CustomObjectValue.Values["OwnedCapital"] != "" ? Convert.ToDouble(agregOptionAttributeValue.CustomObjectValue.Values["OwnedCapital"]) : null;
currentCompte.idfrontfournisseur = agregFournisseur.idfrontfournisseur;
currentCompte.type = "n"; //pour l'instant : non géré
break;
default:
break;
}
}
//new
else if (currentCompte == null && agregOptionAttributeValue != null)
{
switch (idOptionAttribute)
{
case 204:
case 205:
{
currentCompte = new ag_upsideo_compte()
{
idclient = currentAgregClientId,
idcgp = report.CustomerProspect.User1.idAgregCGP.Value,
idfrontfournisseur = agregFournisseur.idfrontfournisseur,
numcompte = numCompteFictif,
typecontrat = "bien immobilier",
deleted = "n",
designation = agregOptionAttributeValue.CustomObjectValue.Values["Description"],
dateacquisition = agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionDate"] != "" ? Convert.ToDateTime(agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionDate"]) : null,
valeuracquisition = agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionValue"] != "" ? Convert.ToDouble(agregOptionAttributeValue.CustomObjectValue.Values["AcquisitionValue"]) : null,
totalcompte = agregOptionAttributeValue.CustomObjectValue.Values["CurrentValue"] != "" ? Convert.ToDouble(agregOptionAttributeValue.CustomObjectValue.Values["CurrentValue"]) : null
};
if (!string.IsNullOrEmpty(agregOptionAttributeValue.CustomObjectValue.Values["Description"]))
{
db.ag_upsideo_compte.AddObject(currentCompte);
}
}
break;
case 206:
{
currentCompte = new ag_upsideo_compte()
{
idclient = currentAgregClientId,
idcgp = report.CustomerProspect.User1.idAgregCGP.Value,
idfrontfournisseur = agregFournisseur.idfrontfournisseur,
numcompte = numCompteFictif,
typecontrat = "professionels",
deleted = "n",
designation = agregOptionAttributeValue.CustomObjectValue.Values["Description"],
totalcompte = agregOptionAttributeValue.CustomObjectValue.Values["OwnedCapital"] != "" ? Convert.ToDouble(agregOptionAttributeValue.CustomObjectValue.Values["OwnedCapital"]) : null
};
if (!string.IsNullOrEmpty(agregOptionAttributeValue.CustomObjectValue.Values["Description"]))
{
db.ag_upsideo_compte.AddObject(currentCompte);
}
}
break;
default:
break;
}
}
}
#endregion
}
#endregion
#region Report
//5- Update dateupdated report
report.DateUpdated = DateTime.Now;
#endregion
//6- Commit all changes here
db.SaveChanges();
return optionAttributeValue2!=null ? optionAttributeValue2.idReportOptionAttributeValue : 0;
}
}
public ActionResult UpdateCompte(string jsondata)
{
var compteeditvm = new JavaScriptSerializer().Deserialize<AgregCompteEditVM>(jsondata);
Guid idClient = Guid.Empty;
SessionManager.Get<Guid>(agupsideocompteBL.AgregClientIdSessionKey, out idClient);
Guid idCgpAgreg = Guid.Empty;
User currentUser = SessionManager.GetUserSession();
if (currentUser.IsEndUser())
{
CustomerProspect currentCustomer = SessionManager.GetCustomerProspectSession();
User currenttUserCreated = currentCustomer.User1;
idCgpAgreg = currenttUserCreated.idAgregCGP.Value;
}
else
{
idCgpAgreg = currentUser.idAgregCGP.Value;
}
ag_upsideo_compte comptedb = null;
var agregcompte = new AgregCompteViewModel();
List<SqlAgregCompteModel> lstCompte = null;
try
{
if (compteeditvm.Idfrontcompte <= 0)
{
comptedb = new ag_upsideo_compte();
comptedb.idclient = idClient;
comptedb.idcgp = idCgpAgreg;
comptedb.deleted = "n";
}
else
{
comptedb = agupsideocompteBL.GetComptesByIdCompte(compteeditvm.Idfrontcompte);
}
//
//
//
comptedb.typecontrat = compteeditvm.typecontrat;
comptedb.Idfrontcompte = compteeditvm.Idfrontcompte;
comptedb.type = "o";
if (compteeditvm.typecontrat.ToLower() == agupsideocompteBL.comptetitrespea.ToLower() ||
compteeditvm.typecontrat.ToLower() == agupsideocompteBL.capitalisation.ToLower())
{
comptedb.pea = compteeditvm.pea.ToLower() == "true" ? "o" : "n";
comptedb.numcompte = compteeditvm.numcompte;
comptedb.NomTitulaire1 = compteeditvm.NomTitulaire1;
comptedb.idfrontfournisseur = compteeditvm.idfrontfournisseur;
if (!string.IsNullOrEmpty(compteeditvm.dds))
{
comptedb.dds = DateTime.ParseExact(compteeditvm.dds, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
else
{
comptedb.dds = null;
}
//
//
//
comptedb = agupsideocompteBL.Updatecompte(comptedb);
lstCompte = agupsideocompteBL.GetComptesClient(idClient);
agregcompte.AgregCompteContrat = lstCompte.Where(c => c.Typecontrat.ToLower() == agupsideocompteBL.assurancevie.ToLower()
|| c.Typecontrat.ToLower() == agupsideocompteBL.comptetitrespea.ToLower()
|| c.Typecontrat.ToLower() == agupsideocompteBL.capitalisation.ToLower()
|| c.Typecontrat.ToLower() == agupsideocompteBL.comptebancaire.ToLower()
).ToList();
//historisé 9711
agupsideocompteBL.AddCompteHisto(comptedb);
return PartialView("ComptesContratsPartial", agregcompte);
}
if (compteeditvm.typecontrat.ToLower() == agupsideocompteBL.assurancevie.ToLower() ||
compteeditvm.typecontrat.ToLower() == agupsideocompteBL.comptebancaire.ToLower())
{
comptedb.numcompte = compteeditvm.numcompte;
comptedb.NomTitulaire1 = compteeditvm.NomTitulaire1;
comptedb.idfrontfournisseur = compteeditvm.idfrontfournisseur;
if (!string.IsNullOrEmpty(compteeditvm.dds))
{
comptedb.dds = DateTime.ParseExact(compteeditvm.dds, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
else
{
comptedb.dds = null;
}
//
//
//
comptedb = agupsideocompteBL.Updatecompte(comptedb);
lstCompte = agupsideocompteBL.GetComptesClient(idClient);
agregcompte.AgregCompteContrat = lstCompte.Where(c => c.Typecontrat.ToLower() == agupsideocompteBL.assurancevie.ToLower()
|| c.Typecontrat.ToLower() == agupsideocompteBL.comptetitrespea.ToLower()
|| c.Typecontrat.ToLower() == agupsideocompteBL.capitalisation.ToLower()
|| c.Typecontrat.ToLower() == agupsideocompteBL.comptebancaire.ToLower()
).ToList();
//historisé 9711
agupsideocompteBL.AddCompteHisto(comptedb);
return PartialView("ComptesContratsPartial", agregcompte);
}
if (compteeditvm.typecontrat.ToLower() == agupsideocompteBL.immobilier.ToLower())
{
comptedb.designation = compteeditvm.designation;
comptedb.dateacquisition = DateTime.ParseExact(compteeditvm.dateacquisition, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
comptedb.valeuracquisition = compteeditvm.valeuracquisition;
comptedb.totalcompte = compteeditvm.totalcompte;
comptedb.fiscalite = compteeditvm.fiscalite;
//
//
//
comptedb = agupsideocompteBL.Updatecompte(comptedb);
lstCompte = agupsideocompteBL.GetComptesClient(idClient);
agregcompte.AgregCompteImmobilier = lstCompte.Where(c => c.Typecontrat.ToLower() == agupsideocompteBL.immobilier.ToLower()).OrderBy(c => c.Designation).ToList();
//historisé 9711
agupsideocompteBL.AddCompteHisto(comptedb);
return PartialView("ComptesImmobiliersPartial", agregcompte);
}
if (compteeditvm.typecontrat.ToLower() == agupsideocompteBL.professionels.ToLower())
{
DateTime? dt;
comptedb.designation = compteeditvm.designation;
if (!string.IsNullOrEmpty(compteeditvm.dateacquisition))
comptedb.dateacquisition = DateTime.ParseExact(compteeditvm.dateacquisition, "dd/MM/yyyy",
System.Globalization.CultureInfo.InvariantCulture);
comptedb.valeuracquisition = compteeditvm.valeuracquisition;
comptedb.totalcompte = compteeditvm.totalcompte;
//
//
//
comptedb = agupsideocompteBL.Updatecompte(comptedb);
lstCompte = agupsideocompteBL.GetComptesClient(idClient);
agregcompte.AgregCompteProfessionnels = lstCompte.Where(c => c.Typecontrat.ToLower() == agupsideocompteBL.professionels.ToLower()).OrderBy(c => c.Designation).ToList();
//historisé 9711
agupsideocompteBL.AddCompteHisto(comptedb);
return PartialView("ComptesProfessionnelsPartial", agregcompte);
}
if (compteeditvm.typecontrat.ToLower() == agupsideocompteBL.capitalrisque.ToLower())
{
comptedb.designation = compteeditvm.designation;
comptedb.totalcompte = compteeditvm.totalcompte;
if (!string.IsNullOrEmpty(compteeditvm.dds))
{
comptedb.dds = DateTime.ParseExact(compteeditvm.dds, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
else
{
comptedb.dds = null;
}
//
//compteeditvm.nbretitre;
//compteeditvm.prixunitaire;
#region Nbre titre et prixunitaire
//
AgUpsideoCptrelsupportsBL.UpdateFondCapitalRisque(idCgpAgreg, comptedb, compteeditvm.nbretitre, compteeditvm.prixunitaire);
//
#endregion
//
//
//
lstCompte = agupsideocompteBL.GetComptesClient(idClient);
agregcompte.AgregCompteCapitalRisque = lstCompte.Where(c => c.Typecontrat.ToLower() == agupsideocompteBL.capitalrisque.ToLower()).OrderBy(c => c.Designation).ToList();
//historisé 9711
agupsideocompteBL.AddCompteHisto(comptedb);
return PartialView("ComptesCapitalRisquePartial", agregcompte);
}
}
catch (Exception e)
{
return Json(new { error = "ok",msg= e.Message }, JsonRequestBehavior.AllowGet);
}
return Json(new { error = "ko", msg = string.Empty }, JsonRequestBehavior.AllowGet);
}
public static ag_upsideo_compte_histo AddCompteHisto(ag_upsideo_compte compte)
{
using (UpsilabEntities db = new UpsilabEntities())
{
ag_upsideo_compte_histo cpthisto = db.ag_upsideo_compte_histo.Where(h => h.idfrontcompte == compte.Idfrontcompte
&& h.datehisto.Year == DateTime.Now.Year
&& h.datehisto.Month == DateTime.Now.Month
&& h.datehisto.Day == DateTime.Now.Day).FirstOrDefault();
if (cpthisto != null)
{
cpthisto.datehisto = DateTime.Now;
cpthisto.totalcompte = compte.totalcompte.HasValue ? compte.totalcompte.Value : 0;
}
else
{
cpthisto = new ag_upsideo_compte_histo()
{
datehisto = DateTime.Now,
idfrontcompte = compte.Idfrontcompte,
devise = string.IsNullOrEmpty(compte.devise) ? "EUR" : compte.devise,
totalcompte = compte.totalcompte.HasValue ? compte.totalcompte.Value : 0
};
//insert
db.ag_upsideo_compte_histo.AddObject(cpthisto);
}
//save
db.SaveChanges();
return cpthisto;
}
}
public PartialViewResult LoadPopupAjoutActif(string id)
{
try
{
Guid idClient = Guid.Empty;
SessionManager.Get<Guid>(agupsideocompteBL.AgregClientIdSessionKey, out idClient);
if (idClient == Guid.Empty)
{
return PartialView("ErreurPartial", "Session perdue.");
}
ag_upsideo_compte compte = new ag_upsideo_compte()
{
idclient = idClient
};
return PartialView("PopupAjoutActifPartial", compte);
}
catch (Exception ex)
{
return PartialView("ErreurPartial", ex.Message);
}
}
public ActionResult GraphePerformance(string id = null)
{
ag_upsideo_compte compte = new ag_upsideo_compte();
List<ag_upsideo_client> listeClient = new List<ag_upsideo_client>();
try
{
int idCompte = 0;
if (!string.IsNullOrEmpty(id))
{
idCompte = Convert.ToInt32(id);
using (UpsilabEntities db = new UpsilabEntities())
{
compte = db.ag_upsideo_compte.Include("ag_upsideo_client").Where(c => c.Idfrontcompte == idCompte && c.deleted == "n").FirstOrDefault();
//get performance
//List<AgregGraphePerformanceModel> lstrepartition = new List<AgregGraphePerformanceModel>();
//lstrepartition = agupsideocompteBL.GraphePerformance(idCompte);
//string xmlData = ChartBL.GetChart2DPerformance(lstrepartition);
//ViewBag.MyChart = FusionCharts.RenderChart(Url.Content("~/Content/FusionCharts/MSColumn2D.swf"), "", xmlData, "performanceChartId", "1000", "400", false, true, true, "FFFFFF", "noscale", "EN");
//Obtenir le mouvement d'un compte et mettre dans session
List<ag_upsideo_mouvement> listemvt = new List<ag_upsideo_mouvement>();
listemvt = db.ag_upsideo_mouvement.Where(m => m.Idfrontcompte == compte.Idfrontcompte && (m.deleted == null || (m.deleted != null && m.deleted == "n"))).OrderBy(o=>o.datemvt).ToList();
SessionManager.Set<List<ag_upsideo_mouvement>>(agupsideocompteBL.AgregListemvtIdSessionKey, listemvt);
}
}
}
catch (Exception ex)
{
Upsilab.Business.Log.Log.AppendException(ex);
}
return View(compte);
}
public ActionResult GrapheValorisation(string id = null)
{
ag_upsideo_compte compte = new ag_upsideo_compte();
List<ag_upsideo_client> listeClient = new List<ag_upsideo_client>();
try
{
int idCompte = 0;
if (!string.IsNullOrEmpty(id))
{
idCompte = Convert.ToInt32(id);
using (UpsilabEntities db = new UpsilabEntities())
{
compte = db.ag_upsideo_compte.Include("ag_upsideo_client").Where(c => c.Idfrontcompte == idCompte && c.deleted == "n").FirstOrDefault();
//get evol valo in ag_upsideo_compte_histo
List<AgregChart> lstrepartition = new List<AgregChart>();
lstrepartition = agupsideocompteBL.GetEvalValoByCompte(idCompte);
string xmlData = ChartBL.GetChartMSLineEvalValo(lstrepartition,true);
ViewBag.MyChart = FusionCharts.RenderChart(Url.Content("~/Content/FusionCharts/ZoomLine.swf"), "", xmlData, "evolutionChartId", "1000", "400", false, true, true, "FFFFFF", "noscale", "FR");
}
}
}
catch (Exception ex)
{
Upsilab.Business.Log.Log.AppendException(ex);
}
return View(compte);
}
public ActionResult RepartitionParOPCVM(string id = null)
{
ag_upsideo_compte agregcompte = new ag_upsideo_compte();
Guid idClient = Guid.Empty;
SessionManager.Get<Guid>(agupsideocompteBL.AgregClientIdSessionKey, out idClient);
Guid idCgpAgreg = Guid.Empty;
User currentUser = SessionManager.GetUserSession();
if (currentUser.IsEndUser())
{
CustomerProspect currentCustomer = SessionManager.GetCustomerProspectSession();
User currenttUserCreated = currentCustomer.User1;
idCgpAgreg = currenttUserCreated.idAgregCGP.Value;
}
else
{
idCgpAgreg = currentUser.idAgregCGP.Value;
}
int idCompte = 0;
if (!string.IsNullOrEmpty(id))
{
idCompte = Convert.ToInt32(id);
var correctcompte = agupsideocompteBL.IsClientCompte(idClient, idCompte);
if (!correctcompte)
{
var LanguageData = PageLanguageHelper.GetLanguageContent("User", "agregcompte");
throw new Exception(LanguageData.GetContent("incorrect_compte"));
}
}
try
{
//Répartition par classe actif d'un compte de client
List<AgregChart> lstrepartition = new List<AgregChart>();
lstrepartition = (!string.IsNullOrEmpty(id)) ?
agupsideocompteBL.GetOPCVMByCompteClient(idCompte):
agupsideocompteBL.GetOPCVMByClient(idClient);
//string xmlData = ChartBL.GetChartPie2DTagWithList(lstrepartition);
string xmlData = ChartBL.GetChartDougnhutWithList(lstrepartition);
//Create the chart - Column 2D Chart with data contained in xmlData
ViewBag.MyChart = FusionCharts.RenderChart(Url.Content("~/Content/FusionCharts/Doughnut2D.swf"), "", xmlData, "myChartId", "620", "250", false, true, true, "FFFFFF", "noscale", "EN");
//ViewBag.MyChart = FusionCharts.RenderChart(Url.Content("~/Content/FusionCharts/Pie2D.swf"), "", xmlData, "myChartId", "620", "250", false, true, true, "FFFFFF", "noscale", "EN");
//Client
using (UpsilabEntities db = new UpsilabEntities())
{
agregcompte = db.ag_upsideo_compte.Include("ag_upsideo_client").Where(c => c.Idfrontcompte == idCompte && c.deleted == "n").FirstOrDefault();
}
}
catch (Exception ex)
{
Upsilab.Business.Log.Log.AppendException(ex);
}
if (agregcompte != null)
return View(agregcompte);
else
{
ViewBag.Title = AgUpsideoClientBL.GetClientTitleNameFirstNameByidClient(idClient);
ViewBag.idClient = idClient;
return View();
}
}
public ActionResult InsertCompte(ag_upsideo_compte _compte)
{
Guid idClient = Guid.Empty;
SessionManager.Get<Guid>(agupsideocompteBL.AgregClientIdSessionKey, out idClient);
Guid idCgpAgreg = Guid.Empty;
User currentUser = SessionManager.GetUserSession();
if (currentUser.IsEndUser())
{
CustomerProspect currentCustomer = SessionManager.GetCustomerProspectSession();
User currenttUserCreated = currentCustomer.User1;
idCgpAgreg = currenttUserCreated.idAgregCGP.Value;
}
else
{
idCgpAgreg = currentUser.idAgregCGP.Value;
}
try
{
if (Request.Form["typecontrat"] != null && idClient != Guid.Empty)
{
using (UpsilabEntities db = new UpsilabEntities())
{
//new compte
ag_upsideo_compte compte = new ag_upsideo_compte();
string typecontrat = Request.Form["typecontrat"].ToString();
compte.typecontrat = typecontrat;
compte.idclient = idClient;
compte.idcgp = idCgpAgreg;
compte.deleted = "n";
compte.type = "o";
if (typecontrat.ToLower() == agupsideocompteBL.comptetitrespea.ToLower() || typecontrat.ToLower() == agupsideocompteBL.capitalisation.ToLower())
{
if (Request.Form["isPEA"] != null && Request.Form["isPEA"].ToString() == "on")
compte.pea = "o";
else
compte.pea = "n";
if (Request.Form["numcomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["numcomptecontrat"].ToString()))
compte.numcompte = Request.Form["numcomptecontrat"].ToString();
if (Request.Form["titulairecomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["titulairecomptecontrat"].ToString()))
compte.NomTitulaire1 = Request.Form["titulairecomptecontrat"].ToString();
if (Request.Form["depositairecomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["depositairecomptecontrat"].ToString()))
compte.idfrontfournisseur = int.Parse(Request.Form["depositairecomptecontrat"].ToString());
if (Request.Form["Ddscomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["Ddscomptecontrat"].ToString()))
compte.dds = DateTime.Parse(Request.Form["Ddscomptecontrat"].ToString());
}
else if (typecontrat.ToLower() == agupsideocompteBL.assurancevie.ToLower() || typecontrat.ToLower() == agupsideocompteBL.comptebancaire.ToLower())
{
if (Request.Form["numcomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["numcomptecontrat"].ToString()))
compte.numcompte = Request.Form["numcomptecontrat"].ToString();
if (Request.Form["titulairecomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["titulairecomptecontrat"].ToString()))
compte.NomTitulaire1 = Request.Form["titulairecomptecontrat"].ToString();
if (Request.Form["depositairecomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["depositairecomptecontrat"].ToString()))
compte.idfrontfournisseur = int.Parse(Request.Form["depositairecomptecontrat"].ToString());
if (Request.Form["Ddscomptecontrat"] != null && !string.IsNullOrEmpty(Request.Form["Ddscomptecontrat"].ToString()))
compte.dds = DateTime.Parse(Request.Form["Ddscomptecontrat"].ToString());
}
else if (typecontrat.ToLower() == agupsideocompteBL.immobilier.ToLower())
{
if (Request.Form["designationimmobilier"] != null && !string.IsNullOrEmpty(Request.Form["designationimmobilier"].ToString()))
compte.designation = Request.Form["designationimmobilier"].ToString();
if (Request.Form["dateacquisimmobilier"] != null && !string.IsNullOrEmpty(Request.Form["dateacquisimmobilier"].ToString()))
compte.dateacquisition = DateTime.Parse(Request.Form["dateacquisimmobilier"].ToString());
if (Request.Form["valacquisimmobilier"] != null && !string.IsNullOrEmpty(Request.Form["valacquisimmobilier"].ToString()))
compte.valeuracquisition = double.Parse(Request.Form["valacquisimmobilier"].ToString());
if (Request.Form["valvenalimmobilier"] != null && !string.IsNullOrEmpty(Request.Form["valvenalimmobilier"].ToString()))
compte.totalcompte = double.Parse(Request.Form["valvenalimmobilier"].ToString());
if (Request.Form["fiscaliteimmobilier"] != null && !string.IsNullOrEmpty(Request.Form["fiscaliteimmobilier"].ToString()))
compte.fiscalite = double.Parse(Request.Form["fiscaliteimmobilier"].ToString());
}
else if (typecontrat.ToLower() == agupsideocompteBL.professionels.ToLower())
{
if (Request.Form["designationprofessionel"] != null && !string.IsNullOrEmpty(Request.Form["designationprofessionel"].ToString()))
compte.designation = Request.Form["designationprofessionel"].ToString();
if (Request.Form["valacquisprofessionel"] != null && !string.IsNullOrEmpty(Request.Form["valacquisprofessionel"].ToString()))
compte.valeuracquisition = double.Parse(Request.Form["valacquisprofessionel"].ToString());
if (Request.Form["valoprofessionel"] != null && !string.IsNullOrEmpty(Request.Form["valoprofessionel"].ToString()))
compte.totalcompte = double.Parse(Request.Form["valoprofessionel"].ToString());
}
else if (typecontrat.ToLower() == agupsideocompteBL.capitalrisque.ToLower())
{
if (Request.Form["designationcapital"] != null && !string.IsNullOrEmpty(Request.Form["designationcapital"].ToString()))
compte.designation = Request.Form["designationcapital"].ToString();
if (Request.Form["montantcapital"] != null && !string.IsNullOrEmpty(Request.Form["montantcapital"].ToString()))
compte.totalcompte = double.Parse(Request.Form["montantcapital"].ToString());
if (Request.Form["ddscapital"] != null && !string.IsNullOrEmpty(Request.Form["ddscapital"].ToString()))
compte.dds = DateTime.Parse(Request.Form["ddscapital"].ToString());
}
//save
db.ag_upsideo_compte.AddObject(compte);
db.SaveChanges();
//historisé rd 9711
ag_upsideo_compte_histo cpthistonew = new ag_upsideo_compte_histo()
{
datehisto = DateTime.Now,
idfrontcompte = compte.Idfrontcompte,
devise = string.IsNullOrEmpty(compte.devise) ? "EUR" : compte.devise,
totalcompte = compte.totalcompte.HasValue ? compte.totalcompte.Value : 0
};
//insert
db.ag_upsideo_compte_histo.AddObject(cpthistonew);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
ViewBag.Style = "style=color:red";
ViewBag.Message = "Erreur: " + ex.Message;
Upsilab.Business.Log.Log.AppendException(ex);
}
return RedirectToAction("Index", new { id = idClient });
}
