private void saveSwitch(clsSwitch.enumSwitchStatus SwitchStatus, Nullable <int> intSwitchID, string strDescription)
{
List <clsSwitchDetails> newListSwitchDetails = (List <clsSwitchDetails>)Session["SwitchDetails"];
int intNewSwitchID = clsSwitch.insertSwitchHeader(PortfolioID(), ClientID(), UserID(), SwitchStatus, intSwitchID, strDescription);
clsSwitchDetails.insertSwitchDetails(newListSwitchDetails, UserID(), intNewSwitchID);
}
private void enableButtons(clsSwitch.enumSwitchStatus SwitchStatus)
{
switch (SwitchStatus)
{
case clsSwitch.enumSwitchStatus.Proposed:
this.btnApproveSwitch.Disabled = false;
this.btnAmendSwitch.Enabled = true;
this.btnDeclineSwitch.Enabled = true;
this.btnContactMe.Enabled = true;
break;
case clsSwitch.enumSwitchStatus.Request_ForDiscussion:
this.btnApproveSwitch.Disabled = true;
this.btnAmendSwitch.Enabled = false;
this.btnDeclineSwitch.Enabled = false;
this.btnContactMe.Enabled = false;
break;
default:
this.btnApproveSwitch.Disabled = true;
this.btnAmendSwitch.Enabled = false;
this.btnDeclineSwitch.Enabled = false;
this.btnContactMe.Enabled = false;
break;
}
}
private void saveclientSwitch(clsSwitch.enumSwitchStatus SwitchStatus, int intSwitchID, string strDesc)
{
strUserID = Session[clsSystem_Session.strSession.User.ToString()].ToString();
strClientID = Session[clsSystem_Session.strSession.clientID.ToString()].ToString();
strPortfolioID = Session[clsSystem_Session.strSession.tempportfolioid.ToString()].ToString();
List <clsSwitchDetails_Client> newListSwitchDetails = (List <clsSwitchDetails_Client>)Session["SwitchDetails_Client"];
clsSwitch_Client.updateSwitchHeader(SwitchStatus, intSwitchID, strDesc);
clsSwitchDetails_Client.insertSwitchDetails(newListSwitchDetails, strUserID, intSwitchID);
}
private void saveSwitch(clsSwitch.enumSwitchStatus SwitchStatus, Nullable <int> intSwitchID, string strDescription, string strUserID, clsScheme Scheme)
{
List <clsSwitchScheme.clsSwitchSchemeDetails> newListSwitchDetails = (List <clsSwitchScheme.clsSwitchSchemeDetails>)Session["listSwitchDetails"];
List <clsSwitchScheme.clsSwitchSchemeDetails> newListSwitchDetailsContribution = (List <clsSwitchScheme.clsSwitchSchemeDetails>)Session["listSwitchContributionDetails"];
clsSwitchScheme.clsSwitchSchemeDetails.deleteAllDetails(intSwitchID);
int intNewSwitchID = clsSwitchScheme.insertSwitchHeader(Scheme, strUserID, SwitchStatus, intSwitchID, strDescription);
clsSwitchScheme.clsSwitchSchemeDetails.insertSwitchDetails(newListSwitchDetails, strUserID, intNewSwitchID, false);
clsSwitchScheme.clsSwitchSchemeDetails.insertSwitchDetails(newListSwitchDetailsContribution, strUserID, intNewSwitchID, true);
}
private void saveclientSwitch(clsSwitch.enumSwitchStatus SwitchStatus, int intSwitchID, string strDesc)
{
String strUserID = Session[clsSystem_Session.strSession.User.ToString()].ToString();
clsSwitchScheme_Client.clsSwitchSchemeDetails_Client.deleteAllDetails(intSwitchID);
List <clsSwitchScheme_Client.clsSwitchSchemeDetails_Client> ListSwitchDetails = (List <clsSwitchScheme_Client.clsSwitchSchemeDetails_Client>)Session["SwitchSchemeDetailsPortfolio_Client"];
List <clsSwitchScheme_Client.clsSwitchSchemeDetails_Client> ListSwitchDetailsContribution = (List <clsSwitchScheme_Client.clsSwitchSchemeDetails_Client>)Session["SwitchSchemeDetailsContribution_Client"];
clsSwitchScheme_Client.updateSwitchHeader(SwitchStatus, intSwitchID, strDesc);
clsSwitchScheme_Client.clsSwitchSchemeDetails_Client.insertSwitchDetails(ListSwitchDetails, strUserID, propSwitchID, false);
clsSwitchScheme_Client.clsSwitchSchemeDetails_Client.insertSwitchDetails(ListSwitchDetailsContribution, strUserID, propSwitchID, true);
}
public static void updateSwitchHeader(int intSwitchID, clsSwitch.enumSwitchStatus SwitchStatus)
{
SqlConnection con = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection;
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[SWITCHSCheme_HeaderUpdate]";
cmd.Parameters.Add("@param_intSwitchID", System.Data.SqlDbType.Int).Value = intSwitchID;
cmd.Parameters.Add("@param_Status", System.Data.SqlDbType.SmallInt).Value = SwitchStatus;
cmd.ExecuteNonQuery();
}
public static int insertSwitchHeader(clsScheme Scheme, string strUserID, clsSwitch.enumSwitchStatus SwitchStatus, Nullable <int> intSwitchID, string strDescription)
{
SqlConnection con = new clsSwitchScheme().con;
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[SWITCHScheme_HeaderInsert]";
cmd.Parameters.Add("@param_strSchemeID", System.Data.SqlDbType.NVarChar).Value = Scheme.propSchemeID;
cmd.Parameters.Add("@param_strClientID", System.Data.SqlDbType.NVarChar).Value = Scheme.propClient.propClientID;
cmd.Parameters.Add("@param_intStatus", System.Data.SqlDbType.SmallInt).Value = SwitchStatus;
cmd.Parameters.Add("@param_strCreated_By", System.Data.SqlDbType.NVarChar).Value = strUserID;
cmd.Parameters.Add("@param_intSwitchID", System.Data.SqlDbType.Int).Value = intSwitchID;
cmd.Parameters.Add("@param_strDescription", System.Data.SqlDbType.NVarChar).Value = strDescription;
return(int.Parse(cmd.ExecuteScalar().ToString()));
}
private int saveCustomizedSwitch(int intIFA_ID, string strClientID, string strPortfolioID, string strUserID, clsSwitch.enumSwitchStatus enumSwitchStatus, Nullable <int> intSwitchID, string strModelGroupID, string strModelPortfolioID)
{
int intNewSwitchID = clsSwitch.insertCustomizedSwitchHeaderWithModel(intIFA_ID, strClientID, strPortfolioID, strUserID, enumSwitchStatus, intSwitchID, strModelGroupID, strModelPortfolioID);
clsSwitch.deleteSwitchDetails(intNewSwitchID);
clsSwitchDetails.insertSwitchDetails(intNewSwitchID, strClientID, strPortfolioID);
return(intNewSwitchID);
}
private int saveSwitch(string strClientID, string strPortfolioID, string strUserID, clsSwitch.enumSwitchStatus enumSwitchStatus, int intSwitchID, List <clsSwitchDetails> clsSwitchDetailsList, string strDescription, int intModelID, string strModelGroupID, string strModelPortfolioID)
{
int intNewSwitchID = clsSwitch.insertSwitchHeaderWithModel(strPortfolioID, strClientID, strUserID, enumSwitchStatus, intSwitchID, strDescription, intModelID, ModelID(), ModelPortfolioID());
clsSwitch.deleteSwitchDetails(intNewSwitchID);
clsSwitchDetails.insertSwitchDetails(clsSwitchDetailsList, strUserID, intNewSwitchID);
return(intNewSwitchID);
}
private void saveSwitchHistory(clsPortfolio _clsPortfolio, int intSwitchID, string strPortfolioID, string strUserID, clsSwitch.enumSwitchStatus enumSwitchStatus, string strDescription)
{
clsSwitch oSwitch = new clsSwitch(_clsPortfolio, strUserID);
int intHistoryID = clsHistory.insertHeader(strPortfolioID, intSwitchID, Convert.ToInt16(enumSwitchStatus));
clsHistory.insertDetailsIFA(intHistoryID, oSwitch.propSwitchDetails);
clsHistory.insertMessage(intHistoryID, strDescription);
}
private void doSwitchSendSave(string strButtonClick)
{
String strSchemeID = Session[clsSystem_Session.strSession.tempschemeid.ToString()].ToString();
String strUserID = Session[clsSystem_Session.strSession.User.ToString()].ToString();
String strClientID = Session[clsSystem_Session.strSession.clientID.ToString()].ToString();
captureSwitchGridviewDetails();
List <clsSwitchScheme.clsSwitchSchemeDetails> SwitchDetails = (List <clsSwitchScheme.clsSwitchSchemeDetails>)Session["listSwitchDetails"];
clsScheme Scheme = new clsScheme(strClientID, strSchemeID);
string strSchemeName = Scheme.propCompany.propCompany;
int intDiscretionary = int.Parse(Session["HasDiscretionary"].ToString());
int intSwitchID = SwitchDetails[0].propSwitchScheme.propSwitchID;
if (strButtonClick == enumButton.Approve.ToString())
{
clsSwitchScheme.clsSwitchSchemeDetails.deleteAllDetails(intSwitchID);
clsSwitchScheme.clsSwitchSchemeDetails.transferClientSwitchToIFA(new clsSwitchScheme_Client(intSwitchID).propSwitchDetailsPortfolio, strUserID, false, true);
clsSwitchScheme.clsSwitchSchemeDetails.transferClientSwitchToIFA(new clsSwitchScheme_Client(intSwitchID).propSwitchDetailsContribution, strUserID, true, false);
clsSwitchScheme_Client.updateSwitchHeader(clsSwitch.enumSwitchStatus.Approved, intSwitchID, string.Empty);
clsSwitchScheme.updateSwitchHeader(intSwitchID, clsSwitch.enumSwitchStatus.Approved);
int intHistoryID = clsHistory.clsHistoryScheme.insertHeader(strSchemeID, intSwitchID, (Int16)clsSwitch.enumSwitchStatus.Approved);
clsSwitchScheme SwitchScheme = new clsSwitchScheme(intSwitchID);
clsHistory.clsHistoryScheme.insertDetailsIFA(intHistoryID, SwitchScheme.propSwitchDetails, false);
clsHistory.clsHistoryScheme.insertDetailsIFA(intHistoryID, SwitchScheme.propSwitchDetailsContribution, true);
clsHistory.clsHistoryScheme.insertMessage(intHistoryID, txtDescription.Text);
}
else if (strButtonClick == enumButton.Resubmit.ToString())
{
saveSwitch(clsSwitch.enumSwitchStatus.Proposed, intSwitchID, txtDescription.Text, strUserID, Scheme);
clsSwitchScheme_Client.updateSwitchHeader(clsSwitch.enumSwitchStatus.Proposed, intSwitchID, string.Empty);
int intHistoryID = clsHistory.clsHistoryScheme.insertHeader(strSchemeID, intSwitchID, (Int16)clsSwitch.enumSwitchStatus.Proposed);
clsSwitchScheme SwitchScheme = new clsSwitchScheme(intSwitchID);
clsHistory.clsHistoryScheme.insertDetailsIFA(intHistoryID, SwitchScheme.propSwitchDetails, false);
clsHistory.clsHistoryScheme.insertDetailsIFA(intHistoryID, SwitchScheme.propSwitchDetailsContribution, true);
clsHistory.clsHistoryScheme.insertMessage(intHistoryID, txtDescription.Text);
}
else
{
clsSwitch.enumSwitchStatus status = (intDiscretionary == 1 || intDiscretionary == -1) ? clsSwitch.enumSwitchStatus.Approved : clsSwitch.enumSwitchStatus.Proposed;
if (intSwitchID == 0)
{
saveSwitch(status, null, txtDescription.Text.Trim(), strUserID, Scheme);
}
else
{
saveSwitch(status, intSwitchID, txtDescription.Text.Trim(), strUserID, Scheme);
}
intSwitchID = new clsSwitchScheme(Scheme).propSwitchID;
clsSwitchScheme SwitchScheme = new clsSwitchScheme(intSwitchID);
int intHistoryID = clsHistory.clsHistoryScheme.insertHeader(strSchemeID, intSwitchID, (Int16)clsSwitch.enumSwitchStatus.Proposed);
clsHistory.clsHistoryScheme.insertDetailsIFA(intHistoryID, SwitchScheme.propSwitchDetails, false);
clsHistory.clsHistoryScheme.insertDetailsIFA(intHistoryID, SwitchScheme.propSwitchDetailsContribution, true);
clsHistory.clsHistoryScheme.insertMessage(intHistoryID, txtDescription.Text);
}
string strMessage = clsSMS.subclsSMSTemplate.getSMSTemplate(clsSMS.subclsSMSTemplate.enumSMSTemplateID.ProposeSchemeSwitch.ToString());
strMessage = clsSMS.subclsSMSTemplate.convertSMSMessage(strMessage, null, null, null, null, Scheme);
string strPopupMessage = "Message sent.";
string strSMSMobileNo = txtSMSMobileNo.Text.Trim();
if (strSMSMobileNo.Length != 0)
{
sendSMS(strUserID, strMessage, strPopupMessage, strSMSMobileNo);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + strPopupMessage + "'); window.location='" + this.propBackPageURL + "';", true);
}
