public void updatePriorityDetails(priorityDetail priorityDetails)
{
try
{
dbDataContext ct = new dbDataContext();
priorityDetail detail = null;
//retrieve existing saving goal
var queryPriorityDetails = from al in ct.priorityDetails
where al.caseid == priorityDetails.caseid
select al;
foreach (priorityDetail priorityDetailObject in queryPriorityDetails)
{
detail = priorityDetailObject;
}
detail.protection1 = priorityDetails.protection1;
detail.protection2 = priorityDetails.protection2;
detail.protection3 = priorityDetails.protection3;
detail.protection4 = priorityDetails.protection4;
detail.protection5 = priorityDetails.protection5;
detail.savings1 = priorityDetails.savings1;
detail.savings2 = priorityDetails.savings2;
detail.savings3 = priorityDetails.savings3;
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public List<myzurichadviser> saveMza(List<myzurichadviser> mzaoptions)
{
int status = 1;
try
{
dbDataContext ct = new dbDataContext();
if (mzaoptions != null && mzaoptions.Count > 0)
{
ct.myzurichadvisers.InsertAllOnSubmit(mzaoptions);
ct.SubmitChanges();
}
}
catch (Exception e)
{
status = 0;
string str = e.Message;
}
if (status == 0)
{
mzaoptions = null;
}
return mzaoptions;
}
public int deleteEducationGoal(int egid)
{
int status = 1;
educationgoal retrievedGoal = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing education goal
var queryEducationGoals = from sg in ct.educationgoals
where sg.id == egid
select sg;
foreach (educationgoal sgoals in queryEducationGoals)
{
retrievedGoal = sgoals;
}
//update education goal attributes
retrievedGoal.deleted = true;
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
status = 0;
}
return status;
}
public void saveNewCkaProfile(CkaAssessment ckaAssessment)
{
try
{
dbDataContext ct = new dbDataContext();
ct.CkaAssessments.InsertOnSubmit(ckaAssessment);
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public void savePriorityDetails(priorityDetail priorityDetails)
{
try
{
dbDataContext ct = new dbDataContext();
ct.priorityDetails.InsertOnSubmit(priorityDetails);
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public incomeExpense insertNewIncomeExpenseDetails(incomeExpense incomeExpenseDetail)
{
try
{
dbDataContext ct = new dbDataContext();
ct.incomeExpenses.InsertOnSubmit(incomeExpenseDetail);
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
return incomeExpenseDetail;
}
public Boolean insertNewAssetLiabilityDetails(assetAndLiability assetAndLiability)
{
Boolean status = true;
try
{
dbDataContext ct = new dbDataContext();
ct.assetAndLiabilities.InsertOnSubmit(assetAndLiability);
ct.SubmitChanges();
}
catch (Exception e)
{
status = false;
string str = e.Message;
}
return status;
}
public int savePersonalDetails(personaldetail personalDetails)
{
int noOfRows = 0;
try
{
dbDataContext ct = new dbDataContext();
ct.personaldetails.InsertOnSubmit(personalDetails);
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
return noOfRows;
}
public myNeed saveMyNeeds(myNeed myNeeds)
{
int status = 1;
try
{
dbDataContext ct = new dbDataContext();
ct.myNeeds.InsertOnSubmit(myNeeds);
ct.SubmitChanges();
}
catch (Exception ex)
{
logException(ex);
throw ex;
}
if (status == 0)
{
myNeeds = null;
}
return myNeeds;
}
public retirementgoal saveRetirementGoals(retirementgoal goals)
{
int status = 1;
try
{
dbDataContext ct = new dbDataContext();
ct.retirementgoals.InsertOnSubmit(goals);
ct.SubmitChanges();
}
catch (Exception e)
{
status = 0;
string str = e.Message;
}
if (status == 0)
{
goals = null;
}
return goals;
}
public List<myzurichadviser> updateMza(List<myzurichadviser> mzaoptions, string caseid)
{
int status = 1;
try
{
dbDataContext ct = new dbDataContext();
//delete existing my zurich adviser
var queryExistingMza = from emza in ct.myzurichadvisers
where emza.caseid == caseid
select emza;
foreach (myzurichadviser mza in queryExistingMza)
{
ct.myzurichadvisers.DeleteOnSubmit(mza);
}
if (mzaoptions != null && mzaoptions.Count > 0)
{
ct.myzurichadvisers.InsertAllOnSubmit(mzaoptions);
}
ct.SubmitChanges();
}
catch (Exception e)
{
status = 0;
string str = e.Message;
}
if (status == 0)
{
mzaoptions = null;
}
return mzaoptions;
}
public incomeExpense updateIncomeExpenseDetails(incomeExpense incomeExpenseDetail)
{
incomeExpense incomeExpense = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing saving goal
var queryIncomeExpenseDetails = from al in ct.incomeExpenses
where al.caseId == incomeExpenseDetail.caseId
select al;
foreach (incomeExpense incomeExpenseDetails in queryIncomeExpenseDetails)
{
incomeExpense = incomeExpenseDetails;
}
incomeExpense.emergencyFundsNeeded = incomeExpenseDetail.emergencyFundsNeeded;
incomeExpense.shortTermGoals = incomeExpenseDetail.shortTermGoals;
incomeExpense.extraDetails = incomeExpenseDetail.extraDetails;
incomeExpense.netMonthlyIncomeAfterCpf = incomeExpenseDetail.netMonthlyIncomeAfterCpf;
incomeExpense.netMonthlyExpenses = incomeExpenseDetail.netMonthlyExpenses;
incomeExpense.monthlySavings = incomeExpenseDetail.monthlySavings;
incomeExpense.lifeInsuranceSA = incomeExpenseDetail.lifeInsuranceSA;
incomeExpense.lifeInsuranceMV = incomeExpenseDetail.lifeInsuranceMV;
incomeExpense.expiry1 = incomeExpenseDetail.expiry1;
incomeExpense.lifeInsurancePremium = incomeExpenseDetail.lifeInsurancePremium;
incomeExpense.lifeInsuranceRemarks = incomeExpenseDetail.lifeInsuranceRemarks;
incomeExpense.tpdcSA = incomeExpenseDetail.tpdcSA;
incomeExpense.tpdcMV = incomeExpenseDetail.tpdcMV;
incomeExpense.expiry2 = incomeExpenseDetail.expiry2;
incomeExpense.tpdcPremium = incomeExpenseDetail.tpdcPremium;
incomeExpense.tpdcRemarks = incomeExpenseDetail.tpdcRemarks;
incomeExpense.criticalIllnessSA = incomeExpenseDetail.criticalIllnessSA;
incomeExpense.criticalIllnessMV = incomeExpenseDetail.criticalIllnessMV;
incomeExpense.expiry3 = incomeExpenseDetail.expiry3;
incomeExpense.criticalIllnessPremium = incomeExpenseDetail.criticalIllnessPremium;
incomeExpense.criticalIllnessRemarks = incomeExpenseDetail.criticalIllnessRemarks;
incomeExpense.disabilityIncomeSA = incomeExpenseDetail.disabilityIncomeSA;
incomeExpense.disabilityIncomeMV = incomeExpenseDetail.disabilityIncomeMV;
incomeExpense.expiry4 = incomeExpenseDetail.expiry4;
incomeExpense.disabilityIncomePremium = incomeExpenseDetail.disabilityIncomePremium;
incomeExpense.disabilityIncomeRemarks = incomeExpenseDetail.disabilityIncomeRemarks;
incomeExpense.mortgageSA = incomeExpenseDetail.mortgageSA;
incomeExpense.mortgageMV = incomeExpenseDetail.mortgageMV;
incomeExpense.expiry5 = incomeExpenseDetail.expiry5;
incomeExpense.mortgagePremium = incomeExpenseDetail.mortgagePremium;
incomeExpense.mortgageRemarks = incomeExpenseDetail.mortgageRemarks;
incomeExpense.others1A = incomeExpenseDetail.others1A;
incomeExpense.others1V = incomeExpenseDetail.others1V;
incomeExpense.expiry6 = incomeExpenseDetail.expiry6;
incomeExpense.others1Premium = incomeExpenseDetail.others1Premium;
incomeExpense.others1Remarks = incomeExpenseDetail.others1Remarks;
incomeExpense.DeathTermInsurancePremium = incomeExpenseDetail.DeathTermInsurancePremium;
incomeExpense.DeathTermInsuranceSA = incomeExpenseDetail.DeathTermInsuranceSA;
incomeExpense.DeathTermInsuranceTerm = incomeExpenseDetail.DeathTermInsuranceTerm;
incomeExpense.DeathWholeLifeInsurancePremium = incomeExpenseDetail.DeathWholeLifeInsurancePremium;
incomeExpense.DeathWholeLifeInsuranceSA = incomeExpenseDetail.DeathWholeLifeInsuranceSA;
incomeExpense.DeathWholeLifeInsuranceTerm = incomeExpenseDetail.DeathWholeLifeInsuranceTerm;
incomeExpense.incomeExpenseNeeded = incomeExpenseDetail.incomeExpenseNeeded;
incomeExpense.incomeExpenseNotNeededReason = incomeExpenseDetail.incomeExpenseNotNeededReason;
incomeExpense.assecertainingAffordabilityEnable = incomeExpenseDetail.assecertainingAffordabilityEnable;
incomeExpense.assecertainingAffordabilityReason = incomeExpenseDetail.assecertainingAffordabilityReason;
incomeExpense.otherSourcesOfIncome = incomeExpenseDetail.otherSourcesOfIncome;
incomeExpense.caseId=incomeExpenseDetail.caseId;
var queryIncomeExpenseOthers = from incomeExpenseOther in ct.incomeExpenseOthers
where incomeExpenseOther.incomeExpenseId == incomeExpenseDetail.id
select incomeExpenseOther;
foreach (incomeExpenseOther incomeExpenseOther in queryIncomeExpenseOthers)
{
ct.incomeExpenseOthers.DeleteOnSubmit(incomeExpenseOther);
}
//update income expense others list for the IncomeExpense goal
if (incomeExpenseDetail.incomeExpenseOthers != null && incomeExpenseDetail.incomeExpenseOthers.Count > 0)
{
EntitySet<incomeExpenseOther> incomeExpenseOtherSet = new EntitySet<incomeExpenseOther>();
foreach (incomeExpenseOther incomeExpenseOther in incomeExpenseDetail.incomeExpenseOthers)
{
incomeExpenseOtherSet.Add(incomeExpenseOther);
}
incomeExpense.incomeExpenseOthers = incomeExpenseOtherSet;
}
var queryIncomeExpenseSaving = from insuranceArrangementSaving in ct.insuranceArrangementSavings
where insuranceArrangementSaving.incomeExpenseId == incomeExpenseDetail.id
select insuranceArrangementSaving;
foreach (insuranceArrangementSaving insuranceArrangementSaving in queryIncomeExpenseSaving)
{
ct.insuranceArrangementSavings.DeleteOnSubmit(insuranceArrangementSaving);
}
//update income expense others list for the IncomeExpense goal
if (incomeExpenseDetail.insuranceArrangementSavings != null && incomeExpenseDetail.insuranceArrangementSavings.Count > 0)
{
EntitySet<insuranceArrangementSaving> insuranceArrangementSavingSet = new EntitySet<insuranceArrangementSaving>();
foreach (insuranceArrangementSaving insuranceArrangementSaving in incomeExpenseDetail.insuranceArrangementSavings)
{
insuranceArrangementSavingSet.Add(insuranceArrangementSaving);
}
incomeExpense.insuranceArrangementSavings = insuranceArrangementSavingSet;
}
var queryIncomeExpenseRetirement = from insuranceArrangementRetirement in ct.insuranceArrangementRetirements
where insuranceArrangementRetirement.incomeExpenseId == incomeExpenseDetail.id
select insuranceArrangementRetirement;
foreach (insuranceArrangementRetirement insuranceArrangementRetirement in queryIncomeExpenseRetirement)
{
ct.insuranceArrangementRetirements.DeleteOnSubmit(insuranceArrangementRetirement);
}
//update income expense others list for the IncomeExpense goal
if (incomeExpenseDetail.insuranceArrangementRetirements != null && incomeExpenseDetail.insuranceArrangementRetirements.Count > 0)
{
EntitySet<insuranceArrangementRetirement> insuranceArrangementRetirementSet = new EntitySet<insuranceArrangementRetirement>();
foreach (insuranceArrangementRetirement insuranceArrangementRetirement in incomeExpenseDetail.insuranceArrangementRetirements)
{
insuranceArrangementRetirementSet.Add(insuranceArrangementRetirement);
}
incomeExpense.insuranceArrangementRetirements = insuranceArrangementRetirementSet;
}
var queryIncomeExpenseEducation = from insuranceArrangementEducation in ct.insuranceArrangementEducations
where insuranceArrangementEducation.incomeExpenseId == incomeExpenseDetail.id
select insuranceArrangementEducation;
foreach (insuranceArrangementEducation insuranceArrangementEducation in queryIncomeExpenseEducation)
{
ct.insuranceArrangementEducations.DeleteOnSubmit(insuranceArrangementEducation);
}
//update income expense others list for the IncomeExpense goal
if (incomeExpenseDetail.insuranceArrangementEducations != null && incomeExpenseDetail.insuranceArrangementEducations.Count > 0)
{
EntitySet<insuranceArrangementEducation> insuranceArrangementEducationSet = new EntitySet<insuranceArrangementEducation>();
foreach (insuranceArrangementEducation insuranceArrangementEducation in incomeExpenseDetail.insuranceArrangementEducations)
{
insuranceArrangementEducationSet.Add(insuranceArrangementEducation);
}
incomeExpense.insuranceArrangementEducations = insuranceArrangementEducationSet;
}
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
return incomeExpense;
}
public void updateCkaDetails(CkaAssessment ckaAssessment)
{
CkaAssessment assessment = null;
try
{
dbDataContext ct = new dbDataContext();
var queryCkaDetails = from al in ct.CkaAssessments
where al.caseId == ckaAssessment.caseId
select al;
foreach (CkaAssessment ckAssessment in queryCkaDetails)
{
assessment = ckAssessment;
}
assessment.agreeCKA = ckaAssessment.agreeCKA;
assessment.csaOutcomeOption1 = ckaAssessment.csaOutcomeOption1;
assessment.csaOutcomeOption2 = ckaAssessment.csaOutcomeOption2;
assessment.disagreeCKA = ckaAssessment.disagreeCKA;
assessment.educationalExperienceOption1 = ckaAssessment.educationalExperienceOption1;
assessment.educationalExperienceOption2 = ckaAssessment.educationalExperienceOption2;
assessment.financeRelatedKnowledgeOption1 = ckaAssessment.financeRelatedKnowledgeOption1;
assessment.financeRelatedKnowledgeOption2 = ckaAssessment.financeRelatedKnowledgeOption2;
assessment.investmentExperienceOption1 = ckaAssessment.investmentExperienceOption1;
assessment.investmentExperienceOption2 = ckaAssessment.investmentExperienceOption2;
assessment.workingExperienceOption1 = ckaAssessment.workingExperienceOption1;
assessment.workingExperienceOption2 = ckaAssessment.workingExperienceOption2;
assessment.educationalExperienceList = ckaAssessment.educationalExperienceList;
assessment.investmentExperienceList = ckaAssessment.investmentExperienceList;
assessment.workingExperienceList = ckaAssessment.workingExperienceList;
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public retirementgoal updateRetirementGoals(retirementgoal goals)
{
retirementgoal retrievedGoal = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing retirement goal
var queryRetirementGoals = from sg in ct.retirementgoals
where sg.caseid == goals.caseid
&& sg.selforspouse == goals.selforspouse
select sg;
foreach (retirementgoal sgoals in queryRetirementGoals)
{
retrievedGoal = sgoals;
}
//update retirement goal attributes
retrievedGoal.durationretirement = goals.durationretirement;
retrievedGoal.futureincome = goals.futureincome;
retrievedGoal.incomerequired = goals.incomerequired;
retrievedGoal.intendedretirementage = goals.intendedretirementage;
retrievedGoal.lumpsumrequired = goals.lumpsumrequired;
retrievedGoal.maturityvalue = goals.maturityvalue;
retrievedGoal.sourcesofincome = goals.sourcesofincome;
retrievedGoal.total = goals.total;
retrievedGoal.totalfirstyrincome = goals.totalfirstyrincome;
retrievedGoal.yrstoretirement = goals.yrstoretirement;
retrievedGoal.existingassetstotal = goals.existingassetstotal;
retrievedGoal.inflationreturnrate = goals.inflationreturnrate;
retrievedGoal.inflationrate = goals.inflationrate;
retrievedGoal.retirementGoalNeeded = goals.retirementGoalNeeded;
//delete existing assets for the retirement goal
var queryExistingAssets = from easg in ct.existingassetrgs
where easg.retirementgoalsid == retrievedGoal.id
select easg;
foreach (existingassetrg easgoals in queryExistingAssets)
{
ct.existingassetrgs.DeleteOnSubmit(easgoals);
//ct.SubmitChanges();
}
//update existing assets list for the retirement goal
if (goals.existingassetrgs != null && goals.existingassetrgs.Count > 0)
{
EntitySet<existingassetrg> easgList = new EntitySet<existingassetrg>();
foreach (existingassetrg sgea in goals.existingassetrgs)
{
easgList.Add(sgea);
}
retrievedGoal.existingassetrgs = easgList;
}
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
return retrievedGoal;
}
public void saveNewRiskProfile(RiskProfileAnalysis RiskProfileDetails)
{
try
{
dbDataContext ct = new dbDataContext();
if (RiskProfileDetails.agreeWithRiskProfileoption2 == "true")
{
RiskProfileDetails.riskProfileName = getRiskProfileName(Int32.Parse(RiskProfileDetails.riskProfileValue));
}
else
{
int score = calculateRiskProfile(RiskProfileDetails);
RiskProfileDetails.riskProfileValue = score + "";
String profile_name = getRiskProfileName(score);
RiskProfileDetails.riskProfileName = profile_name;
}
ct.RiskProfileAnalysis.InsertOnSubmit(RiskProfileDetails);
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public educationgoal updateEducationGoals(educationgoal goals, int egid)
{
educationgoal retrievedGoal = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing education goal
var queryEducationGoals = from sg in ct.educationgoals
where sg.caseid == goals.caseid && sg.id == egid
select sg;
foreach (educationgoal sgoals in queryEducationGoals)
{
retrievedGoal = sgoals;
}
//update education goal attributes
retrievedGoal.agefundsneeded = goals.agefundsneeded;
retrievedGoal.currentage = goals.currentage;
retrievedGoal.maturityvalue = goals.maturityvalue;
retrievedGoal.nameofchild = goals.nameofchild;
retrievedGoal.noofyrstosave = goals.noofyrstosave;
retrievedGoal.total = goals.total;
retrievedGoal.existingassetstotal = goals.existingassetstotal;
retrievedGoal.futurecost = goals.futurecost;
retrievedGoal.presentcost = goals.presentcost;
retrievedGoal.inflationrate = goals.inflationrate;
retrievedGoal.educationGoalNeeded = goals.educationGoalNeeded;
retrievedGoal.countryofstudyid = goals.countryofstudyid;
//delete existing assets for the education goal
var queryExistingAssets = from easg in ct.existingassetegs
where easg.educationgoalsid == retrievedGoal.id
select easg;
foreach (existingasseteg easgoals in queryExistingAssets)
{
ct.existingassetegs.DeleteOnSubmit(easgoals);
//ct.SubmitChanges();
}
//update existing assets list for the education goal
if (goals.existingassetegs != null && goals.existingassetegs.Count > 0)
{
EntitySet<existingasseteg> easgList = new EntitySet<existingasseteg>();
foreach (existingasseteg sgea in goals.existingassetegs)
{
easgList.Add(sgea);
}
retrievedGoal.existingassetegs = easgList;
}
if (retrievedGoal.educationGoalNeeded == 1 || retrievedGoal.educationGoalNeeded == 0)
{
var eduGoalRecords = from edug in ct.educationgoals
where edug.caseid == goals.caseid
select edug;
int[] arrRecordIds = null;
if (eduGoalRecords != null)
{
int size = eduGoalRecords.ToArray().Length;
arrRecordIds = new int[size];
}
int index = 0;
foreach (educationgoal egl in eduGoalRecords)
{
arrRecordIds[index] = egl.id;
index++;
}
var todelExistingAssets = from easg in ct.existingassetegs
where arrRecordIds.Contains(easg.educationgoalsid)
select easg;
foreach (existingasseteg easgoals in todelExistingAssets)
{
ct.existingassetegs.DeleteOnSubmit(easgoals);
}
var toDelEducationGoals = from sg in ct.educationgoals
where sg.caseid == goals.caseid && sg.id != egid
select sg;
foreach (educationgoal s in toDelEducationGoals)
{
ct.educationgoals.DeleteOnSubmit(s);
}
}
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
return retrievedGoal;
}
public savinggoal updateSavingGoals(savinggoal goals, int sgid)
{
savinggoal retrievedGoal = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing saving goal
var querySavingGoals = from sg in ct.savinggoals
where sg.caseid == goals.caseid && sg.id == sgid
select sg;
foreach (savinggoal sgoals in querySavingGoals)
{
retrievedGoal = sgoals;
}
//retrievedGoal = goals;
//update saving goal attributes
retrievedGoal.amtneededfv = goals.amtneededfv;
retrievedGoal.goal = goals.goal;
retrievedGoal.maturityvalue = goals.maturityvalue;
retrievedGoal.regularannualcontrib = goals.regularannualcontrib;
retrievedGoal.total = goals.total;
retrievedGoal.yrstoaccumulate = goals.yrstoaccumulate;
retrievedGoal.existingassetstotal = goals.existingassetstotal;
retrievedGoal.savingGoalNeeded = goals.savingGoalNeeded;
//delete existing assets for the saving goal
var queryExistingAssets = from easg in ct.existingassetsgs
where easg.savinggoalsid == retrievedGoal.id
select easg;
foreach (existingassetsg easgoals in queryExistingAssets)
{
ct.existingassetsgs.DeleteOnSubmit(easgoals);
//ct.SubmitChanges();
}
//update existing assets list for the saving goal
if (goals.existingassetsgs != null && goals.existingassetsgs.Count > 0)
{
EntitySet<existingassetsg> easgList = new EntitySet<existingassetsg>();
foreach (existingassetsg sgea in goals.existingassetsgs)
{
easgList.Add(sgea);
}
retrievedGoal.existingassetsgs = easgList;
}
if (retrievedGoal.savingGoalNeeded == 1 || retrievedGoal.savingGoalNeeded == 0)
{
var sgGoalRecords = from sgids in ct.savinggoals
where sgids.caseid == goals.caseid
select sgids;
int[] arrRecordIds = null;
if (sgGoalRecords != null)
{
int size = sgGoalRecords.ToArray().Length;
arrRecordIds = new int[size];
}
int index = 0;
foreach (savinggoal sgl in sgGoalRecords)
{
arrRecordIds[index] = sgl.id;
index++;
}
var todelExistingAssets = from easg in ct.existingassetsgs
where arrRecordIds.Contains(easg.savinggoalsid)
select easg;
foreach (existingassetsg easgoals in todelExistingAssets)
{
ct.existingassetsgs.DeleteOnSubmit(easgoals);
}
var toDeleteSgGoals = from sg in ct.savinggoals
where sg.caseid == goals.caseid && sg.id != sgid
select sg;
foreach (savinggoal s in toDeleteSgGoals)
{
ct.savinggoals.DeleteOnSubmit(s);
}
}
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
return retrievedGoal;
}
public void updateRiskProfileDetails(RiskProfileAnalysis riskProfile,string type)
{
RiskProfileAnalysis riskProfileAnalysis = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing saving goal
var queryRiskProfileDetails = from al in ct.RiskProfileAnalysis
where al.caseId == riskProfile.caseId
select al;
foreach (RiskProfileAnalysis riskProfileVariable in queryRiskProfileDetails)
{
riskProfileAnalysis = riskProfileVariable;
}
riskProfileAnalysis.caseId=riskProfile.caseId;
riskProfileAnalysis.agreeWithRiskProfileoption1 = riskProfile.agreeWithRiskProfileoption1;
riskProfileAnalysis.agreeWithRiskProfileoption2 = riskProfile.agreeWithRiskProfileoption2;
riskProfileAnalysis.riskApetiteQuestion1option1 = riskProfile.riskApetiteQuestion1option1;
riskProfileAnalysis.riskApetiteQuestion1option2 = riskProfile.riskApetiteQuestion1option2;
riskProfileAnalysis.riskApetiteQuestion1option3 = riskProfile.riskApetiteQuestion1option3;
riskProfileAnalysis.riskApetiteQuestion1option4 = riskProfile.riskApetiteQuestion1option4;
riskProfileAnalysis.riskApetiteQuestion1option5 = riskProfile.riskApetiteQuestion1option5;
riskProfileAnalysis.riskApetiteQuestion1option6 = riskProfile.riskApetiteQuestion1option6;
riskProfileAnalysis.riskApetiteQuestion2option1 = riskProfile.riskApetiteQuestion2option1;
riskProfileAnalysis.riskApetiteQuestion2option2 = riskProfile.riskApetiteQuestion2option2;
riskProfileAnalysis.riskApetiteQuestion2option3 = riskProfile.riskApetiteQuestion2option3;
riskProfileAnalysis.riskApetiteQuestion2option4 = riskProfile.riskApetiteQuestion2option4;
riskProfileAnalysis.riskApetiteQuestion3option1 = riskProfile.riskApetiteQuestion3option1;
riskProfileAnalysis.riskApetiteQuestion3option2 = riskProfile.riskApetiteQuestion3option2;
riskProfileAnalysis.riskApetiteQuestion3option3 = riskProfile.riskApetiteQuestion3option3;
riskProfileAnalysis.riskApetiteQuestion3option4 = riskProfile.riskApetiteQuestion3option4;
riskProfileAnalysis.riskApetiteQuestion3option5 = riskProfile.riskApetiteQuestion3option5;
riskProfileAnalysis.riskApetiteQuestion4option1 = riskProfile.riskApetiteQuestion4option1;
riskProfileAnalysis.riskApetiteQuestion4option2 = riskProfile.riskApetiteQuestion4option2;
riskProfileAnalysis.riskApetiteQuestion4option3 = riskProfile.riskApetiteQuestion4option3;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion1option1 = riskProfile.measuringRiskTakingAbilityQuestion1option1;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion1option2 = riskProfile.measuringRiskTakingAbilityQuestion1option2;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion1option3 = riskProfile.measuringRiskTakingAbilityQuestion1option3;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion1option4 = riskProfile.measuringRiskTakingAbilityQuestion1option4;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion2option1 = riskProfile.measuringRiskTakingAbilityQuestion2option1;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion2option2 = riskProfile.measuringRiskTakingAbilityQuestion2option2;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion2option3 = riskProfile.measuringRiskTakingAbilityQuestion2option3;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion3option1 = riskProfile.measuringRiskTakingAbilityQuestion3option1;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion3option2 = riskProfile.measuringRiskTakingAbilityQuestion3option2;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion3option3 = riskProfile.measuringRiskTakingAbilityQuestion3option3;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion3option4 = riskProfile.measuringRiskTakingAbilityQuestion3option4;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion4option1 = riskProfile.measuringRiskTakingAbilityQuestion4option1;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion4option2 = riskProfile.measuringRiskTakingAbilityQuestion4option2;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion4option3 = riskProfile.measuringRiskTakingAbilityQuestion4option3;
riskProfileAnalysis.measuringRiskTakingAbilityQuestion4option4 = riskProfile.measuringRiskTakingAbilityQuestion4option4;
if (riskProfileAnalysis.agreeWithRiskProfileoption2 == "true")
{
riskProfileAnalysis.riskProfileValue = riskProfile.riskProfileValue;
riskProfileAnalysis.riskProfileName = getRiskProfileName(Int32.Parse(riskProfile.riskProfileValue));
}
else
{
int score = calculateRiskProfile(riskProfile);
riskProfileAnalysis.riskProfileValue = score + "";
String profile_name = getRiskProfileName(score);
riskProfileAnalysis.riskProfileName = profile_name;
}
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public void logException(exceptionlog exLog)
{
try
{
dbDataContext db = new dbDataContext();
db.exceptionlogs.InsertOnSubmit(exLog);
db.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public Boolean updateAssetLiabilityDetails(assetAndLiability assetAndLiability)
{
Boolean status = true;
assetAndLiability assetLiability = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing saving goal
var queryAssetAndLiabilityGoals = from al in ct.assetAndLiabilities
where al.caseId == assetAndLiability.caseId
select al;
foreach (assetAndLiability assetLiabilityGoals in queryAssetAndLiabilityGoals)
{
assetLiability = assetLiabilityGoals;
}
assetLiability.bankAcctCash = assetAndLiability.bankAcctCash;
assetLiability.cashLoan = assetAndLiability.cashLoan;
assetLiability.cpfoaBal = assetAndLiability.cpfoaBal;
assetLiability.creditCard = assetAndLiability.creditCard;
assetLiability.homeMortgage = assetAndLiability.homeMortgage;
assetLiability.ilpCash = assetAndLiability.ilpCash;
assetLiability.ilpCpf = assetAndLiability.ilpCpf;
assetLiability.invPropCash = assetAndLiability.invPropCash;
assetLiability.invPropCpf = assetAndLiability.invPropCpf;
assetLiability.lumpSumCash = assetAndLiability.lumpSumCash;
assetLiability.lumpSumCpf = assetAndLiability.lumpSumCpf;
assetLiability.netWorth = assetAndLiability.netWorth;
assetLiability.regularSumCash = assetAndLiability.regularSumCash;
assetLiability.regularSumCpf = assetAndLiability.regularSumCpf;
assetLiability.resPropCash = assetAndLiability.resPropCash;
assetLiability.resPropCpf = assetAndLiability.resPropCpf;
assetLiability.srsBal = assetAndLiability.srsBal;
assetLiability.srsInvCash = assetAndLiability.srsInvCash;
assetLiability.stocksSharesCash = assetAndLiability.stocksSharesCash;
assetLiability.stocksSharesCpf = assetAndLiability.stocksSharesCpf;
assetLiability.submissionDate = assetAndLiability.submissionDate;
assetLiability.unitTrustsCash = assetAndLiability.unitTrustsCash;
assetLiability.unitTrustsCpf = assetAndLiability.unitTrustsCpf;
assetLiability.vehicleLoan = assetAndLiability.vehicleLoan;
assetLiability.cpfsaBal = assetAndLiability.cpfsaBal;
assetLiability.cpfMediSaveBalance = assetAndLiability.cpfMediSaveBalance;
assetLiability.assetAndLiabilityNeeded = assetAndLiability.assetAndLiabilityNeeded;
assetLiability.assetAndLiabilityNotNeededReason = assetAndLiability.assetAndLiabilityNotNeededReason;
assetLiability.assetIncomePercent = assetAndLiability.assetIncomePercent;
assetLiability.premiumRecomendedNeeded = assetAndLiability.premiumRecomendedNeeded;
var queryliabilityOthers = from liabilityOther in ct.liabilityOthers
where liabilityOther.assetLiabilityId == assetAndLiability.id
select liabilityOther;
foreach (liabilityOther liabilityOthers in queryliabilityOthers)
{
ct.liabilityOthers.DeleteOnSubmit(liabilityOthers);
}
var querypersonalUseAssetsOthers = from personalUseAssetsOther in ct.personalUseAssetsOthers
where personalUseAssetsOther.assetLiabilityId == assetAndLiability.id
select personalUseAssetsOther;
foreach (personalUseAssetsOther personalUseAssetsOther in querypersonalUseAssetsOthers)
{
ct.personalUseAssetsOthers.DeleteOnSubmit(personalUseAssetsOther);
}
var queryinvestedAssetOthers = from investedAssetOthers in ct.investedAssetOthers
where investedAssetOthers.assetLiabilityId == assetAndLiability.id
select investedAssetOthers;
foreach (investedAssetOther investedAssetOther in queryinvestedAssetOthers)
{
ct.investedAssetOthers.DeleteOnSubmit(investedAssetOther);
}
//update liability others list for the AssetLiability goal
if (assetAndLiability.liabilityOthers != null && assetAndLiability.liabilityOthers.Count > 0)
{
EntitySet<liabilityOther> liabilityOtherSet = new EntitySet<liabilityOther>();
foreach (liabilityOther liabilityOther in assetAndLiability.liabilityOthers)
{
liabilityOtherSet.Add(liabilityOther);
}
assetLiability.liabilityOthers = liabilityOtherSet;
}
//update personal UseAssets others list for the AssetLiability
if (assetAndLiability.personalUseAssetsOthers != null && assetAndLiability.personalUseAssetsOthers.Count > 0)
{
EntitySet<personalUseAssetsOther> personalUseAssetsOtherSet = new EntitySet<personalUseAssetsOther>();
foreach (personalUseAssetsOther liabilityOther in assetAndLiability.personalUseAssetsOthers)
{
personalUseAssetsOtherSet.Add(liabilityOther);
}
assetLiability.personalUseAssetsOthers = personalUseAssetsOtherSet;
}
//update invested others list for the AssetLiability
if (assetAndLiability.investedAssetOthers != null && assetAndLiability.investedAssetOthers.Count > 0)
{
EntitySet<investedAssetOther> investedAssetOtherSet = new EntitySet<investedAssetOther>();
foreach (investedAssetOther investedAssetOther in assetAndLiability.investedAssetOthers)
{
investedAssetOtherSet.Add(investedAssetOther);
}
assetLiability.investedAssetOthers = investedAssetOtherSet;
}
ct.SubmitChanges();
}
catch (Exception e)
{
status = false;
string str = e.Message;
}
return status;
}
public myNeed updateMyNeeds(myNeed needs)
{
myNeed retrievedNeed = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing my need
var queryMyNeeds = from myneed in ct.myNeeds
where myneed.caseId == needs.caseId
select myneed;
foreach (myNeed myNeeds in queryMyNeeds)
{
retrievedNeed = myNeeds;
}
//update my need attributes
retrievedNeed.lumpSumRequiredForTreatment = needs.lumpSumRequiredForTreatment;
retrievedNeed.totalRequired = needs.totalRequired;
retrievedNeed.criticalIllnessInsurance = needs.criticalIllnessInsurance;
retrievedNeed.existingAssetsMyneeds = needs.existingAssetsMyneeds;
retrievedNeed.totalShortfallSurplusMyNeeds = needs.totalShortfallSurplusMyNeeds;
retrievedNeed.lumpSumMyNeeds = needs.lumpSumMyNeeds;
retrievedNeed.existingSumMyNeeds = needs.existingSumMyNeeds;
retrievedNeed.shortfallSumMyNeeds = needs.shortfallSumMyNeeds;
retrievedNeed.monthlyIncomeDisabilityIncome = needs.monthlyIncomeDisabilityIncome;
retrievedNeed.percentOfIncomeCoverageRequired = needs.percentOfIncomeCoverageRequired;
retrievedNeed.monthlyCoverageRequired = needs.monthlyCoverageRequired;
retrievedNeed.disabilityInsuranceMyNeeds = needs.disabilityInsuranceMyNeeds;
retrievedNeed.existingAssetsMyneedsDisability = needs.existingAssetsMyneedsDisability;
retrievedNeed.shortfallSurplusMyNeeds = needs.shortfallSurplusMyNeeds;
retrievedNeed.monthlyAmountMyNeeds = needs.monthlyAmountMyNeeds;
retrievedNeed.existingMyNeeds = needs.existingMyNeeds;
retrievedNeed.shortfallMyNeeds = needs.shortfallMyNeeds;
retrievedNeed.typeOfHospitalCoverage = needs.typeOfHospitalCoverage;
retrievedNeed.anyExistingPlans = needs.anyExistingPlans;
retrievedNeed.typeOfRoomCoverage = needs.typeOfRoomCoverage;
retrievedNeed.coverageOldageYesNo = needs.coverageOldageYesNo;
retrievedNeed.epOldageYesNo = needs.epOldageYesNo;
retrievedNeed.coverageIncomeYesNo = needs.coverageIncomeYesNo;
retrievedNeed.epIncomeYesNo = needs.epIncomeYesNo;
retrievedNeed.coverageOutpatientYesNo = needs.coverageOutpatientYesNo;
retrievedNeed.epOutpatientYesNo = needs.epOutpatientYesNo;
retrievedNeed.coverageDentalYesNo = needs.coverageDentalYesNo;
retrievedNeed.epDentalYesNo = needs.epDentalYesNo;
retrievedNeed.coveragePersonalYesNo = needs.coveragePersonalYesNo;
retrievedNeed.epPersonalYesNo = needs.epPersonalYesNo;
retrievedNeed.criticalIllnessPrNeeded = needs.criticalIllnessPrNeeded;
retrievedNeed.disabilityPrNeeded = needs.disabilityPrNeeded;
retrievedNeed.hospitalmedCoverNeeded = needs.hospitalmedCoverNeeded;
retrievedNeed.accidentalhealthCoverNeeded = needs.accidentalhealthCoverNeeded;
retrievedNeed.coverageOutpatientMedExp = needs.coverageOutpatientMedExp;
retrievedNeed.epOutpatientMedExp = needs.epOutpatientMedExp;
retrievedNeed.coverageLossOfIncome = needs.coverageLossOfIncome;
retrievedNeed.epLossOfIncome = needs.epLossOfIncome;
retrievedNeed.coverageOldageDisabilities = needs.coverageOldageDisabilities;
retrievedNeed.epOldageDisabilities = needs.epOldageDisabilities;
retrievedNeed.coverageDentalExp = needs.coverageDentalExp;
retrievedNeed.epDentalExp = needs.epDentalExp;
if ((needs.anyExistingPlans == true) || (needs.epOldageYesNo == true) || (needs.epPersonalYesNo == true) || (needs.epOutpatientMedExp == true) || (needs.epLossOfIncome == true) || (needs.epOldageDisabilities == true) || (needs.epDentalExp == true))
{
retrievedNeed.existingPlansDetail = needs.existingPlansDetail;
}
else
retrievedNeed.existingPlansDetail = "";
// retrievedNeed.existingPlansDetail = needs.existingPlansDetail;
retrievedNeed.disabilityProtectionReplacementIncomeRequired = needs.disabilityProtectionReplacementIncomeRequired;
retrievedNeed.disabilityProtectionReplacementIncomeRequiredPercentage =needs.disabilityProtectionReplacementIncomeRequiredPercentage;
retrievedNeed.replacementIncomeRequired = needs.replacementIncomeRequired;
retrievedNeed.yearsOfSupportRequired = needs.yearsOfSupportRequired;
retrievedNeed.disabilityYearsOfSupport = needs.disabilityYearsOfSupport;
retrievedNeed.inflatedAdjustedReturns = needs.inflatedAdjustedReturns;
retrievedNeed.replacementAmountRequired = needs.replacementAmountRequired;
retrievedNeed.disabilityReplacementAmountRequired = needs.disabilityReplacementAmountRequired;
retrievedNeed.disabilityInsurance = needs.disabilityInsurance;
retrievedNeed.inflationAdjustedReturns = needs.inflationAdjustedReturns;
//delete existing assets for my needs critical illness
var queryExistingCriticalAssets = from eamyneed in ct.myNeedsCriticalAssets
where eamyneed.myNeedId == retrievedNeed.id
select eamyneed;
foreach (myNeedsCriticalAsset eamyneeds in queryExistingCriticalAssets)
{
ct.myNeedsCriticalAssets.DeleteOnSubmit(eamyneeds);
//ct.SubmitChanges();
}
//update existing assets list for my needs critical illness
if (needs.myNeedsCriticalAssets != null && needs.myNeedsCriticalAssets.Count > 0)
{
EntitySet<myNeedsCriticalAsset> eaMNCriticalList = new EntitySet<myNeedsCriticalAsset>();
foreach (myNeedsCriticalAsset mnea in needs.myNeedsCriticalAssets)
{
eaMNCriticalList.Add(mnea);
}
retrievedNeed.myNeedsCriticalAssets = eaMNCriticalList;
}
//delete existing assets for my needs disability income
var queryExistingDisablityAssets = from eamyneed in ct.myNeedsDisabilityAssets
where eamyneed.myNeedId == retrievedNeed.id
select eamyneed;
foreach (myNeedsDisabilityAsset eamyneeds in queryExistingDisablityAssets)
{
ct.myNeedsDisabilityAssets.DeleteOnSubmit(eamyneeds);
//ct.SubmitChanges();
}
//update existing assets list for disability income
if (needs.myNeedsDisabilityAssets != null && needs.myNeedsDisabilityAssets.Count > 0)
{
EntitySet<myNeedsDisabilityAsset> eaMNDisabilityList = new EntitySet<myNeedsDisabilityAsset>();
foreach (myNeedsDisabilityAsset mnea in needs.myNeedsDisabilityAssets)
{
eaMNDisabilityList.Add(mnea);
}
retrievedNeed.myNeedsDisabilityAssets = eaMNDisabilityList;
}
ct.SubmitChanges();
}
catch (Exception ex)
{
logException(ex);
throw ex;
}
return retrievedNeed;
}
public personaldetail updatePersonalDetails(personaldetail personalDetail)
{
dbDataContext ct = new dbDataContext();
personaldetail detail = null;
//retrieve existing saving goal
var queryPersonalDetails = from al in ct.personaldetails
where al.caseid == personalDetail.caseid
select al;
foreach (personaldetail personalDetailObject in queryPersonalDetails)
{
detail = personalDetailObject;
}
detail.name = personalDetail.name;
detail.surname = personalDetail.surname;
detail.address = personalDetail.address;
detail.companyname = personalDetail.companyname;
detail.contactnumber = personalDetail.contactnumber;
detail.contactnumberfax = personalDetail.contactnumberfax;
detail.contactnumberhp = personalDetail.contactnumberhp;
detail.contactnumberoffice = personalDetail.contactnumberoffice;
detail.datepicker = personalDetail.datepicker;
detail.educationlevel = personalDetail.educationlevel;
detail.email = personalDetail.email;
detail.employmentstatus = personalDetail.employmentstatus;
detail.gender = personalDetail.gender;
detail.maritalstatus = personalDetail.maritalstatus;
detail.medicalcondition = personalDetail.medicalcondition;
detail.medicalconditiondetails = personalDetail.medicalconditiondetails;
detail.nationality = personalDetail.nationality;
detail.nationalityothers = personalDetail.nationalityothers;
detail.nominee = personalDetail.nominee;
detail.will = personalDetail.will;
detail.nric = personalDetail.nric;
detail.occupation = personalDetail.occupation;
detail.title = personalDetail.title;
detail.titleothers = personalDetail.titleothers;
detail.issmoker = personalDetail.issmoker;
detail.familyDetailsRequired = personalDetail.familyDetailsRequired;
detail.spokenLanguage = personalDetail.spokenLanguage;
detail.spokenLanguageOtherstxt = personalDetail.spokenLanguageOtherstxt;
detail.writtenLanguage = personalDetail.writtenLanguage;
detail.writtenLanguageOtherstxt = personalDetail.writtenLanguageOtherstxt;
detail.accompanyQuestion = personalDetail.accompanyQuestion;
detail.trustedIndividualName = personalDetail.trustedIndividualName;
detail.clientRelationship = personalDetail.clientRelationship;
detail.NRICAccompany = personalDetail.NRICAccompany;
detail.noAccompaniedIndividualReason = personalDetail.noAccompaniedIndividualReason;
var queryfamilyMembers = from familyMemberDetails in ct.familyMemberDetails
where familyMemberDetails.personalDetailId == detail.id
select familyMemberDetails;
foreach (familyMemberDetail familyMembers in queryfamilyMembers)
{
ct.familyMemberDetails.DeleteOnSubmit(familyMembers);
}
if (detail.familyDetailsRequired == "1")
{
//update family member details
if (personalDetail.familyMemberDetails != null && personalDetail.familyMemberDetails.Count > 0)
{
EntitySet<familyMemberDetail> familyMemberDetailSet = new EntitySet<familyMemberDetail>();
foreach (familyMemberDetail familyDetail in personalDetail.familyMemberDetails)
{
familyMemberDetailSet.Add(familyDetail);
}
detail.familyMemberDetails = familyMemberDetailSet;
}
}
ct.SubmitChanges();
return detail;
}
public void saveClonemapping(clonemappingid clonemapping)
{
try
{
dbDataContext db = new dbDataContext();
db.clonemappingids.InsertOnSubmit(clonemapping);
db.SubmitChanges();
}
catch (Exception e)
{
//log exception to db
exceptionlog exLog = new exceptionlog();
exLog.message = e.Message + " class: ActivityStatusDAO Method: saveClonemapping";
exLog.source = e.Source;
string strtmp = e.StackTrace;
strtmp = strtmp.Replace('\r', ' ');
strtmp = strtmp.Replace('\n', ' ');
exLog.stacktrace = strtmp;
exLog.targetsitename = e.TargetSite.Name;
logException(exLog);
}
}
public void saveOrUpdateActivityStatus(string caseid, string activity, string status)
{
activitystatus actstatus = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing activity status
var queryActivityStatus = from actst in ct.activitystatus
where actst.caseid == caseid && actst.activity == activity
select actst;
foreach (activitystatus a in queryActivityStatus)
{
actstatus = a;
}
if (actstatus == null)
{
//adding new status
activitystatus actStatus = new activitystatus();
actStatus.caseid = caseid;
actStatus.activity = activity;
actStatus.status = status;
ct.activitystatus.InsertOnSubmit(actStatus);
}
else
{
//update activity status
actstatus.status = status;
}
ct.SubmitChanges();
}
catch (Exception e)
{
string str = e.Message;
}
}
public void saveSalesPortalInfo(string caseid, salesportalinfo salesPortalInfo)
{
salesportalinfo spistatus = null;
try
{
dbDataContext ct = new dbDataContext();
//retrieve existing sales portal info
var querySalesPortalInfo = from spi in ct.salesportalinfos
where spi.activityid == caseid
select spi;
foreach (salesportalinfo a in querySalesPortalInfo)
{
spistatus = a;
}
if (spistatus == null)
{
//adding new sales portal info
ct.salesportalinfos.InsertOnSubmit(salesPortalInfo);
}
else
{
//update sales portal info
spistatus.activitytype = salesPortalInfo.activitytype;
spistatus.caseid = salesPortalInfo.caseid;
spistatus.redirecturl = salesPortalInfo.redirecturl;
spistatus.roletype = salesPortalInfo.roletype;
spistatus.salesportalurl = salesPortalInfo.salesportalurl;
spistatus.userfirstname = salesPortalInfo.userfirstname;
spistatus.userid = salesPortalInfo.userid;
spistatus.userlastname = salesPortalInfo.userlastname;
spistatus.usertype = salesPortalInfo.usertype;
spistatus.casestatus = salesPortalInfo.casestatus;
spistatus.country = salesPortalInfo.country;
spistatus.saleschannel = salesPortalInfo.saleschannel;
}
ct.SubmitChanges();
}
catch (Exception e)
{
//log exception to db
exceptionlog exLog = new exceptionlog();
exLog.message = e.Message + " class: ActivityStatusDAO Method: saveSalesPortalInfo";
exLog.source = e.Source;
string strtmp = e.StackTrace;
strtmp = strtmp.Replace('\r', ' ');
strtmp = strtmp.Replace('\n', ' ');
exLog.stacktrace = strtmp;
exLog.targetsitename = e.TargetSite.Name;
logException(exLog);
}
}