/// <summary>
/// Function to enter Adviser Subscription Plan details into the AdviserPlanDetails table
/// </summary>
/// <param name="adviserSubscriptionVo"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool CreateAdviserSubscriptionPlans(AdviserSubscriptionVo adviserSubscriptionVo, int userId)
{
bool bResult = false;
AdviserSubscriptionDao adviserSubscriptionDao = new AdviserSubscriptionDao();
try
{
bResult = adviserSubscriptionDao.CreateAdviserSubscriptionPlans(adviserSubscriptionVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdviserSubscriptionBo.cs:CreateAdviserSubscriptionPlans()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
/// <summary>
/// Function to create a new Adviser Subscription
/// </summary>
/// <param name="adviserSubscriptionVo"></param>
/// <param name="userId"></param>
/// <returns></returns>
public int CreateAdviserSubscription(AdviserSubscriptionVo adviserSubscriptionVo, int userId)
{
int subscriptionId = 0;
AdviserSubscriptionDao adviserSubscriptionDao = new AdviserSubscriptionDao();
try
{
subscriptionId = adviserSubscriptionDao.CreateAdviserSubscription(adviserSubscriptionVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdviserSubscriptionBo.cs:GetWerpPlanFlavours()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(subscriptionId);
}
/// <summary>
/// Function to create a new Adviser Subscription
/// </summary>
/// <param name="adviserSubscriptionVo"></param>
/// <param name="userId"></param>
/// <returns></returns>
public int CreateAdviserSubscription(AdviserSubscriptionVo adviserSubscriptionVo, int userId)
{
int subscriptionId = 0;
Database db;
DbCommand createAdviserSubscriptionCmd;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
createAdviserSubscriptionCmd = db.GetStoredProcCommand("SP_CreateAdviserSubscription");
db.AddInParameter(createAdviserSubscriptionCmd, "@A_AdviserId", DbType.Int32, adviserSubscriptionVo.AdviserId);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_TrialStartDate", DbType.DateTime, adviserSubscriptionVo.TrialStartDate);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_TrialEndDate", DbType.DateTime, adviserSubscriptionVo.TrialEndDate);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_SubscriptionStartDate", DbType.DateTime, adviserSubscriptionVo.StartDate);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_SubscriptionEndDate", DbType.DateTime, adviserSubscriptionVo.EndDate);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_SMSLicences", DbType.Int32, adviserSubscriptionVo.SmsBought);
//db.AddInParameter(createAdviserSubscriptionCmd, "@XST_SubscriptionTypeId", DbType.Int32, rmVo.OfficePhoneDirectStd);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_NoOfStaffWebLogins", DbType.Int32, adviserSubscriptionVo.NoOfStaffLogins);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_NoOfBranches", DbType.Int32, adviserSubscriptionVo.NoOfBranches);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_NoOfCustomerWebLogins", DbType.Int32, adviserSubscriptionVo.NoOfCustomerLogins);
//db.AddInParameter(createAdviserSubscriptionCmd, "@AS_IsDeactivated", DbType.Int32, rmVo.OfficePhoneExtStd);
//db.AddInParameter(createAdviserSubscriptionCmd, "@AS_DeactivationDate", DbType.Int32, rmVo.OfficePhoneExtNumber);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_Comments", DbType.String, adviserSubscriptionVo.Comments);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_CreatedBy", DbType.Int32, userId);
db.AddInParameter(createAdviserSubscriptionCmd, "@AS_ModifiedBy", DbType.Int32, userId);
db.AddOutParameter(createAdviserSubscriptionCmd, "@AS_AdviserSubscriptionId", DbType.Int32, 5000);
if (db.ExecuteNonQuery(createAdviserSubscriptionCmd) != 0)
{
subscriptionId = int.Parse(db.GetParameterValue(createAdviserSubscriptionCmd, "AS_AdviserSubscriptionId").ToString());
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdviserSubscriptionDao.cs:CreateAdviserSubscription()");
object[] objects = new object[2];
objects[0] = adviserSubscriptionVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(subscriptionId);
}
/// <summary>
/// Function to enter Adviser Subscription Plan details into the AdviserPlanDetails table
/// </summary>
/// <param name="adviserSubscriptionVo"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool CreateAdviserSubscriptionPlans(AdviserSubscriptionVo adviserSubscriptionVo, int userId)
{
Database db;
DbCommand createAdviserSubscriptionPlansCmd;
bool bResult = false;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
createAdviserSubscriptionPlansCmd = db.GetStoredProcCommand("SP_CreateAdviserSubscriptionPlans");
db.AddInParameter(createAdviserSubscriptionPlansCmd, "@AS_AdviserSubscriptionId", DbType.Int32, adviserSubscriptionVo.SubscriptionId);
db.AddInParameter(createAdviserSubscriptionPlansCmd, "@WP_PlanId", DbType.Int32, adviserSubscriptionVo.PlanId);
db.AddInParameter(createAdviserSubscriptionPlansCmd, "@APD_PlanStartDate", DbType.DateTime, adviserSubscriptionVo.StartDate);
db.AddInParameter(createAdviserSubscriptionPlansCmd, "@APD_PlanEndDate", DbType.DateTime, adviserSubscriptionVo.EndDate);
db.AddInParameter(createAdviserSubscriptionPlansCmd, "@APD_IsActive", DbType.Int16, adviserSubscriptionVo.IsActive);
db.AddInParameter(createAdviserSubscriptionPlansCmd, "@APD_CreatedBy", DbType.Int32, userId);
db.AddInParameter(createAdviserSubscriptionPlansCmd, "@APD_ModifiedBy", DbType.Int32, userId);
if (db.ExecuteNonQuery(createAdviserSubscriptionPlansCmd) != 0)
{
bResult = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdviserSubscriptionDao.cs:CreateAdviserSubscriptionPlans()");
object[] objects = new object[2];
objects[0] = adviserSubscriptionVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdviserSubscriptionVo _advisersubscriptionvo = new AdviserSubscriptionVo();
AdviserSubscriptionBo _advisersubscriptionbo = new AdviserSubscriptionBo();
//UserVo uservo = (UserVo)Session["iffUserVo"];
//_advisersubscriptionvo.AdviserId
int _planid = 0;
DateTime _endDate;
DateTime _startDate;
DateTime _trialStartDate;
DateTime _trialEndDate;
int _noofbranches;
int _noofstafflogins;
int _noofcustomerlogins;
int _smsBought;
int _smsRemaining;
int _smsSentTillDate;
int _subscriptionId;
float _vaultBalanceSize;
float _vaultPaidSize;
float _vaultDefaultSize;
// txtBalanceSize.Attributes.Add("readonly", "readonly");
// txtBalanceSize.Text = Server.HtmlEncode(Request.Form[txtBalanceSize.UniqueID]);
// txtBalanceSize.Attributes.Add("disabled", "false");
try
{
if (Page.IsValid)
{
if (advisorVo != null)
{
_advisersubscriptionvo.AdviserId = advisorVo.advisorId;
//if (int.TryParse(ddlPlan.SelectedItem.Value, out _planid))
//{
// _advisersubscriptionvo.PlanId = _planid;
//}
//-----------old code
//if (ddlFlavourCategory.SelectedValue != "Select")
//{
// _advisersubscriptionvo.FlavourCategory = ddlFlavourCategory.SelectedValue;
//}
if (ddlPlan.SelectedIndex != 0)
{
_advisersubscriptionvo.PlanId = int.Parse(ddlPlan.SelectedValue);
}
if (!string.IsNullOrEmpty(txtComment.Text))
{
_advisersubscriptionvo.Comments = txtComment.Text;
}
if (DateTime.TryParse(dpEndDate.SelectedDate.ToString(), out _endDate))
{
_advisersubscriptionvo.EndDate = _endDate;
}
if (DateTime.TryParse(dpStartDate.SelectedDate.ToString(), out _startDate))
{
_advisersubscriptionvo.StartDate = _startDate;
}
if (DateTime.TryParse(dpTrialStartDate.SelectedDate.ToString(), out _trialStartDate))
{
_advisersubscriptionvo.TrialStartDate = _trialStartDate;
}
if (DateTime.TryParse(dpTrialEndDate.SelectedDate.ToString(), out _trialEndDate))
{
_advisersubscriptionvo.TrialEndDate = _trialEndDate;
}
if (int.TryParse(txtNoOfBranches.Text, out _noofbranches))
{
_advisersubscriptionvo.NoOfBranches = _noofbranches;
}
if (int.TryParse(txtNoOfStaffLogins.Text, out _noofstafflogins))
{
_advisersubscriptionvo.NoOfStaffLogins = _noofstafflogins;
}
if (int.TryParse(txtNoOfCustomerLogins.Text, out _noofcustomerlogins))
{
_advisersubscriptionvo.NoOfCustomerLogins = _noofcustomerlogins;
}
if (float.TryParse(txtPaidSize.Text, out _vaultPaidSize))
{
_advisersubscriptionvo.StorageSize = _vaultPaidSize;
}
//if (float.TryParse(txtBalanceSize.Text, out _vaultBalanceSize))
//{
// _advisersubscriptionvo.StorageBalance = _vaultBalanceSize;
//}
if (float.TryParse(txtDefaultStorage.Text, out _vaultDefaultSize))
{
_advisersubscriptionvo.StorageDefaultSize = _vaultDefaultSize;
}
if (hdnStorageUsed.Value == null || hdnStorageUsed.Value == "")
{
hdnStorageUsed.Value = "0";
}
_vaultBalanceSize = _vaultPaidSize + _vaultDefaultSize - float.Parse(hdnStorageUsed.Value);
if (_vaultBalanceSize >= 0)
{
_advisersubscriptionvo.StorageBalance = _vaultBalanceSize;
if (int.TryParse(txtSMSBought.Text, out _smsBought))
{
_advisersubscriptionvo.SmsBought = _smsBought;
}
for (int i = 0; i < chkModules.Items.Count; i++)
{
ListItem _limodules = (ListItem)chkModules.Items[i];
if (_limodules.Selected == true)
{
_advisersubscriptionvo.CustomPlanSelection += _limodules.Value + ",";
}
}
if (IFAuserVo != null)
{
_subscriptionId = _advisersubscriptionbo.CreateAdviserSubscription(_advisersubscriptionvo, IFAuserVo.UserId);
string flavourIds = GetFlavourIds();
_advisersubscriptionbo.SetFlavoursToAdviser(flavourIds, advisorVo.advisorId);
SettingsSavedMessage.Visible = true;
//SetAdviserFlavourSubscription();
if (IFAuserVo.IsTempPassword == 1)
{
if (chkMailSend.Checked == true)
{
string hassedPassword = string.Empty;
string saltValue = string.Empty;
string password = r.Next(20000, 100000).ToString();
encryption.GetHashAndSaltString(password, out hassedPassword, out saltValue);
IFAuserVo.Password = hassedPassword;
IFAuserVo.PasswordSaltValue = saltValue;
IFAuserVo.OriginalPassword = password;
_advisersubscriptionbo.UpdateUserPasswordInDatabase(hassedPassword, saltValue, IFAuserVo.UserId);
SendMail(IFAuserVo);
}
}
if (Cache["AdminLeftTreeNode" + advisorVo.advisorId.ToString()] != null)
{
Cache.Remove("AdminLeftTreeNode" + advisorVo.advisorId.ToString());
}
}
//SetAdviserFlavourSubscription();
}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "Message", "alert('You don't have enough amount');", true);
// return;
//}
}
}
// txtBalanceSize.Attributes.Add("disabled", "true");
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "Message", @"alert('Something Went Wrong \n Record Status: Unsuccessful');", true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdviserSubscriptionVo _advisersubscriptionvo = new AdviserSubscriptionVo();
AdviserSubscriptionBo _advisersubscriptionbo = new AdviserSubscriptionBo();
UserVo uservo = (UserVo)Session["UserVo"];
AdvisorVo advisorVo = (AdvisorVo)Session["advisorVo"];
//_advisersubscriptionvo.AdviserId
int _planid = 0;
DateTime _endDate;
DateTime _startDate;
DateTime _trialStartDate;
DateTime _trialEndDate;
int _noofbranches;
int _noofstafflogins;
int _noofcustomerlogins;
int _smsBought;
int _smsRemaining;
int _smsSentTillDate;
int _subscriptionId;
try
{
if (Page.IsValid)
{
if (advisorVo != null)
{
_advisersubscriptionvo.AdviserId = advisorVo.advisorId;
if (int.TryParse(ddlPlan.SelectedItem.Value, out _planid))
{
_advisersubscriptionvo.PlanId = _planid;
}
if (!string.IsNullOrEmpty(txtComment.Text))
{
_advisersubscriptionvo.Comments = txtComment.Text;
}
if (DateTime.TryParse(dpEndDate.SelectedDate.ToString(), out _endDate))
{
_advisersubscriptionvo.EndDate = _endDate;
}
if (DateTime.TryParse(dpStartDate.SelectedDate.ToString(), out _startDate))
{
_advisersubscriptionvo.StartDate = _startDate;
}
if (DateTime.TryParse(dpTrialStartDate.SelectedDate.ToString(), out _trialStartDate))
{
_advisersubscriptionvo.TrialStartDate = _trialStartDate;
}
if (DateTime.TryParse(dpTrialEndDate.SelectedDate.ToString(), out _trialEndDate))
{
_advisersubscriptionvo.TrialEndDate = _trialEndDate;
}
if (int.TryParse(txtNoOfBranches.Text, out _noofbranches))
{
_advisersubscriptionvo.NoOfBranches = _noofbranches;
}
if (int.TryParse(txtNoOfStaffLogins.Text, out _noofstafflogins))
{
_advisersubscriptionvo.NoOfStaffLogins = _noofstafflogins;
}
if (int.TryParse(txtNoOfCustomerLogins.Text, out _noofcustomerlogins))
{
_advisersubscriptionvo.NoOfCustomerLogins = _noofcustomerlogins;
}
if (int.TryParse(txtSMSBought.Text, out _smsBought))
{
_advisersubscriptionvo.SmsBought = _smsBought;
}
for (int i = 0; i < chkModules.Items.Count; i++)
{
ListItem _limodules = (ListItem)chkModules.Items[i];
if (_limodules.Selected == true)
{
_advisersubscriptionvo.CustomPlanSelection += _limodules.Value + ",";
}
}
if (uservo != null)
{
_subscriptionId = _advisersubscriptionbo.CreateAdviserSubscription(_advisersubscriptionvo, uservo.UserId);
SettingsSavedMessage.Visible = true;
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "Message", @"alert('Something Went Wrong \n Record Status: Unsuccessful');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
AdvisorVo advisorVo = (AdvisorVo)Session["advisorVo"];
AdviserSubscriptionBo _advisersubscriptionbo = new AdviserSubscriptionBo();
AdviserSubscriptionVo _advisersubscriptionvo = new AdviserSubscriptionVo();
DataSet _dsGetSubscriptionDetails;
if (!IsPostBack)
{
BindPlanDropdown();
if (advisorVo != null)
{
_dsGetSubscriptionDetails = _advisersubscriptionbo.GetAdviserSubscriptionPlanDetails(advisorVo.advisorId);
Session["SubscriptionDetails"] = _dsGetSubscriptionDetails;
if (_dsGetSubscriptionDetails != null && _dsGetSubscriptionDetails.Tables[0].Rows.Count > 0)
{
txtComment.Text = _dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_Comments"].ToString();
if (!string.IsNullOrEmpty(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_SubscriptionEndDate"].ToString()))
{
dpEndDate.SelectedDate = DateTime.Parse(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_SubscriptionEndDate"].ToString());
}
txtNoOfBranches.Text = _dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_NoOfBranches"].ToString();
txtNoOfCustomerLogins.Text = _dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_NoOfCustomerWebLogins"].ToString();
txtNoOfStaffLogins.Text = _dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_NoOfStaffWebLogins"].ToString();
txtSMSBought.Text = _dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_SMSLicences"].ToString();
if (!string.IsNullOrEmpty(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_SubscriptionStartDate"].ToString()))
{
dpStartDate.SelectedDate = DateTime.Parse(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_SubscriptionStartDate"].ToString());
}
if (!string.IsNullOrEmpty(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_TrialEndDate"].ToString()))
{
dpTrialEndDate.SelectedDate = DateTime.Parse(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_TrialEndDate"].ToString());
}
if (!string.IsNullOrEmpty(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_TrialStartDate"].ToString()))
{
dpTrialStartDate.SelectedDate = DateTime.Parse(_dsGetSubscriptionDetails.Tables[0].Rows[0]["AS_TrialStartDate"].ToString());
}
ddlPlan.SelectedValue = _dsGetSubscriptionDetails.Tables[0].Rows[0]["WP_PlanId"].ToString();
if (_dsGetSubscriptionDetails.Tables[1] != null)
{
for (int i = 0; i < _dsGetSubscriptionDetails.Tables[1].Rows.Count; i++)
{
for (int j = 0; j < chkModules.Items.Count; j++)
{
if (chkModules.Items[j].Value == _dsGetSubscriptionDetails.Tables[1].Rows[i]["WF_FlavourId"].ToString())
{
chkModules.Items[j].Selected = true;
}
}
//chkModules.SelectedItem.Value = _dsGetSubscriptionDetails.Tables[1].Rows[i]["WF_FlavourId"].ToString();
}
}
}
}
}
if (ddlPlan.SelectedValue != "3")
{
chkModules.Enabled = false;
}
else
{
chkModules.Enabled = true;
}
}
