/// <summary>
///
/// </summary>
/// <param name="rmVo"></param>
/// <param name="advisorId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public int CreateAdvisorStaff(RMVo rmVo, int advisorId, int userId)
{
bool result = false;
int rmId;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
rmId = advisorStaffDao.CreateAdvisorStaff(rmVo, advisorId, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:CreateAdvisorStaff()");
object[] objects = new object[3];
objects[0] = rmVo;
objects[1] = advisorId;
objects[2] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(rmId);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool DeleteRM(int rmId, int userId)
{
bool bResult = false;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
bResult = advisorStaffDao.DeleteRM(rmId, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:DeleteRM()");
object[] objects = new object[2];
objects[0] = rmId;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
}
return(bResult);
}
/// <summary>
///
/// </summary>
/// <param name="userVo"></param>
/// <param name="rmVo"></param>
/// <param name="userId"></param>
/// <returns></returns>
public List <int> CreateCompleteRM(UserVo userVo, RMVo rmVo, int userId)
{
List <int> rmIds = new List <int>();
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
rmIds = advisorStaffDao.CreateCompleteRM(userVo, rmVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:CreateCompleteRM()");
object[] objects = new object[3];
objects[0] = rmVo;
objects[1] = userVo;
objects[2] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(rmIds);
}
/* End */
/* Branc Dropdown For BM */
public DataTable GetRMListForBranchDP(int branchId, int branchHeadId, int all)
{
DataTable dtBranchRMList;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
dtBranchRMList = advisorStaffDao.GetRMListForBranchDP(branchId, branchHeadId, all);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetBranchRMList()");
object[] objects = new object[2];
objects[0] = branchId;
objects[1] = branchHeadId;
objects[2] = all;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dtBranchRMList);
}
/// <summary>
/// Checks the RM BM Role Have4 any dependency...
/// </summary>
/// <param name="RMID"></param>
/// <returns></returns>
public Hashtable CheckRMDependency(int RMID)
{
Hashtable ht = new Hashtable();
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
ht = advisorStaffDao.CheckRMDependency(RMID);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:CheckRMDependency()");
object[] objects = new object[1];
objects[0] = RMID;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(ht);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <returns></returns>
public int GetRMBranchId(int rmId)
{
int branchId = 0;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
branchId = advisorStaffDao.GetRMBranchId(rmId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetRMBranchId()");
object[] objects = new object[1];
objects[0] = rmId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(branchId);
}
/// <summary>
///
/// </summary>
/// <param name="rmName"></param>
/// <param name="adviserId"></param>
/// <param name="currentpage"></param>
/// <param name="sortorder"></param>
/// <param name="count"></param>
/// <returns></returns>
public DataSet FindRM(string rmName, int adviserId, int currentpage, string sortorder, out int count)
{
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
DataSet ds = new DataSet();
try
{
ds = advisorStaffDao.FindRM(rmName, adviserId, currentpage, sortorder, out count);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:FindRM()");
object[] objects = new object[2];
objects[0] = rmName;
objects[1] = adviserId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(ds);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <returns></returns>
public RMVo GetAdvisorStaffDetails(int rmId)
{
RMVo rmVo = new RMVo();
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
rmVo = advisorStaffDao.GetAdvisorStaffDetails(rmId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetAdvisorStaffDetails()");
object[] objects = new object[1];
objects[0] = rmId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(rmVo);
}
/// <summary>
///
/// </summary>
/// <param name="adviserId"></param>
/// <param name="flag"></param>
/// <returns></returns>
public DataTable GetExternalRMList(int adviserId, int flag)
{
DataTable dt;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
dt = advisorStaffDao.GetExternalRMList(adviserId, flag);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetAdvisorAssociatesDropDown()");
object[] objects = new object[1];
objects[0] = adviserId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <param name="currentPage"></param>
/// <param name="sortOrder"></param>
/// <param name="Count"></param>
/// <returns></returns>
public DataSet GetBMStaff(int rmId, int currentPage, string sortOrder, out int Count)
{
DataSet dsRMList;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
dsRMList = advisorStaffDao.GetBMStaff(rmId, currentPage, sortOrder, out Count);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetBMStaff()");
object[] objects = new object[4];
objects[0] = rmId;
objects[1] = currentPage;
objects[2] = sortOrder;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsRMList);
}
/// <summary>
/// TO GET ALL THE STAFFS WHO IS HAVING ONLY ADMIN AND RM ROLES UNDER THE PERTICULAR ADVISER
/// </summary>
/// Created by Vinayak Patil
/// <param name="adviserId"></param>
/// <returns></returns>
public DataSet GetAllAdviserRMsHavingOnlyAdminRMRole(int adviserId, int rmId)
{
DataSet dsAdviserRMList;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
dsAdviserRMList = advisorStaffDao.GetAllAdviserRMsHavingOnlyAdminRMRole(adviserId, rmId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetAdviserRM()");
object[] objects = new object[1];
objects[0] = adviserId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsAdviserRMList);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <returns></returns>
public DataSet GetRMCustomerList(int rmId)
{
DataSet dsCustomerList = new DataSet();
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
dsCustomerList = advisorStaffDao.GetRMCustomerListDataSet(rmId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetRMCustomerList()");
object[] objects = new object[1];
objects[0] = rmId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsCustomerList);
}
/// <summary>
///
/// </summary>
/// <param name="rmVo"></param>
/// <returns></returns>
public bool UpdateStaff(RMVo rmVo)
{
bool bResult = false;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
bResult = advisorStaffDao.UpdateStaff(rmVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:updateStaff()");
object[] objects = new object[3];
objects[0] = rmVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
/// <summary>
///
/// </summary>
/// <param name="customerName"></param>
/// <param name="rmId"></param>
/// <returns></returns>
public List <CustomerVo> GetCustomerList(string customerName, int rmId)
{
List <CustomerVo> customerList = null;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
customerList = advisorStaffDao.GetCustomerList(customerName, rmId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetCustomerList()");
object[] objects = new object[1];
objects[0] = rmId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(customerList);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <param name="Flag"></param>
/// <returns></returns>
public int GetCustomerList(int rmId, string Flag)
{
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
int rowCount = 0;
try
{
rowCount = advisorStaffDao.GetCustomerList(rmId, Flag);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetCustomerList()");
object[] objects = new object[1];
objects[0] = rmId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(rowCount);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <param name="currentPage"></param>
/// <param name="count"></param>
/// <param name="sortExpression"></param>
/// <param name="nameFilter"></param>
/// <param name="areaFilter"></param>
/// <param name="pincodeFilter"></param>
/// <param name="parentFilter"></param>
/// <param name="cityFilter"></param>
/// <param name="RMFilter"></param>
/// <param name="genDictParent"></param>
/// <param name="genDictCity"></param>
/// <param name="genDictRM"></param>
/// <returns></returns>
public List <CustomerVo> GetBMCustomerList(int rmId, int currentPage, out int count, string sortExpression, string nameFilter, string areaFilter, string pincodeFilter, string parentFilter, string cityFilter, string RMFilter, out Dictionary <string, string> genDictParent, out Dictionary <string, string> genDictCity, out Dictionary <string, string> genDictRM)
{
List <CustomerVo> customerList = null;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
genDictParent = new Dictionary <string, string>();
genDictCity = new Dictionary <string, string>();
genDictRM = new Dictionary <string, string>();
try
{
customerList = advisorStaffDao.GetBMCustomerList(rmId, currentPage, out count, sortExpression, nameFilter, areaFilter, pincodeFilter, parentFilter, cityFilter, RMFilter, out genDictParent, out genDictCity, out genDictRM);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetBMCustomerList()");
object[] objects = new object[1];
objects[0] = rmId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(customerList);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <param name="branchId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool CreateRMBranch(int rmId, int branchId, int userId)
{
bool result = false;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
advisorStaffDao.CreateRMBranch(rmId, branchId, userId);
result = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:createRMBranch()");
object[] objects = new object[3];
objects[0] = rmId;
objects[1] = branchId;
objects[2] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="advisorId"></param>
/// <param name="currentPage"></param>
/// <param name="sortOrder"></param>
/// <param name="Count"></param>
/// <param name="nameSrch"></param>
/// <returns></returns>
public List <RMVo> GetRMList(int advisorId, int currentPage, string sortOrder, out int Count, string nameSrch)
{
List <RMVo> rmList = null;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
rmList = advisorStaffDao.GetRMList(advisorId, currentPage, sortOrder, out Count, nameSrch);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetRMList()");
object[] objects = new object[1];
objects[0] = advisorId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(rmList);
}
/// <summary>
///
/// </summary>
/// <param name="rmId"></param>
/// <returns></returns>
public int CheckRMMainBranch(int rmId)
{
int cnt;
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
try
{
cnt = advisorStaffDao.CheckRMMainBranch(rmId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffBo.cs:GetAdvisorAssociatesDropDown()");
object[] objects = new object[1];
objects[0] = rmId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(cnt);
}
/// <summary>
///
/// </summary>
/// <param name="branchId"></param>
/// <param name="CurrentPage"></param>
/// <param name="Count"></param>
/// <returns></returns>
public List <RMVo> GetBMRMList(int branchId, int CurrentPage, out int Count)
{
List <RMVo> rmList = new List <RMVo>();
AdvisorStaffDao advisorStaffDao = new AdvisorStaffDao();
Count = 0;
try
{
rmList = advisorStaffDao.GetBMRMList(branchId, CurrentPage, out Count);
}
catch (Exception e)
{
string msg = e.Message.ToString();
}
return(rmList);
}
