public savinggoal saveSavingGoals(savinggoal goals)
{
int status = 1;
try
{
dbDataContext ct = new dbDataContext();
ct.savinggoals.InsertOnSubmit(goals);
ct.SubmitChanges();
}
catch (Exception e)
{
status = 0;
string str = e.Message;
}
if (status == 0)
{
goals = null;
}
return goals;
}
private void populateSavingGoal(savinggoal savingGoal, assumption assmptn, string caseid)
{
double shortfallSurplus = 0;
savingGoalNeeded2.Selected = true;
if (savingGoal != null)
{
savingGoalNeeded.SelectedValue = savingGoal.savingGoalNeeded.ToString();
goal.Text = savingGoal.goal;
yrstoAccumulate.Text = savingGoal.yrstoaccumulate;
if(savingGoal.amtneededfv!=null && savingGoal.amtneededfv!="")
{
futureValue.Text = savingGoal.amtneededfv;
}
else
{
futureValue.Text = "0";
}
if(savingGoal.maturityvalue!=null && savingGoal.maturityvalue!="")
{
maturityValue.Text = savingGoal.maturityvalue;
}
else
{
maturityValue.Text = "0";
}
assetList.DataSource = savingGoal.existingassetsgs;
assetList.DataBind();
if (savingGoal.existingassetsgs != null)
{
ViewState["noofassets"] = savingGoal.existingassetsgs.Count;
if (savingGoal.existingassetstotal != null && savingGoal.existingassetstotal != "")
{
existingAssets.Text = savingGoal.existingassetstotal;
}
else
{
existingAssets.Text = "0";
}
}
shortfallSurplus = (double.Parse(existingAssets.Text) + double.Parse(maturityValue.Text)) - double.Parse(futureValue.Text);
totalShortfallSurplus.Text = Math.Abs(shortfallSurplus).ToString();
}
if (shortfallSurplus < 0)
{
ttlSS.Text = "Shortfall";
ttlSS.Style.Add("color", "red");
}
else if (shortfallSurplus > 0)
{
ttlSS.Text = "Surplus";
ttlSS.Style.Add("color", "black");
}
else
{
ttlSS.Text = "Shortfall / Surplus";
ttlSS.Style.Add("color", "black");
}
activityId.Value = caseid;
}
protected void submitSavingGoals(object sender, EventArgs e)
{
savinggoal goals = new savinggoal();
goals.savingGoalNeeded = Convert.ToInt16(savingGoalNeeded.SelectedValue);
if (goals.savingGoalNeeded == 2)
{
goals.goal = goal.Text;
goals.yrstoaccumulate = yrstoAccumulate.Text;
goals.amtneededfv = futureValue.Text;
goals.maturityvalue = maturityValue.Text;
if (totalShortfallSurplus.Text != null && totalShortfallSurplus.Text != "")
{
double ttl = double.Parse(totalShortfallSurplus.Text);
if (ttl < 0)
{
totalShortfallSurplus.Text = Math.Abs(ttl).ToString();
}
}
goals.total = totalShortfallSurplus.Text;
goals.existingassetstotal = existingAssets.Text;
}
else if (goals.savingGoalNeeded == 1 || goals.savingGoalNeeded == 0)
{
goals.goal = "";
goals.yrstoaccumulate = "0";
goals.amtneededfv = "0";
goals.maturityvalue = "0";
goals.total = "0";
goals.existingassetstotal = "0";
}
goals.deleted = false;
string caseid = "";
if (ViewState["caseid"] != null)
{
caseid = ViewState["caseid"].ToString();
goals.caseid = caseid;
}
int noofea = 0;
if (goals.savingGoalNeeded == 2)
{
if (noofmembers.Value != "")
{
noofea = Int16.Parse(noofmembers.Value);
}
}
EntitySet<existingassetsg> easgList = new EntitySet<existingassetsg>();
if (noofea > 0)
{
for (int i = 1; i <= noofea; i++)
{
existingassetsg easg = new existingassetsg();
easg.asset = Request.Form["pridesc-" + i];
easg.presentvalue = Request.Form["pri_" + i];
easg.percentpa = Request.Form["sec_" + i];
if ((Request.Form["pridesc-" + i] != null) && (Request.Form["pri_" + i] != null) && (Request.Form["sec_" + i]!=null))
{
easgList.Add(easg);
}
}
goals.existingassetsgs = easgList;
}
int sgid = 0;
if (ViewState["sgid"] != null)
{
sgid = Int32.Parse(ViewState["sgid"].ToString());
}
if (ViewState["casetype"] != null && ViewState["casetype"].ToString() == "new")
{
goals = savingGoalsDao.saveSavingGoals(goals);
}
else if (ViewState["casetype"] != null && ViewState["casetype"].ToString() == "update")
{
goals = savingGoalsDao.updateSavingGoals(goals, sgid);
}
string actv = "";
if (ViewState["activity"] != null)
{
actv = ViewState["activity"].ToString();
}
string status = activityStatusCheck.getSavingGoalStatus(caseid);
activityStatusDao.saveOrUpdateActivityStatus(caseid, actv, status);
markStatusOnTab(caseid);
string caseStatus = activityStatusCheck.getZPlanStatus(caseid);
string url = Server.MapPath("~/_layouts/Zurich/Printpages/");
pdfData = activityStatusCheck.sendDataToSalesPortal(caseid, caseStatus, url, sendPdf);
/*if (st == 1)
{
lblStatusSubmitted.Visible = false;
}
else
{
lblStatusSubmissionFailed.Visible = true;
}*/
if (goals != null)
{
lblSavingGoalSuccess.Visible = true;
savingGoal = savingGoalsDao.getSavingGoal(caseid);
savinggoal displaysg = null;
if (savingGoal != null && savingGoal.Count > 0)
{
if (addandsave.Value == "1")
{
displaysg = savingGoal[savingGoal.Count-1];
}
else
{
bool found = false;
int count = 0;
foreach (savinggoal sgl in savingGoal)
{
if (sgid == sgl.id)
{
found = true;
break;
}
count++;
}
if (found)
{
displaysg = savingGoal[count];
}
else
{
displaysg = savingGoal[0];
}
}
savinggoalid.Value = displaysg.id.ToString();
addandsave.Value = "";
}
populateSavingGoal(displaysg, assmptn, caseid);
List<savinggoal> gridgoal = savingGoal;
foreach (savinggoal s in gridgoal)
{
double damtfv = 0;
double dmaturityval = 0;
double deattl = 0;
if (s.amtneededfv != null && s.amtneededfv != "")
{
damtfv = double.Parse(s.amtneededfv);
}
if (s.maturityvalue != null && s.maturityvalue != "")
{
dmaturityval = double.Parse(s.maturityvalue);
}
if (s.existingassetstotal != null && s.existingassetstotal != "")
{
deattl = double.Parse(s.existingassetstotal);
}
if (((dmaturityval + deattl) - damtfv) < 0)
{
s.total = "-" + s.total;
}
}
//existingsggrid.DataSource = savingGoal;
existingsggrid.DataSource = gridgoal;
existingsggrid.DataBind();
//refreshSavingGoal();
}
else
{
lblSavingGoalFailed.Visible = true;
}
}
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;
}
partial void Deletesavinggoal(savinggoal instance);
partial void Updatesavinggoal(savinggoal instance);
partial void Insertsavinggoal(savinggoal instance);
