public DataTable GetCustomerPersonalItemsList(int customerId, string AssCatCode)
{
InsuranceDao insuranceDao = new InsuranceDao();
DataTable dt = new DataTable();
try
{
dt = insuranceDao.GetCustomerPersonalItemsList(customerId, AssCatCode);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetCustomerPersonalItemsList()");
object[] objects = new object[1];
objects[0] = customerId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dt);
}
public int CreateCustomerGIAccount(GeneralInsuranceVo generalInsuranceVo, int userId)
{
InsuranceDao insuranceDao = new InsuranceDao();
int accountId = 0;
try
{
accountId = insuranceDao.CreateCustomerGIAccount(generalInsuranceVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:CreateCustomerGIAccount()");
object[] objects = new object[2];
objects[0] = generalInsuranceVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(accountId);
}
public bool DeleteInsurancePortfolio(int InsuranceId, int AccountId)
{
bool bResult = false;
InsuranceDao insuranceDao = new InsuranceDao();
try
{
bResult = insuranceDao.DeleteInsurancePortfolio(InsuranceId, AccountId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:DeleteInsurancePortfolio()");
object[] objects = new object[2];
objects[0] = InsuranceId;
objects[1] = AccountId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
public DataTable ChkLifeInsurancePortfolioExist(int customerId)
{
InsuranceDao insuranceDao = new InsuranceDao();
DataTable dt = new DataTable();
try
{
dt = insuranceDao.ChkLifeInsurancePortfolioExist(customerId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:ChkLifeInsurancePortfolioExist()");
object[] objects = new object[1];
objects[0] = customerId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dt);
}
public int CreateCustomerLIPortfolio(int customerId, int userId)
{
int customerLIPortfolioId = 0;
InsuranceDao insuaranceDao = new InsuranceDao();
try
{
customerLIPortfolioId = insuaranceDao.CreateCustomerLIPortfolio(customerId, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:CreateCustomerLIPortfolio()");
object[] objects = new object[2];
objects[0] = customerId;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(customerLIPortfolioId);
}
public List <InsuranceVo> GetInsurancePortfolio(int portfolioId, int currentPage, string sortExpression, out int count)
{
InsuranceDao insuranceDao = new InsuranceDao();
List <InsuranceVo> insuranceList = new List <InsuranceVo>();
try
{
insuranceList = insuranceDao.GetInsurancePortfolio(portfolioId, currentPage, sortExpression, out count);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetInsurancePortfolio()");
object[] objects = new object[1];
objects[0] = portfolioId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(insuranceList);
}
public DataSet GetUlipPlanCode(int CustInsInvId)
{
DataSet dsGetUlipPlanCodeFromInsuranceId;
InsuranceDao insuranceDao = new InsuranceDao();
try
{
dsGetUlipPlanCodeFromInsuranceId = insuranceDao.GetUlipPlanCode(CustInsInvId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetUlipPlanCode()");
object[] objects = new object[1];
objects[0] = CustInsInvId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsGetUlipPlanCodeFromInsuranceId);
}
public InsuranceULIPVo GetInsuranceULIPDetails(int insuranceUlipId)
{
InsuranceDao insuranceDao = new InsuranceDao();
InsuranceULIPVo insuranceUlipVo = new InsuranceULIPVo();
try
{
insuranceUlipVo = insuranceDao.GetInsuranceULIPDetails(insuranceUlipId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetInsuranceULIPDetails()");
object[] objects = new object[1];
objects[0] = insuranceUlipId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(insuranceUlipVo);
}
public List <MoneyBackEpisodeVo> GetMoneyBackEpisodeList(int insuranceId)
{
List <MoneyBackEpisodeVo> moneyBackEpisodeList = new List <MoneyBackEpisodeVo>();
InsuranceDao insuranceDao = new InsuranceDao();
try
{
moneyBackEpisodeList = insuranceDao.GetMoneyBackEpisodeList(insuranceId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetMoneyBackEpisodeList()");
object[] objects = new object[1];
objects[0] = insuranceId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(moneyBackEpisodeList);
}
public DataSet GetCustomerInsuranceAccounts(int customerId, string assetGroup)
{
DataSet dsInsuranceAccounts;
InsuranceDao insuranceDao = new InsuranceDao();
try
{
dsInsuranceAccounts = insuranceDao.GetCustomerInsuranceAccounts(customerId, assetGroup);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetCustomerInsuranceAccounts()");
object[] objects = new object[2];
objects[0] = customerId;
objects[1] = assetGroup;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsInsuranceAccounts);
}
public bool CreateInsuranceULIPPlan(InsuranceULIPVo insuranceUlipVo)
{
InsuranceDao insuranceDao = new InsuranceDao();
bool bResult = false;
try
{
bResult = insuranceDao.CreateInsuranceULIPPlan(insuranceUlipVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:CreateInsuranceULIPPlan()");
object[] objects = new object[1];
objects[0] = insuranceUlipVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
public int ChkAccountAvail(int customerId)
{
int count = 0;
InsuranceDao insuranceDao = new InsuranceDao();
try
{
count = insuranceDao.ChkAccountAvail(customerId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:ChkAccountAvail()");
object[] objects = new object[1];
objects[0] = customerId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(count);
}
/// <summary>
/// Function to retrieve all the Life Insurance and General Insurance of a Customer for Customer Dashboard
/// </summary>
/// <param name="customerId"></param>
/// <returns></returns>
public DataSet GetCustomerDashboardInsuranceDetails(int customerId)
{
InsuranceDao insuranceDao = new InsuranceDao();
DataSet ds = new DataSet();
try
{
ds = insuranceDao.GetCustomerDashboardInsuranceDetails(customerId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetCustomerDashboardInsuranceDetails()");
object[] objects = new object[1];
objects[0] = customerId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(ds);
}
public bool DeleteGIAssetAssociation(int insuranceId)
{
InsuranceDao insuranceDao = new InsuranceDao();
DataTable dt = new DataTable();
bool bresult = false;
try
{
bresult = insuranceDao.DeleteGIAssetAssociation(insuranceId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:DeleteGIAssetAssociation()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bresult);
}
public DataTable GetGIPolicyType()
{
InsuranceDao insuranceDao = new InsuranceDao();
DataTable dt = new DataTable();
try
{
dt = insuranceDao.GetGIPolicyType();
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:GetGIPolicyType()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dt);
}
public bool DeleteMoneyBackEpisode(MoneyBackEpisodeVo moneyBackEpisodeVo)
{
bool blResult = false;
InsuranceDao insuranceDao = new InsuranceDao();
try
{
blResult = insuranceDao.DeleteMoneyBackEpisode(moneyBackEpisodeVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:DeleteMoneyBackEpisode()");
object[] objects = new object[1];
objects[0] = moneyBackEpisodeVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(blResult);
}
public bool CreateGIAssetAssociation(GeneralInsuranceVo generalInsuranceVo, int userId)
{
bool bResult = false;
InsuranceDao insuaranceDao = new InsuranceDao();
try
{
bResult = insuaranceDao.CreateGIAssetAssociation(generalInsuranceVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:CreateGIAssetAssociation()");
object[] objects = new object[2];
objects[0] = generalInsuranceVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
public int CreateGINetPosition(GeneralInsuranceVo generalInsuranceVo, int userId)
{
InsuranceDao insuranceDao = new InsuranceDao();
//bool bResult = false;
int insuranceId = 0;
try
{
// bResult = insuranceDao.CreateInsurancePortfolio(insuranceVo, userId);
insuranceId = insuranceDao.CreateGINetPosition(generalInsuranceVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "InsuranceBo.cs:CreateGINetPosition()");
object[] objects = new object[2];
objects[0] = generalInsuranceVo;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
//return bResult;
return(insuranceId);
}
public static bool UserPayOrder(OrderInfo order)
{
OrderDao dao = new OrderDao();
order.OrderStatus = OrderStatus.BuyerAlreadyPaid;
order.PayDate = new DateTime?(DateTime.Now);
bool flag = dao.UpdateOrder(order, null);
string str = "";
Globals.Debuglog("调用付款:" + order.OrderId + ",成功否：" + flag.ToString() + ",order.UserId:" + order.UserId.ToString(), "_DebuglogPaymentTest.txt");
if (flag)
{
if (order.UserId == 0)
{
//更新保险订单状态
if (order.CouponCode != "")
{
InsuranceDao daoid = new InsuranceDao();
InsuranceOrderInfo insurance = daoid.GetModel(Convert.ToInt32(order.CouponCode));
insurance.InsuranceOrderStatu = 3;
daoid.Update(insurance);
}
try
{
Messenger.SendWeiXinMsg_OrderPay(order);
}
catch
{
}
}
else
{
dao.UpdatePayOrderStock(order);
SettingsManager.GetMasterSettings(true);
MemberInfo member = GetMember(order.UserId, true);
if (VshopBrowser.IsPassAutoToDistributor(member, true))
{
DistributorsBrower.MemberAutoToDistributor(member);
}
new MemberDao().SetOrderDate(order.UserId, 1);
foreach (LineItemInfo info2 in order.LineItems.Values)
{
ProductDao dao2 = new ProductDao();
str = str + "'" + info2.SkuId + "',";
ProductInfo productDetails = dao2.GetProductDetails(info2.ProductId);
productDetails.SaleCounts += info2.Quantity;
productDetails.ShowSaleCounts += info2.Quantity;
dao2.UpdateProduct(productDetails, null);
}
if (!string.IsNullOrEmpty(str))
{
dao.UpdateItemsStatus(order.OrderId, 2, str.Substring(0, str.Length - 1));
}
if (!string.IsNullOrEmpty(order.ActivitiesId))
{
new ActivitiesDao().UpdateActivitiesTakeEffect(order.ActivitiesId);
}
if (member == null)
{
return(flag);
}
Globals.Debuglog("发微信消息:" + order.OrderId + ",成功：" + flag.ToString() + ",order.UserId:" + order.UserId.ToString(), "_DebuglogPaymentTest.txt");
try
{
Messenger.SendWeiXinMsg_OrderPay(order);
}
catch
{
}
}
}
return(flag);
}
