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); }