public int CountAdvisorLOB()
{
// advisorVo = (AdvisorVo)Session["advisorVo"];
AdvisorLOBBo advisorLOBBo = new AdvisorLOBBo();
DataSet dsAdvisorLOBList = null;
int count;
try
{
dsAdvisorLOBList = advisorLOBBo.GetAdvisorLOBs(advisorVo.advisorId, null, null);
count = dsAdvisorLOBList.Tables[0].Rows.Count;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorDashBoard.ascx:CountAdvisorLOB()");
object[] objects = new object[2];
objects[0] = advisorLOBBo;
objects[1] = dsAdvisorLOBList;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(count);
}
protected void Page_Load(object sender, EventArgs e)
{
//btnSubmit.Attributes.Add("onclick", "Validation('" + ddlStatus.ClientID + "');");
SessionBo.CheckSession();
if (!IsPostBack)
{
BindCategory();
BindStatus();
}
if (Session["IFFAdd"] != null)
{
if (Session["IFFAdd"].ToString() == "Edit")
{
try
{
hidStatus.Value = "1";
btnAddLOB.Visible = true;
btnSendLoginId.Visible = true;
lblIFFAdd.Text = "Edit IFF";
btnSubmit.Text = "Update";
Deactivation.Visible = false;
lblDeactivation.Visible = false;
advisorVo = (AdvisorVo)Session["advisorVo"];
userVo = (UserVo)Session["iffUserVo"];
//advisorVo = advisorBo.GetAdvisor(advisorVo.advisorId);
txtDeactivationDate.Text = advisorVo.DeactivationDate.ToShortDateString();
txtAddressLine1.Text = advisorVo.AddressLine1;
txtAddressLine2.Text = advisorVo.AddressLine2;
txtAddressLine3.Text = advisorVo.AddressLine3;
txtCity.Text = advisorVo.City;
txtContactPerson.Text = advisorVo.ContactPersonFirstName;
txtCountry.Text = advisorVo.Country;
txtEmailId.Text = advisorVo.Email;
txtLoginId.Text = advisorVo.LoginId;
txtMobileNo.Text = advisorVo.MobileNumber.ToString();
txtNameofIFF.Text = advisorVo.OrganizationName;
txtPinCode.Text = advisorVo.PinCode.ToString();
txtTelephoneNumber.Text = advisorVo.Phone1Number.ToString();
btnSendLoginId.Text = "Reset/Send Login Id";
if (advisorVo.IsActive == 1)
{
ddlStatus.SelectedIndex = 0;
Activation.Visible = true;
lblActivation.Visible = true;
//lblActivation.Style.Add("display", "block");
}
else
{
ddlStatus.SelectedIndex = 1;
Activation.Visible = false;
lblActivation.Visible = false;
Deactivation.Visible = true;
lblDeactivation.Visible = true;
}
if (advisorVo.Category != null)
{
for (int i = 0; i < ddlCategory.Items.Count; i++)
{
if (ddlCategory.Items[i].Text == advisorVo.Category)
{
ddlCategory.Items[i].Selected = true;
}
else
{
ddlCategory.Items[i].Selected = false;
}
}
}
else
{
ddlCategory.SelectedIndex = 0;
}
DataSet dsadvisorLOB = advisorLOBBo.GetAdvisorLOBs(advisorVo.advisorId, null, null);
showLOBList(advisorVo.advisorId);
if (dsadvisorLOB != null)
{
for (int i = 0; i < dsadvisorLOB.Tables[0].Rows.Count; i++)
{
if (dsadvisorLOB.Tables[0].Rows[i]["AL_IsDependent"].ToString() == "1")
{
GridValidationForIsDependent(i);
}
}
}
txtActivationDate.Text = advisorVo.ActivationDate.ToShortDateString();
txtActivationHidden.Text = advisorVo.ActivationDate.ToShortDateString();
dateCompareValidator.EnableClientScript = false;
dateCompareValidator.ControlToCompare = "txtActivationHidden";
dateCompareValidator.ControlToValidate = "txtDeactivationDate";
dateCompareValidator.Type = ValidationDataType.Date;
dateCompareValidator.Operator = ValidationCompareOperator.GreaterThan;
dateCompareValidator.ErrorMessage = "Deactivation Date should not be less than Activation Date";
if (advisorVo.IsActive == 1)
{
if (txtDeactivationDate.Text == "01/01/1900")
{
calExeDeactivationDate.SelectedDate = DateTime.Now;
}
}
else
{
if (txtActivationDate.Text == "01/01/1900")
{
calExeActivationDate.SelectedDate = DateTime.Now;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
else if (Session["IFFAdd"].ToString() == "Add")
{
hidStatus.Value = "0";
Deactivation.Visible = false;
lblDeactivation.Visible = false;
txtDeactivationDate.Text = "";
txtAddressLine1.Text = "";
txtAddressLine2.Text = "";
txtAddressLine3.Text = "";
txtCity.Text = "";
txtContactPerson.Text = "";
txtCountry.Text = "";
txtEmailId.Text = "";
txtLoginId.Text = "";
txtMobileNo.Text = "";
txtNameofIFF.Text = "";
txtPinCode.Text = "";
Deactivation.Visible = false;
lblDeactivation.Visible = false;
txtTelephoneNumber.Text = "";
//advisorVo = (AdvisorVo)Session["LOBAdvisorVo"];
if (Session["IDs"] != null)
{
btnAddLOB.Visible = true;
btnSendLoginId.Visible = true;
btnSubmit.Text = "Update";
IsAddUpdate = true;
ddlStatus.Items[1].Enabled = true;
advisorVo = (AdvisorVo)Session["advisorVo"];
DataRepopulating();
}
else
{
btnAddLOB.Visible = false;
btnSendLoginId.Visible = false;
ddlStatus.Items[1].Enabled = false;
if (!IsPostBack)
{
calExeActivationDate.SelectedDate = DateTime.Now;
calExeDeactivationDate.SelectedDate = DateTime.Now;
}
}
if (advisorVo != null)
{
showLOBList(advisorVo.advisorId);
}
else
{
gvLOBList.DataSource = null;
}
}
}
}
public void showLOBList()
{
string path = "";
string classificationCode = "";
try
{
advisorVo = (AdvisorVo)Session["advisorVo"];
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
advisorLOBList = advisorLOBBo.GetAdvisorLOBs(advisorVo.advisorId, null, null);
if (advisorLOBList.Tables[0].Rows.Count > 0)
{
gvLOBList.Visible = true;
ErrorMessage.Visible = false;
DataTable dtAdvisorLOB = new DataTable();
dtAdvisorLOB.Columns.Add("SI.No");
dtAdvisorLOB.Columns.Add("LOBId");
dtAdvisorLOB.Columns.Add("Broker Name");
dtAdvisorLOB.Columns.Add("Business Type");
dtAdvisorLOB.Columns.Add("Identifier");
dtAdvisorLOB.Columns.Add("Identifier Type");
DataRow drAdvisorLOB;
for (int i = 0; i < advisorLOBList.Tables[0].Rows.Count; i++)
{
classificationCode = advisorLOBList.Tables[0].Rows[i]["XALC_LOBClassificationCode"].ToString();
drAdvisorLOB = dtAdvisorLOB.NewRow();
drAdvisorLOB[0] = (i + 1).ToString();
drAdvisorLOB[1] = advisorLOBList.Tables[0].Rows[i]["AL_LOBId"].ToString();
drAdvisorLOB[2] = advisorLOBList.Tables[0].Rows[i]["AL_OrgName"].ToString();
drAdvisorLOB[3] = XMLBo.GetLOBType(path, advisorLOBList.Tables[0].Rows[i]["XALC_LOBClassificationCode"].ToString());
if (classificationCode == "LDSA" || classificationCode == "LFIA" || classificationCode == "LIAG" || classificationCode == "LPAG" || classificationCode == "LREA")
{
drAdvisorLOB[4] = advisorLOBList.Tables[0].Rows[i]["AL_AgentNo"].ToString();
drAdvisorLOB[5] = "Agent No./Agency Code";
}
else
{
drAdvisorLOB[4] = advisorLOBList.Tables[0].Rows[i]["AL_Identifier"].ToString();
drAdvisorLOB[5] = advisorLOBList.Tables[0].Rows[i]["XALIT_IdentifierTypeCode"].ToString();
}
dtAdvisorLOB.Rows.Add(drAdvisorLOB);
}
if (dtAdvisorLOB.Rows.Count > 10)
{
gvLOBList.ShowFooter = false;
}
else
{
gvLOBList.ShowFooter = true;
}
gvLOBList.DataSource = dtAdvisorLOB;
gvLOBList.DataBind();
}
else
{
gvLOBList.Visible = false;
ErrorMessage.Visible = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewLOB.ascx:showLOBList()");
object[] objects = new object[4];
objects[0] = advisorVo;
objects[1] = path;
objects[2] = advisorLOBVo;
objects[3] = advisorLOBList;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public void setAdvisorLOB()
{
advisorVo = (AdvisorVo)Session["advisorVo"];
AdvisorLOBBo advisorLOBBo = new AdvisorLOBBo();
DataSet dsAdvisorLOBList = null;
AdvisorLOBVo advisorLOBVo = null;
string path;
try
{
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
dsAdvisorLOBList = advisorLOBBo.GetAdvisorLOBs(advisorVo.advisorId, null, null);
//DataTable dtAdvisorLOB = new DataTable();
//dtAdvisorLOB.Columns.Add("SI.No");
//dtAdvisorLOB.Columns.Add("Organization Name");
//dtAdvisorLOB.Columns.Add("Business Type");
//DataRow drAdvisorLOB;
//for (int i = 0; i < dsAdvisorLOBList.Count; i++)
//{
// drAdvisorLOB = dtAdvisorLOB.NewRow();
// advisorLOBVo = new AdvisorLOBVo();
// advisorLOBVo = dsAdvisorLOBList[i];
// drAdvisorLOB[0] = (i + 1).ToString();
// drAdvisorLOB[1] = advisorLOBVo.OrganizationName.ToString();
// drAdvisorLOB[2] = XMLBo.GetLOBType(path, advisorLOBVo.LOBClassificationCode.ToString());
// dtAdvisorLOB.Rows.Add(drAdvisorLOB);
//}
if (dsAdvisorLOBList.Tables[0].Rows.Count > 0)
{
gvAdvisorLOB.DataSource = dsAdvisorLOBList.Tables[0];
gvAdvisorLOB.DataBind();
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorDashBoard.ascx:setAdvisorLOB()");
object[] objects = new object[4];
objects[0] = advisorLOBBo;
objects[1] = dsAdvisorLOBList;
objects[2] = advisorVo;
objects[3] = advisorLOBVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}