/// <summary>
/// Get vehicle body type for the particular make and model.
/// e.g for make(BMW) and model(318i) fetch the body type's SALOON,HATCHBACK..
/// </summary>
/// <param name="vehicleMake">Vehicle make.</param>
/// <param name="vehicleModel">Vehicle model.</param>
/// <returns>Vehicle body response.</returns>
public VehicleBodyResponse GetVehicleBody(string vehicleMake, string vehicleModel)
{
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@Make", vehicleMake),
new SqlParameter("@Model", vehicleModel)
};
DataSet ds = BKICSQL.eds(StoredProcedures.BKICDropDowns.GetVehicleBody, param);
return(new VehicleBodyResponse
{
IsTransactionDone = true,
VehicleBodydt = ds.Tables[0],
VehicleEngineCCdt = ds.Tables[1]
});
}
catch (Exception ex)
{
return(new VehicleBodyResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Get the vehicle model's based on the make.
/// e.g for make (BMW) fetch all the models that make 318i,320,535I..
/// </summary>
/// <param name="vehicleMake">vehicle make</param>
/// <returns>vehicle model's</returns>
public VehicleModelResponse GetVehicleModel(string vehicleMake)
{
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@Make", vehicleMake)
};
DataTable dt = BKICSQL.edt(StoredProcedures.BKICDropDowns.GetVehicleModel, param);
return(new VehicleModelResponse
{
IsTransactionDone = true,
VehicleModeldt = dt
});
}
catch (Exception ex)
{
return(new VehicleModelResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Get agency product's based on the insurance type.
/// e.g for the agency SECURA and insurance type MOTOR fetch the product's (Product 1 and Prodcut 2)
/// for the agency TISCO and insurance type MOTOR fetch the product's (GLD,NMC,PLT etc.)
/// </summary>
/// <param name="agency">Agency.</param>
/// <param name="agencyCode">Agent code.</param>
/// <param name="mainclass">MainClass(e.g MOTOR product's for SECURA -SECUR for TISCO - TISCO)</param>
/// <param name="type">Insurance type.</param>
/// <returns></returns>
public FetchDropDownsResponse FetchAgencyProducts(string agency, string agencyCode, string mainclass, string type)
{
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Agency", agency),
new SqlParameter("@AgencyCode", agencyCode),
new SqlParameter("@MainClass", mainclass),
new SqlParameter("@PageType", type)
};
DataSet ds = BKICSQL.eds(DropDownSP.FetchAgencyProducts, param);
return(new FetchDropDownsResponse
{
IsTransactionDone = true,
dropdownds = ds
});
}
catch (Exception ex)
{
return(new FetchDropDownsResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Get all the travel endorsement details for the specific policy.
/// To show the top of the page on any travel endorsement page.
/// </summary>
/// <param name="request">Endorsement request.</param>
/// <returns>list of endorsemnt details.</returns>
public TravelEndoResponse GetAllEndorsements(TravelEndoRequest request)
{
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Insurancetype", request.InsuranceType),
new SqlParameter("@Agency", request.Agency),
new SqlParameter("@AgentCode", request.AgentCode),
new SqlParameter("@DocumentNo", request.DocumentNo),
};
DataSet travelEndo = BKICSQL.eds(StoredProcedures.PortalSP.GetEndorsementByDocNo, paras);
List <BO.TravelEndorsement> listEndo = new List <BO.TravelEndorsement>();
if (travelEndo != null && travelEndo.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in travelEndo.Tables[0].Rows)
{
BO.TravelEndorsement result = new BO.TravelEndorsement();
result.TravelEndorsementID = dr.IsNull("TravelEndorsementID") ? 0 : Convert.ToInt64(dr["TravelEndorsementID"]);
result.TravelID = dr.IsNull("TravelID") ? 0 : Convert.ToInt64(dr["TravelID"]);
result.DocumentNo = dr.IsNull("DocumentNo") ? string.Empty : Convert.ToString(dr["DocumentNo"]);
result.EndorsementNo = dr.IsNull("EndorsementNo") ? string.Empty : Convert.ToString(dr["EndorsementNo"]);
result.EndorsementType = dr.IsNull("EndorsementType") ? string.Empty : Convert.ToString(dr["EndorsementType"]);
result.PremiumBeforeDiscount = dr.IsNull("PremiumBeforeDiscount") ? 0 : Convert.ToDecimal(dr["PremiumBeforeDiscount"]);
result.PremiumAfterDiscount = dr.IsNull("PremiumAfterDiscount") ? 0 : Convert.ToDecimal(dr["PremiumAfterDiscount"]);
result.CommisionBeforeDiscount = dr.IsNull("CommissionBeforeDiscount") ? 0 : Convert.ToDecimal(dr["CommissionBeforeDiscount"]);
result.CommissionAfterDiscount = dr.IsNull("CommissionAfterDiscount") ? 0 : Convert.ToDecimal(dr["CommissionAfterDiscount"]);
result.RefundAmount = dr.IsNull("RefundAmount") ? 0 : Convert.ToDecimal(dr["RefundAmount"]);
result.RefundAfterDiscount = dr.IsNull("RefundAfterDiscount") ? 0 : Convert.ToDecimal(dr["RefundAfterDiscount"]);
result.PolicyCommencementDate = dr.IsNull("COMMENCEDATE") ? DateTime.Now : Convert.ToDateTime(dr["COMMENCEDATE"]);
result.ExpiryDate = dr.IsNull("EXPIRYDATE") ? DateTime.Now : Convert.ToDateTime(dr["EXPIRYDATE"]);
result.IsSaved = dr.IsNull("IsSaved") ? false : Convert.ToBoolean(dr["IsSaved"]);
result.IsActivePolicy = dr.IsNull("IsActive") ? false : Convert.ToBoolean(dr["IsActive"]);
listEndo.Add(result);
}
}
return(new TravelEndoResponse
{
TravelEndorsements = listEndo,
IsTransactionDone = true
});
}
catch (Exception ex)
{
return(new TravelEndoResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Calculate endorsement premium by endorsement type.
/// </summary>
/// <param name="travelEndorsement">Endorement quote request.</param>
/// <returns>Returns endorsement premium and commision.</returns>
public TravelEndorsementQuoteResponse GetTravelEndorsementQuote(TravelEndorsementQuote travelEndorsement)
{
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", travelEndorsement.Agency),
new SqlParameter("@AgentCode", travelEndorsement.AgentCode),
new SqlParameter("@DocumentNo", travelEndorsement.DocumentNo ?? ""),
new SqlParameter("@MainClass", travelEndorsement.MainClass),
new SqlParameter("@SubClass", travelEndorsement.SubClass),
new SqlParameter("@EffectiveFromDate", travelEndorsement.EffectiveFromDate),
new SqlParameter("@EffectiveToDate", travelEndorsement.EffectiveToDate),
new SqlParameter("@CancelationDate", travelEndorsement.CancelationDate),
new SqlParameter("@PaidPremium", travelEndorsement.PaidPremium),
new SqlParameter("@NewSumInsured", travelEndorsement.NewSumInsured),
new SqlParameter("@RefundType", travelEndorsement.RefundType),
new SqlParameter("@PolicyPeriodName", travelEndorsement.PolicyPeriodName),
new SqlParameter("@EndorsementType", travelEndorsement.EndorsementType),
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@EndorsementPremium", Precision = 38, Scale = 3
},
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@Commission", Precision = 38, Scale = 3
}
};
object[] dataSet = BKICSQL.GetValues(TravelEndorsementSP.GetQuote, paras, outParams);
var endorsementPremium = string.IsNullOrEmpty(dataSet[0].ToString()) ? 0 : decimal.Parse(dataSet[0].ToString(), CultureInfo.InvariantCulture.NumberFormat);
var commission = string.IsNullOrEmpty(dataSet[1].ToString()) ? 0 : decimal.Parse(dataSet[1].ToString(), CultureInfo.InvariantCulture.NumberFormat);
return(new TravelEndorsementQuoteResponse()
{
IsTransactionDone = true,
EndorsementPremium = endorsementPremium,
Commision = commission
});
}
catch (Exception ex)
{
return(new TravelEndorsementQuoteResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Travel endorsement operation - authorize or delete.
/// </summary>
/// <param name="request">Endorsement operation request.</param>
/// <returns></returns>
public TravelEndorsementOperationResponse EndorsementOperation(TravelEndorsementOperation request)
{
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Type", request.Type),
new SqlParameter("@TravelEndorsementID", request.TravelEndorsementID),
new SqlParameter("@TravelID", request.TravelID),
new SqlParameter("@Agency", request.Agency),
new SqlParameter("@AgentCode", request.AgentCode),
new SqlParameter("@UpdatedBy", request.UpdatedBy),
};
DataTable dt = BKICSQL.edt(TravelEndorsementSP.TravelEndorsementOperation, paras);
if (request.Type == Constants.EndorsementOpeationType.Authorize)
{
try
{
new Task(() =>
{
OracleDBIntegration.DBObjects.TransactionWrapper oracleResult
= _oracleTravelEndorsement.MoveIntegrationToOracle(request.TravelEndorsementID);
}).Start();
}
catch (AggregateException ex)
{
foreach (Exception inner in ex.InnerExceptions)
{
_mail.SendMailLogError(ex.Message, "", "Travelendorsement", "", true);
}
}
}
return(new TravelEndorsementOperationResponse
{
IsTransactionDone = true
});
}
catch (Exception ex)
{
return(new TravelEndorsementOperationResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Get quote for the domestic help policy.
/// </summary>
/// <param name="domesticQuoteRequest">domestic quote request.</param>
/// <returns></returns>
public DomesticHelpQuoteResponse GetDomesticHelpQuote(DomesticHelpQuote domesticQuoteRequest)
{
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@InsurancePeroid", domesticQuoteRequest.InsurancePeroid),
new SqlParameter("@NumberOfDomesticWorkers", domesticQuoteRequest.NumberOfDomesticWorkers)
//In future it may be added.
// new SqlParameter("@Agency",pQuoteInputs.Agency)
// new SqlParameter("@AgentCode",pQuoteInputs.AgentCode)
// new SqlParameter("@MainClass",pQuoteInputs.MainClass)
// new SqlParameter("@SubClass",pQuoteInputs.SubClass)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@PremiumBeforeDiscount", Precision = 38, Scale = 3
},
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@PremiumAfterDiscount", Precision = 38
}
};
object[] dataSet = BKICSQL.GetValues(StoredProcedures.DomesticHelpInsuranceSP.GetQuote, para, outParams);
var premiumBeforeDiscount = decimal.Parse(Convert.ToString(dataSet[0]));
return(new DomesticHelpQuoteResponse()
{
IsTransactionDone = true,
PremiumAfterDiscount = 0,
PremiumBeforeDiscount = premiumBeforeDiscount
});
}
catch (Exception ex)
{
return(new DomesticHelpQuoteResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
public void TrackLogin(LoginAudit audit)
{
try
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@UserName", audit.UserName),
new SqlParameter("@IPAddress", audit.IPAddress),
new SqlParameter("@LoginDate", audit.LoginDate),
new SqlParameter("@LoginStatus", audit.LoginStatus)
};
DataSet result = BKICSQL.eds(UsersSP.LoginAudit, para);
}
catch (Exception exc)
{
throw;
}
}
/// <summary>
/// Sender key.
/// </summary>
/// <param name="key">Key</param>
/// <returns></returns>
public MailMessageResponse GetMessageByKey(string key)
{
try
{
MailMessageResponse response = new MailMessageResponse();
response.IsTransactionDone = true;
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@Message", Size = int.MaxValue
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, Size = 250, ParameterName = "@SendMailTo"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, Size = int.MaxValue, ParameterName = "@Subject"
}
};
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@Key", key)
};
object[] dataSet = BKICSQL.GetValues(StoredProcedures.Mail.GetMessageBykey, para, outParams);
response.Message = dataSet[0].ToString();
response.Email = Convert.ToString(dataSet[1]);
response.Subject = Convert.ToString(dataSet[2]);
return(response);
}
catch (Exception exc)
{
return(new MailMessageResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = exc.Message
});
}
}
private void InsertCategory(BO.HomeInsurancePolicy policy, List <PolicyCategory> policyCategories)
{
if (policyCategories != null && policyCategories.Count > 0)
{
foreach (var dr in policyCategories)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@DocumentID", dr.DocumentID),
new SqlParameter("@InsuredCode", policy.InsuredCode),
new SqlParameter("@LinkID", dr.LinkID),
new SqlParameter("@DocumentNo", dr.DocumentNo),
new SqlParameter("@EndorsementNo", dr.EndorsementNo ?? string.Empty),
new SqlParameter("@EndorsementCount", dr.EndorsementCount),
new SqlParameter("@AgentCode", dr.AgentCode),
new SqlParameter("@LineNo", dr.LineNo),
new SqlParameter("@Category", dr.Category),
new SqlParameter("@Code", dr.Code),
new SqlParameter("@ValueType", dr.ValueType),
new SqlParameter("@Value", dr.Value),
new SqlParameter("@PremiumBeforeDiscount", dr.PremiumBeforeDiscount),
new SqlParameter("@PremiumAfterDiscount", dr.PremiumAfterDiscount),
new SqlParameter("@CommissionBeforeDiscount", dr.CommissionBeforeDiscount),
new SqlParameter("@CommissionAfterDiscount", dr.CommissionAfterDiscount),
new SqlParameter("@TaxOnPremiumBeforeDiscount", dr.TaxOnPremiumBeforeDiscount),
new SqlParameter("@TaxOnPremiumAfterDiscount", dr.TaxOnPremiumAfterDiscount),
new SqlParameter("@TaxOnCommissionBeforeDiscount", dr.TaxOnCommissionBeforeDiscount),
new SqlParameter("@TaxOnCommissionAfterDiscount", dr.TaxOnCommissionAfterDiscount),
new SqlParameter("@IsDeductable", dr.IsDeductable),
new SqlParameter("@RenewalCount", dr.RenewalCount),
new SqlParameter("@DomesticID", DBNull.Value),
new SqlParameter("@TravelID", DBNull.Value),
new SqlParameter("@HomeID", dr.HomeID),
new SqlParameter("@MotorID", DBNull.Value),
new SqlParameter("@MotorEndorsementID", DBNull.Value),
new SqlParameter("@TravelEndorsementID", DBNull.Value),
new SqlParameter("@HomeEndorsementID", DBNull.Value),
};
BKICSQL.edt(MotorInsuranceSP.PolicyCategoryInsert, paras);
}
}
}
/// <summary>
/// Fetch user details by the user name.
/// </summary>
/// <param name="userName">User name.</param>
/// <returns>User details.</returns>
public UserDetailsResult FetchUserInformation(string userName)
{
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@UserName", userName)
};
DataSet ds = BKICSQL.eds(UsersSP.FetchUserDetails, param);
UserDetailsResult userdetails = new UserDetailsResult();
foreach (DataRow dr in ds.Tables[0].Rows)
{
userdetails.UserName = Convert.ToString(dr["USERNAME"]);
userdetails.AgentBranch = Convert.ToString(dr["AGENTBRANCH"]);
userdetails.Agency = Convert.ToString(dr["AGENCY"]);
userdetails.AgentCode = Convert.ToString(dr["AGENTCODE"]);
userdetails.UserID = Convert.ToString(dr["USERID"]);
userdetails.ID = Convert.ToInt32(dr["ID"]);
userdetails.IsShowPayments = Convert.ToBoolean(dr["IsShowPayment"]);
//userdetails.AgentLogo = (byte[])dr["Logo"];
}
string products = string.Empty;
foreach (DataRow dr in ds.Tables[1].Rows)
{
products += Convert.ToString(dr["InsuranceTypeID"]);
products += ";";
}
userdetails.IsTransactionDone = true;
userdetails.Products = products;
return(userdetails);
}
catch (Exception ex)
{
return(new UserDetailsResult
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Get domestic policies by agency.
/// </summary>
/// <param name="req">domestic policy request.</param>
/// <returns>list of domestic policies by agency.</returns>
public AgencyDomesticPolicyResponse GetDomesticAgencyPolicy(AgencyDomesticRequest req)
{
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Agency", req.Agency ?? string.Empty),
new SqlParameter("@AgentCode", req.AgentCode ?? string.Empty),
new SqlParameter("@AgentBranch", req.AgentBranch ?? string.Empty),
new SqlParameter("@IncludeHIR", req.IncludeHIR),
new SqlParameter("@DocumentNo", req.DocumentNo ?? string.Empty)
};
DataTable dt = BKICSQL.edt(StoredProcedures.DomesticHelpInsuranceSP.GetDomesticAgencyPolicy, para);
List <AgencyDomesticPolicy> domesticHelpPolicies = new List <AgencyDomesticPolicy>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var res = new AgencyDomesticPolicy();
res.DomesticId = Convert.ToInt32(dr["DOMESTICID"]);
res.DocumentNo = Convert.ToString(dr["DOCUMENTNO"]);
res.InsuredCode = Convert.ToString(dr["INSUREDCODE"]);
domesticHelpPolicies.Add(res);
}
}
return(new AgencyDomesticPolicyResponse
{
DomesticAgencyPolicies = domesticHelpPolicies,
IsTransactionDone = true
});
}
catch (Exception ex)
{
return(new AgencyDomesticPolicyResponse
{
TransactionErrorMessage = ex.Message,
IsTransactionDone = false
});
}
}
/// <summary>
/// Check the if the policy already have saved endorsement,if it is there don't allow to pass the new endorsement.
/// </summary>
/// <param name="request">Endorsement precheck request.</param>
/// <returns>Returns there an endorsemnt with saved staus or not.</returns>
public MotorEndorsementPreCheckResponse EndorsementPrecheck(MotorEndorsementPreCheckRequest request)
{
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@docNo", request.DocNo),
new SqlParameter("@type", Constants.Insurance.Motor)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Bit,
ParameterName = "@IsAlreadyHaveEndorsement", Precision = 38, Scale = 3
},
};
var alreadyHave = false;
object[] dataSet = BKICSQL.GetValues(AdminSP.EndorsementPreCheck, paras, outParams);
if (dataSet != null && dataSet[0] != null)
{
alreadyHave = string.IsNullOrEmpty(dataSet[0].ToString()) ? false : Convert.ToBoolean(dataSet[0].ToString());
}
return(new MotorEndorsementPreCheckResponse()
{
IsTransactionDone = true,
IsAlreadyHave = alreadyHave,
EndorsementNo = ""
});
}
catch (Exception ex)
{
return(new MotorEndorsementPreCheckResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Email audit.
/// </summary>
/// <param name="emailMessage"></param>
public void InsertEmailMessageAudit(EmailMessageAudit emailMessage)
{
try
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@MessageKey", emailMessage.MessageKey),
new SqlParameter("@Message", emailMessage.Message),
new SqlParameter("@InsuredCode", emailMessage.InsuredCode ?? ""),
new SqlParameter("@PolicyNo", emailMessage.PolicyNo ?? ""),
new SqlParameter("@LinkId", emailMessage.LinkNo ?? ""),
new SqlParameter("@InsuredType", emailMessage.InsuranceType),
new SqlParameter("@Subject", emailMessage.Subject ?? ""),
new SqlParameter("@Agency", emailMessage.Agency ?? "")
};
DataSet result = BKICSQL.eds(StoredProcedures.PortalSP.InsertEmailMessage, para);
}
catch (Exception exc)
{
var message = exc.Message;
}
}
/// <summary>
/// Fetch insurance product codes.
/// e.g for the insurance type domestichelp MAINCLASS is PADN.
/// </summary>
/// <param name="agency">Agency.</param>
/// <param name="agencyCode">Agent Code.</param>
/// <param name="insuranceTypeID">Insurance TypeID(1-domesticHelp, 2-Travel)</param>
/// <returns></returns>
public string FetchInsuranceProductCode(string agency, string agencyCode, int insuranceTypeID)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@Agency", agency),
new SqlParameter("@AgentCode", agencyCode),
new SqlParameter("@InsuranceTypeID", insuranceTypeID)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@MainClass", Size = 50
}
};
object[] dataSet = BKICSQL.GetValues(DropDownSP.FetchInsuranceProductCode, param, outParams);
if (dataSet != null && dataSet[0] != null)
{
return(dataSet[0].ToString());
}
return(string.Empty);
}
/// <summary>
/// Fetch dropdowns by page type.
/// </summary>
/// <param name="type">Page type(e.g domestic help page)</param>
/// <returns>Dropdown response.</returns>
public FetchDropDownsResponse FetchDropDown(string type)
{
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@PageType", type)
};
DataSet ds = BKICSQL.eds(DropDownSP.FetchDropdowns, param);
return(new FetchDropDownsResponse
{
IsTransactionDone = true,
dropdownds = ds
});
}
catch (Exception ex)
{
return(new FetchDropDownsResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Post the domestic policy.
/// </summary>
/// <param name="details">Domestic policy details.</param>
/// <returns>Posted domestic id, document number and hir status.</returns>
public DomesticHelpPolicyResponse PostDomesticPolicy(DomesticPolicyDetails details)
{
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DomesticID", details.DomesticHelp.DomesticID),
new SqlParameter("@Agency", details.DomesticHelp.Agency ?? string.Empty),
new SqlParameter("@AgentCode", details.DomesticHelp.AgentCode ?? string.Empty),
new SqlParameter("@AgentBranch", details.DomesticHelp.AgentBranch ?? string.Empty),
new SqlParameter("@InsuredCode", details.DomesticHelp.InsuredCode ?? string.Empty),
new SqlParameter("@InsuredName", details.DomesticHelp.InsuredName ?? string.Empty),
new SqlParameter("@CPR", details.DomesticHelp.CPR ?? string.Empty),
new SqlParameter("@InsurancePeroid", details.DomesticHelp.InsurancePeroid),
new SqlParameter("@NumberOfDomesticWorkers", details.DomesticHelp.NoOfDomesticWorkers),
new SqlParameter("@PolicyStartDate", details.DomesticHelp.PolicyStartDate),
new SqlParameter("@DomesticworkerType", details.DomesticHelp.DomesticWorkType ?? string.Empty),
new SqlParameter("@IsPhysicalDefect", details.DomesticHelp.IsPhysicalDefect == "Yes"? true : false),
new SqlParameter("@PhysicalDescription", string.IsNullOrEmpty(details.DomesticHelp.PhysicalDefectDescription)?"":details.DomesticHelp.PhysicalDefectDescription),
new SqlParameter("@MobileNumber", details.DomesticHelp.Mobile ?? string.Empty),
new SqlParameter("@Createdby", details.DomesticHelp.CreatedBy),
new SqlParameter("@AuthorizedBy", details.DomesticHelp.AuthorizedBy),
new SqlParameter("@dt", details.DomesticHelpMemberdt),
new SqlParameter("@IsSaved", details.DomesticHelp.IsSaved),
new SqlParameter("@IsActive", details.DomesticHelp.IsActivePolicy),
new SqlParameter("@PaymentType", details.DomesticHelp.PaymentType),
new SqlParameter("@Remarks", details.DomesticHelp.Remarks),
new SqlParameter("@AccountNumber", details.DomesticHelp.AccountNumber),
new SqlParameter("@PremiumAfterDiscountAmount", details.DomesticHelp.PremiumAfterDiscount),
new SqlParameter("@CommisionAfterDiscountAmount", details.DomesticHelp.CommissionAfterDiscount),
new SqlParameter("@UserChangedPremium", details.DomesticHelp.UserChangedPremium),
new SqlParameter("@MainClass", details.DomesticHelp.MainClass),
new SqlParameter("@SubClass", details.DomesticHelp.SubClass),
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Int, ParameterName = "@NewDomesticID"
},
new SPOut()
{
OutPutType = SqlDbType.Bit, ParameterName = "@IsHIR"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@DocumentNumber", Size = 50
},
};
object[] dataSet = BKICSQL.GetValues(StoredProcedures.DomesticHelpInsuranceSP.PostDomesticPolicy, para, outParams);
var domesticID = Convert.ToInt64(dataSet[0]);
var IsHIR = Convert.ToBoolean(dataSet[1]);
var documentNo = Convert.ToString(dataSet[2]);
if (!IsHIR && details.DomesticHelp.IsActivePolicy)
{
try
{
new Task(() =>
{
OracleDBIntegration.DBObjects.TransactionWrapper oracleResult =
_oracleDomesticInsurance.IntegrateDomesticToOracle((int)domesticID);
}).Start();
}
catch (AggregateException ex)
{
foreach (Exception inner in ex.InnerExceptions)
{
_mail.SendMailLogError(inner.Message, details.DomesticHelp.InsuredCode,
"DomesticHelp", details.DomesticHelp.Agency, true);
}
}
}
return(new DomesticHelpPolicyResponse()
{
IsTransactionDone = true,
DomesticID = domesticID,
IsHIR = IsHIR,
DocumentNo = documentNo
});
}
catch (Exception ex)
{
_mail.SendMailLogError(ex.Message, details.DomesticHelp.InsuredCode,
"DomesticHelp", details.DomesticHelp.Agency, false);
return(new DomesticHelpPolicyResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Insert the travel endorsement.
/// </summary>
/// <param name="travelEndorsement">Travel endorsement details.</param>
/// <returns>Travelendorsementid, Travelendorementnumber.</returns>
public TravelEndorsementResponse PostTravelEndorsement(BO.TravelEndorsement travelEndorsement)
{
try
{
DataTable member = new DataTable();
member.Columns.Add("TRAVELID", typeof(Int64));
member.Columns.Add("DOCUMENTNO", typeof(string));
member.Columns.Add("ITEMSERIALNO", typeof(Int32));
member.Columns.Add("ITEMNAME", typeof(string));
member.Columns.Add("SUMINSURED", typeof(decimal));
member.Columns.Add("FOREIGNSUMINSURED", typeof(decimal));
member.Columns.Add("CATEGORY", typeof(string));
member.Columns.Add("TITLE", typeof(string));
member.Columns.Add("SEX", typeof(string));
member.Columns.Add("DATEOFBIRTH", typeof(DateTime));
member.Columns.Add("AGE", typeof(string));
member.Columns.Add("PREMIUMAMOUNT", typeof(decimal));
member.Columns.Add("MAKE", typeof(string));
member.Columns.Add("OCCUPATIONCODE", typeof(string));
member.Columns.Add("CPR", typeof(string));
member.Columns.Add("PASSPORT", typeof(string));
member.Columns.Add("FIRSTNAME", typeof(string));
member.Columns.Add("MIDDLENAME", typeof(string));
member.Columns.Add("LASTNAME", typeof(string));
member.Columns.Add("CREATEDBY", typeof(int));
member.Columns.Add("CREATEDDATE", typeof(DateTime));
member.Columns.Add("UPDATEDBY", typeof(int));
member.Columns.Add("UPDATEDDATE", typeof(DateTime));
member.Columns.Add("LINKID", typeof(string));
if (travelEndorsement.TravelMembers.Count > 0)
{
foreach (var members in travelEndorsement.TravelMembers)
{
members.UpdatedDate = DateTime.Now;
//members.CreatedDate = DateTime.Now;
//members.DateOfBirth = DateTime.Now;
member.Rows.Add(members.TravelID, members.DocumentNo, members.ItemSerialNo, members.ItemName, members.SumInsured,
members.ForeignSumInsured, members.Category, members.Title, members.Sex, members.DateOfBirth, members.Age,
members.PremiumAmount, members.Make, members.OccupationCode, members.CPR, members.Passport, members.FirstName,
members.MiddleName, members.LastName, members.CreatedBy, members.CreatedDate, members.UpdatedBy, members.UpdatedDate, "");
}
}
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@TravelID", travelEndorsement.TravelID),
new SqlParameter("@TravelendorsementID", travelEndorsement.TravelEndorsementID),
new SqlParameter("@EndorsementType", travelEndorsement.EndorsementType ?? ""),
new SqlParameter("@Agency", travelEndorsement.Agency),
new SqlParameter("@AgentCode", travelEndorsement.AgencyCode),
new SqlParameter("@BranchCode", travelEndorsement.AgentBranch ?? ""),
new SqlParameter("@CreatedBy", travelEndorsement.CreatedBy),
new SqlParameter("@DocumentNo", travelEndorsement.DocumentNo ?? ""),
new SqlParameter("@InsuredCode", travelEndorsement.InsuredCode ?? ""),
new SqlParameter("@InsuredName", travelEndorsement.InsuredName ?? ""),
new SqlParameter("@Premium", travelEndorsement.PremiumAmount),
new SqlParameter("@FinanceCompany", travelEndorsement.FinancierCompanyCode ?? ""),
new SqlParameter("@MainClass", travelEndorsement.Mainclass ?? ""),
new SqlParameter("@SubClass", travelEndorsement.Subclass ?? ""),
new SqlParameter("@CommencementDate", travelEndorsement.PolicyCommencementDate),
new SqlParameter("@ExpireDate", travelEndorsement.ExpiryDate),
new SqlParameter("@ExtendedExpireDate", travelEndorsement.ExtendedExpireDate.HasValue ? travelEndorsement.ExtendedExpireDate.Value : (object)DBNull.Value),
new SqlParameter("@CancelDate", travelEndorsement.CancelDate.HasValue ? travelEndorsement.CancelDate.Value : (object)DBNull.Value),
new SqlParameter("@PaymentDate", travelEndorsement.PaymentDate.HasValue ? travelEndorsement.PaymentDate.Value : (object)DBNull.Value),
new SqlParameter("@PaymentType", travelEndorsement.PaymentType ?? ""),
new SqlParameter("@AccountNumber", travelEndorsement.AccountNumber ?? ""),
new SqlParameter("@Remarks", travelEndorsement.Remarks ?? ""),
new SqlParameter("@Source", travelEndorsement.Source ?? ""),
new SqlParameter("@IsSaved", travelEndorsement.IsSaved),
new SqlParameter("@IsActive", travelEndorsement.IsActivePolicy),
new SqlParameter("@dt", member),
new SqlParameter("@RefundType", travelEndorsement.RefundType ?? ""),
new SqlParameter("@PolicyPeriodName", travelEndorsement.PolicyPeriodName ?? ""),
new SqlParameter("@NewPremium", travelEndorsement.NewPremium),
new SqlParameter("@RefoundAmount", travelEndorsement.RefundAmount),
new SqlParameter("@RefoundAfterDiscount", travelEndorsement.RefundAfterDiscount),
new SqlParameter("@PremiumBeforeDiscount", travelEndorsement.PremiumBeforeDiscount),
new SqlParameter("@PremiumAfterDiscount", travelEndorsement.PremiumAfterDiscount),
new SqlParameter("@CommissionBeforeDiscount", travelEndorsement.CommisionBeforeDiscount),
new SqlParameter("@CommissionAfterDiscount", travelEndorsement.CommissionAfterDiscount),
new SqlParameter("@UserChangedPremium", travelEndorsement.UserChangedPremium),
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.BigInt, ParameterName = "@NewTravelEndorsementID"
},
new SPOut()
{
OutPutType = SqlDbType.Bit, ParameterName = "@IsHIR"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@EndorsementNumber", Size = 50
},
};
object[] dataSet = BKICSQL.GetValues(TravelEndorsementSP.PostTravelEndorsement, paras, outParams);
var endorsementID = string.IsNullOrEmpty(dataSet[0].ToString()) ? 0 : Convert.ToInt64(dataSet[0].ToString());
var isHIR = string.IsNullOrEmpty(dataSet[1].ToString()) ? false : Convert.ToBoolean(dataSet[1].ToString());
var EndorsementNumber = string.IsNullOrEmpty(dataSet[2].ToString()) ? string.Empty : Convert.ToString(dataSet[2].ToString());
return(new TravelEndorsementResponse()
{
IsTransactionDone = true,
EndorsementNo = EndorsementNumber,
TravelEndorsementID = endorsementID,
IsHIR = isHIR
});
}
catch (Exception ex)
{
_mail.SendMailLogError(ex.Message, travelEndorsement.InsuredCode, "MotorEndorsement", travelEndorsement.Agency, false);
return(new TravelEndorsementResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Get domestic policy details by document number(policy number)
/// </summary>
/// <param name="documentNo">document number</param>
/// <param name="agentCode">agent code</param>
/// <param name="isEndorsement">details fetched for endorsement page or policy page.</param>
/// <param name="endorsementID">endoresment id</param>
/// <returns></returns>
public DomesticHelpSavedQuotationResponse GetSavedDomesticPolicy(string documentNo, string agentCode, bool isEndorsement = false, long endorsementID = 0)
{
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DocumentNo", documentNo),
new SqlParameter("@AgentCode", agentCode)
};
DataSet domesticds = BKICSQL.eds(StoredProcedures.DomesticHelpInsuranceSP.GetSavedQuotationByDocumentNo, para);
DomesticHelpPolicy domestic = new DomesticHelpPolicy();
if (domesticds != null && domesticds.Tables[0].Rows.Count > 0)
{
DataRow dr = domesticds.Tables[0].Rows[0];
domestic.DomesticID = Convert.ToInt64(dr["DOMESTICID"]);
domestic.InsurancePeroid = Convert.ToInt32(dr["INSURANCEPERIOD"]);
domestic.AgentBranch = Convert.ToString(dr["BRANCHCODE"]);
domestic.PolicyStartDate = Convert.ToDateTime(dr["COMMENCEDATE"]);
domestic.PolicyExpiryDate = Convert.ToDateTime(dr["EXPIRYDATE"]);
domestic.PolicyIssueDate = Convert.ToDateTime(dr["DATEOFSUBMISSION"]);
domestic.CPR = Convert.ToString(dr["CPR"]);
domestic.FullName = Convert.ToString(dr["INSUREDNAME"]);
domestic.PremiumAfterDiscount = dr.IsNull("PREMIUMAMOUNT") ? 0 : Convert.ToDecimal(dr["PREMIUMAMOUNT"]);
domestic.PremiumBeforeDiscount = Convert.ToDecimal(dr["ORIGINALPREMIUMAMOUNT"]);
domestic.DocumentNo = Convert.ToString(dr["DOCUMENTNO"]);
domestic.SumInsured = Convert.ToDecimal(dr["SUMINSURED"]);
domestic.InsuredCode = Convert.ToString(dr["INSUREDCODE"]);
domestic.DomesticWorkType = dr["DomesticWorkerType"].ToString() ?? "";
domestic.IsPhysicalDefect = dr["PhysicalDefect"].ToString() == null ? "" : dr["PhysicalDefect"].ToString();
domestic.PhysicalDefectDescription = dr["PhysicalDesc"].ToString() == null ? "" : dr["PhysicalDesc"].ToString();
domestic.InsuredCode = Convert.ToString(dr["INSUREDCODE"]);
domestic.IsHIR = Convert.ToBoolean(dr["IsHIR"]);
domestic.Remarks = dr["Remarks"].ToString() == null ? "" : Convert.ToString(dr["Remarks"]);
domestic.AccountNumber = dr["AccountNumber"].ToString() == null ? "" : Convert.ToString(dr["AccountNumber"]);
domestic.CommisionBeforeDiscount = dr.IsNull("CommissionBeforeDiscount") ? 0 : Convert.ToDecimal(dr["CommissionBeforeDiscount"]);
domestic.CommissionAfterDiscount = dr.IsNull("CommissionAfterDiscount") ? 0 : Convert.ToDecimal(dr["CommissionAfterDiscount"]);
domestic.CommissionAmount = dr.IsNull("CommissionAmount") ? 0 : Convert.ToDecimal(dr["CommissionAmount"]);
domestic.IsSaved = dr.IsNull("IsSaved") ? false : Convert.ToBoolean(dr["IsSaved"]);
domestic.IsActivePolicy = dr.IsNull("IsActive") ? false : Convert.ToBoolean(dr["IsActive"]);
domestic.PolicyIssueDate = Convert.ToDateTime(dr["DATEOFSUBMISSION"]);
domestic.PaymentType = dr["PAYMENTTYPE"].ToString() == null ? "" : Convert.ToString(dr["PAYMENTTYPE"]);
domestic.HIRStatus = dr.IsNull("HIRStatus") ? 0 : Convert.ToInt32(dr["HIRStatus"]);
domestic.TaxOnPremium = dr.IsNull("TaxOnPremium") ? 0 : Convert.ToDecimal(dr["TaxOnPremium"]);
domestic.TaxOnCommission = dr.IsNull("TaxOnCommission") ? 0 : Convert.ToDecimal(dr["TaxOnCommission"]);
}
List <DomesticHelpMember> membersList = new List <DomesticHelpMember>();
if (domesticds != null && domesticds.Tables[1].Rows.Count > 0)
{
domestic.NoOfDomesticWorkers = domesticds.Tables[1].Rows.Count;
foreach (DataRow dr in domesticds.Tables[1].Rows)
{
DomesticHelpMember members = new DomesticHelpMember();
members.InsuredCode = Convert.ToString(dr["INSUREDCODE"]);
members.SumInsured = Convert.ToDecimal(dr["SUMINSURED"]);
members.PremiumAmount = Convert.ToDecimal(dr["PREMIUMAMOUNT"]);
members.OtherOccupation = Convert.ToString(dr["OCCUPATIONOTHER"]);
members.CommencementDate = Convert.ToDateTime(dr["COMMENCEDATE"]);
members.ExpiryDate = Convert.ToDateTime(dr["EXPIRYDATE"]);
members.Name = Convert.ToString(dr["INSUREDNAME"]);
members.Sex = Convert.ToChar(dr["SEX"]);
members.DOB = Convert.ToDateTime(dr["DOB"]);
members.Nationality = Convert.ToString(dr["NATIONALITY"]);
members.CPRNumber = Convert.ToString(dr["IDENTITYNO"]);
members.Occupation = Convert.ToString(dr["OCCUPATION"]);
members.ItemserialNo = Convert.ToInt32(dr["ITEMSERIALNO"]);
members.AddressType = Convert.ToString(dr["ADDRESS1"]);
members.Passport = Convert.ToString(dr["Passport"]);
membersList.Add(members);
}
}
return(new DomesticHelpSavedQuotationResponse
{
IsTransactionDone = true,
DomesticHelp = domestic,
DomesticHelpMemberList = membersList
});
}
catch (Exception ex)
{
return(new DomesticHelpSavedQuotationResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
/// <summary>
/// Get the domestic policy details by domestic id.
/// </summary>
/// <param name="domesticID">doemstic id</param>
/// <param name="insuredCode">insured code</param>
/// <returns></returns>
public DomesticHelpSavedQuotationResponse GetSavedDomesticHelp(int domesticID, string insuredCode)
{
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DomesticID", domesticID),
new SqlParameter("@InsuredCode", insuredCode)
};
DataSet domesticds = BKICSQL.eds(StoredProcedures.DomesticHelpInsuranceSP.SavedQuotation, para);
DomesticHelpPolicy domestic = new DomesticHelpPolicy();
if (domesticds != null && domesticds.Tables[0].Rows.Count > 0)
{
DataRow dr = domesticds.Tables[0].Rows[0];
domestic.DomesticID = domesticID;
domestic.InsurancePeroid = Convert.ToInt32(dr["INSURANCEPERIOD"]);
domestic.PolicyStartDate = Convert.ToDateTime(dr["COMMENCEDATE"]);
domestic.PolicyExpiryDate = Convert.ToDateTime(dr["EXPIRYDATE"]);
domestic.CPR = Convert.ToString(dr["CPR"]);
domestic.FullName = Convert.ToString(dr["INSUREDNAME"]);
domestic.PremiumAfterDiscount = Convert.ToDecimal(dr["PREMIUMAMOUNT"]);
domestic.PremiumBeforeDiscount = Convert.ToDecimal(dr["ORIGINALPREMIUMAMOUNT"]);
domestic.DocumentNo = Convert.ToString(dr["DOCUMENTNO"]);
domestic.SumInsured = Convert.ToDecimal(dr["SUMINSURED"]);
domestic.InsuredCode = Convert.ToString(dr["INSUREDCODE"]);
domestic.DomesticWorkType = dr["DomesticWorkerType"].ToString() == null ? "" : dr["DomesticWorkerType"].ToString();
domestic.IsPhysicalDefect = dr["PhysicalDefect"].ToString() == null ? "" : dr["PhysicalDefect"].ToString();
domestic.PhysicalDefectDescription = dr["PhysicalDesc"].ToString() == null ? "" : dr["PhysicalDesc"].ToString();
domestic.InsuredCode = insuredCode;
domestic.IsHIR = Convert.ToBoolean(dr["IsHIR"]);
}
List <DomesticHelpMember> membersList = new List <DomesticHelpMember>();
if (domesticds != null && domesticds.Tables[1].Rows.Count > 0)
{
domestic.NoOfDomesticWorkers = domesticds.Tables[1].Rows.Count;
foreach (DataRow dr in domesticds.Tables[1].Rows)
{
DomesticHelpMember members = new DomesticHelpMember();
members.InsuredCode = Convert.ToString(dr["INSUREDCODE"]);
members.SumInsured = Convert.ToDecimal(dr["SUMINSURED"]);
members.PremiumAmount = Convert.ToDecimal(dr["PREMIUMAMOUNT"]);
members.OtherOccupation = Convert.ToString(dr["OCCUPATIONOTHER"]);
// members.DateOfSubmission = Convert.ToDateTime(dr["DATEOFSUBMISSION"]);
members.CommencementDate = Convert.ToDateTime(dr["COMMENCEDATE"]);
members.ExpiryDate = Convert.ToDateTime(dr["EXPIRYDATE"]);
members.Name = Convert.ToString(dr["INSUREDNAME"]);
members.Sex = Convert.ToChar(dr["SEX"]);
members.DOB = Convert.ToDateTime(dr["DOB"]);
members.Nationality = Convert.ToString(dr["NATIONALITY"]);
members.CPRNumber = Convert.ToString(dr["IDENTITYNO"]);
members.Occupation = Convert.ToString(dr["OCCUPATION"]);
members.ItemserialNo = Convert.ToInt32(dr["ITEMSERIALNO"]);
members.AddressType = Convert.ToString(dr["ADDRESS1"]);
members.Passport = Convert.ToString(dr["Passport"]);
membersList.Add(members);
}
}
return(new DomesticHelpSavedQuotationResponse
{
IsTransactionDone = true,
DomesticHelp = domestic,
DomesticHelpMemberList = membersList
});
}
catch (Exception ex)
{
return(new DomesticHelpSavedQuotationResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
private BO.PolicyRecord InsertHomeMain(BO.HomeInsurancePolicyDetails policy, string spName)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@HomeID", policy.HomeInsurancePolicy.HomeID),
new SqlParameter("@InsuredCode", policy.HomeInsurancePolicy.InsuredCode),
new SqlParameter("@InsuredName", policy.HomeInsurancePolicy.InsuredName),
new SqlParameter("@CPR", policy.HomeInsurancePolicy.CPR),
new SqlParameter("@Agency", policy.HomeInsurancePolicy.Agency),
new SqlParameter("@AgentCode", policy.HomeInsurancePolicy.AgentCode),
new SqlParameter("@BranchCode", policy.HomeInsurancePolicy.AgentBranch),
new SqlParameter("@MainClass", policy.HomeInsurancePolicy.MainClass),
new SqlParameter("@SubClass", policy.HomeInsurancePolicy.SubClass),
new SqlParameter("@MobileNumber", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.Mobile)
? policy.HomeInsurancePolicy.Mobile:""),
new SqlParameter("@PolicyStartDate", policy.HomeInsurancePolicy.PolicyStartDate != null?
policy.HomeInsurancePolicy.PolicyStartDate:(object)DBNull.Value),
new SqlParameter("@BuildingValue", policy.HomeInsurancePolicy.BuildingValue),
new SqlParameter("@ContentValue", policy.HomeInsurancePolicy.ContentValue),
new SqlParameter("@JewelleryValue", policy.HomeInsurancePolicy.JewelleryValue),
new SqlParameter("@BuildingAge", policy.HomeInsurancePolicy.BuildingAge),
new SqlParameter("@IsPropertyMortgaged", policy.HomeInsurancePolicy.IsPropertyMortgaged),
new SqlParameter("@FinancierCode", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.FinancierCode)
? policy.HomeInsurancePolicy.FinancierCode : ""),
new SqlParameter("@IsSafePropertyInsured", policy.HomeInsurancePolicy.IsSafePropertyInsured),
new SqlParameter("@JewelleryCover", policy.HomeInsurancePolicy.JewelleryCover),
new SqlParameter("@IsRiotStrikeDamage", policy.HomeInsurancePolicy.IsRiotStrikeDamage),
new SqlParameter("@IsJointOwnership", policy.HomeInsurancePolicy.IsJointOwnership),
new SqlParameter("@JointOwnerName", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.JointOwnerName)
? policy.HomeInsurancePolicy.JointOwnerName :""),
new SqlParameter("@NamePolicyReasonSeekingReasons", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.NamePolicyReasonSeekingReasons)
? policy.HomeInsurancePolicy.NamePolicyReasonSeekingReasons : ""),
new SqlParameter("@IsPropertyInConnectionTrade", policy.HomeInsurancePolicy.IsPropertyInConnectionTrade),
new SqlParameter("@IsPropertyCoveredOtherInsurance", policy.HomeInsurancePolicy.IsPropertyCoveredOtherInsurance),
new SqlParameter("@IsPropertyInsuredSustainedAnyLoss", policy.HomeInsurancePolicy.IsPropertyInsuredSustainedAnyLoss),
new SqlParameter("@IsPropertyUndergoingConstruction", policy.HomeInsurancePolicy.IsPropertyUndergoingConstruction),
new SqlParameter("@IsSingleItemAboveContents", policy.HomeInsurancePolicy.IsSingleItemAboveContents),
new SqlParameter("@BuildingNo", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.BuildingNo)?
policy.HomeInsurancePolicy.BuildingNo:""),
new SqlParameter("@FlatNo", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.FlatNo) ? policy.HomeInsurancePolicy.FlatNo:""),
new SqlParameter("@HouseNo", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.HouseNo) ? policy.HomeInsurancePolicy.HouseNo:""),
new SqlParameter("@NoOfFloors", policy.HomeInsurancePolicy.NoOfFloors),
new SqlParameter("@Area", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.Area) ? policy.HomeInsurancePolicy.Area:""),
new SqlParameter("@BuildingType", policy.HomeInsurancePolicy.BuildingType),
new SqlParameter("@RoadNo", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.RoadNo) ? policy.HomeInsurancePolicy.RoadNo:""),
new SqlParameter("@BlockNo", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.BlockNo) ? policy.HomeInsurancePolicy.BlockNo:""),
new SqlParameter("@ResidanceTypeCode", policy.HomeInsurancePolicy.BuildingType == 1 ? "H" : "F"),
new SqlParameter("@FFPNumber", !string.IsNullOrEmpty(policy.HomeInsurancePolicy.FFPNumber) ? policy.HomeInsurancePolicy.FFPNumber:""),
new SqlParameter("@IsRequireDomestic", policy.HomeInsurancePolicy.IsRequireDomestic),
new SqlParameter("@NumberOfDomesticWorker", policy.HomeInsurancePolicy.NoOfDomesticWorker),
new SqlParameter("@CreatedBy", policy.HomeInsurancePolicy.CreatedBy),
new SqlParameter("@AuthorizedBy", policy.HomeInsurancePolicy.AuthorizedBy),
new SqlParameter("@IsSaved", policy.HomeInsurancePolicy.IsSaved),
new SqlParameter("@IsActive", policy.HomeInsurancePolicy.IsActivePolicy),
new SqlParameter("@PaymentType", string.IsNullOrEmpty(policy.HomeInsurancePolicy.PaymentType) ? string.Empty : policy.HomeInsurancePolicy.PaymentType),
new SqlParameter("@AccountNumber", string.IsNullOrEmpty(policy.HomeInsurancePolicy.AccountNumber)? string.Empty : policy.HomeInsurancePolicy.AccountNumber),
new SqlParameter("@Remarks", string.IsNullOrEmpty(policy.HomeInsurancePolicy.Remarks) ? string.Empty : policy.HomeInsurancePolicy.Remarks),
new SqlParameter("@HomeSubItemsdt", policy.HomeSubItemsdt),
new SqlParameter("@HomeDomesticdt", policy.HomeDomesticHelpdt),
new SqlParameter("@PremiumBeforeDiscount", PremiumBeforeDiscount),
new SqlParameter("@PremiumAfterDiscount", PremiumAfterDiscount),
new SqlParameter("@CommissionBeforeDiscount", CommissionBeforeDiscount),
new SqlParameter("@CommissionAfterDiscount", CommissionAfterDiscount),
new SqlParameter("@TaxOnPremiumBeforeDiscount", TaxOnPremiumBeforeDiscount),
new SqlParameter("@TaxOnPremiumAfterDiscount", TaxOnPremiumAfterDiscount),
new SqlParameter("@TaxOnCommissionBeforeDiscount", TaxOnCommissionBeforeDiscount),
new SqlParameter("@TaxOnCommissionAfterDiscount", TaxOnCommissionAfterDiscount),
new SqlParameter("@BuildingPremium", BuildingPremium),
new SqlParameter("@ContentPremium", ContentPremium),
new SqlParameter("@TotalPremium", TotalPremium),
new SqlParameter("@BuildingRiot", BuildingRiot),
new SqlParameter("@ContentRiot", ContentRiot),
new SqlParameter("@TotalRiot", TotalRiot),
new SqlParameter("@JewelleryAmount", JewellerAmount),
new SqlParameter("@DomesticHelperAmount", DomesticHelperAmount),
new SqlParameter("@Discount", Discount),
new SqlParameter("@RiotRate", RiotRate),
new SqlParameter("@Rate", BaseBuildingContentRate),
new SqlParameter("@IsHIR", IsHIR),
new SqlParameter("@HIRReason", HIRReason ?? string.Empty),
new SqlParameter("@HIRStatus", HIRStatus),
new SqlParameter("@UserChangedPremium", policy.HomeInsurancePolicy.UserChangedPremium),
new SqlParameter("@OldDocumentNumber", policy.HomeInsurancePolicy.OldDocumentNumber ?? string.Empty),
new SqlParameter("@RenewalDocumentNumber", policy.HomeInsurancePolicy.DocumentNo ?? string.Empty),
new SqlParameter("@OldRenewalCount", policy.HomeInsurancePolicy.RenewalCount),
new SqlParameter("@RenewalDelayedDays", policy.HomeInsurancePolicy.RenewalDelayedDays),
new SqlParameter("@ActualRenewalStartDate", policy.HomeInsurancePolicy.ActualRenewalStartDate.HasValue ? policy.HomeInsurancePolicy.ActualRenewalStartDate : (object)DBNull.Value)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Int, ParameterName = "@NewHomeID"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@DocumentNumber", Size = 100
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@LinkIDNew", Size = 100
},
new SPOut()
{
OutPutType = SqlDbType.Int, ParameterName = "@RenewalCount"
},
};
object[] dataSet = BKICSQL.GetValues(spName, paras, outParams);
var HomeID = Convert.ToInt64(dataSet[0]);
var DocNo = Convert.ToString(dataSet[1]);
var LinkID = Convert.ToString(dataSet[2]);
var RenewalCount = Convert.ToInt32(dataSet[3]);
return(new BO.PolicyRecord
{
IsInserted = true,
DocumentNumber = DocNo,
LinkID = LinkID,
NewHomeID = HomeID,
RenewalCount = RenewalCount
});
}
public DropDownResult GetPageDropDowns(string pageName)
{
try
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@PageType", pageName)
};
DataSet result = BKICSQL.eds(StoredProcedures.BKICDropDowns.GetPageDropDowns, para);
if (pageName == PageType.Profile || pageName == PageType.TravelInsurance)
{
DataTable userTitle = new DataTable();
userTitle.Columns.Add("Value");
userTitle.Columns.Add("Text");
userTitle.Rows.Add("MR", "MR");
userTitle.Rows.Add("MRS", "MRS");
userTitle.Rows.Add("MISS", "MISS");
DataTable userGender = new DataTable();
userGender.Columns.Add("Value");
userGender.Columns.Add("Text");
userGender.Rows.Add("M", "Male");
userGender.Rows.Add("F", "Female");
result.Tables.Add(userTitle);
result.Tables.Add(userGender);
}
if (pageName == PageType.MotorQuote || pageName == PageType.MotorInsurance)
{
DataTable motorType = new DataTable();
motorType.Columns.Add("Value");
motorType.Columns.Add("Text");
motorType.Rows.Add("NEW", "New Vehicle");
motorType.Rows.Add("USED", "Used Vehicle");
result.Tables.Add(motorType);
DataTable months = new DataTable();
months.Columns.Add("Months");
months.Rows.Add("January");
months.Rows.Add("February");
months.Rows.Add("March");
months.Rows.Add("April");
months.Rows.Add("May");
months.Rows.Add("June");
months.Rows.Add("July");
months.Rows.Add("August");
months.Rows.Add("September");
months.Rows.Add("October");
months.Rows.Add("November");
months.Rows.Add("December");
result.Tables.Add(months);
if (pageName == PageType.MotorInsurance)
{
DataTable deliveryOptions = new DataTable();
deliveryOptions.Columns.Add("Value");
deliveryOptions.Columns.Add("Text");
deliveryOptions.Rows.Add("BRANCH", "Branch");
deliveryOptions.Rows.Add("ADDRESS", "Deliver to address");
result.Tables.Add(deliveryOptions);
DataTable deliveryAddressOptions = new DataTable();
deliveryAddressOptions.Columns.Add("Value");
deliveryAddressOptions.Columns.Add("Text");
deliveryAddressOptions.Rows.Add("Same Address", "Same Address");
deliveryAddressOptions.Rows.Add("Different Address", "Different Address");
result.Tables.Add(deliveryAddressOptions);
DataTable CarReplacementDays = new DataTable();
CarReplacementDays.Columns.Add("Value");
CarReplacementDays.Columns.Add("Text");
CarReplacementDays.Rows.Add("7", "7 days");
CarReplacementDays.Rows.Add("14", "14 days");
result.Tables.Add(CarReplacementDays);
}
}
if (pageName == PageType.HomeQuote || pageName == PageType.HomeInsurance)
{
DataTable propertyInsured = new DataTable();
propertyInsured.Columns.Add("Value");
propertyInsured.Columns.Add("Text");
propertyInsured.Rows.Add("1", "Yes");
propertyInsured.Rows.Add("0", "No");
result.Tables.Add(propertyInsured);
DataTable maliciousCover = new DataTable();
maliciousCover.Columns.Add("Value");
maliciousCover.Columns.Add("Text");
maliciousCover.Rows.Add("1", "Yes");
maliciousCover.Rows.Add("0", "No");
result.Tables.Add(maliciousCover);
DataTable helpCover = new DataTable();
helpCover.Columns.Add("Value");
helpCover.Columns.Add("Text");
helpCover.Rows.Add("1", "Yes");
helpCover.Rows.Add("0", "No");
result.Tables.Add(helpCover);
DataTable workersCover = new DataTable();
workersCover.Columns.Add("Value");
workersCover.Columns.Add("Text");
workersCover.Rows.Add("1", "1");
workersCover.Rows.Add("2", "2");
workersCover.Rows.Add("3", "3");
workersCover.Rows.Add("4", "4");
workersCover.Rows.Add("5", "5");
workersCover.Rows.Add("6", "6");
workersCover.Rows.Add("7", "7");
workersCover.Rows.Add("8", "8");
workersCover.Rows.Add("9", "9");
workersCover.Rows.Add("10", "10");
result.Tables.Add(workersCover);
if (pageName == PageType.HomeInsurance)
{
DataTable yesOrNo = new DataTable();
yesOrNo.Columns.Add("Value");
yesOrNo.Columns.Add("Text");
yesOrNo.Rows.Add("yes", "Yes");
yesOrNo.Rows.Add("no", "No");
result.Tables.Add(yesOrNo);
DataTable buildingAge = new DataTable();
buildingAge.Columns.Add("Value");
buildingAge.Columns.Add("Text");
buildingAge.Rows.Add("1", "1");
buildingAge.Rows.Add("2", "2");
buildingAge.Rows.Add("3", "3");
buildingAge.Rows.Add("4", "4");
buildingAge.Rows.Add("5", "5");
buildingAge.Rows.Add("6", "6");
buildingAge.Rows.Add("7", "7");
buildingAge.Rows.Add("8", "8");
buildingAge.Rows.Add("9", "9");
buildingAge.Rows.Add("10", "10");
buildingAge.Rows.Add("11", "11");
buildingAge.Rows.Add("12", "12");
buildingAge.Rows.Add("13", "13");
buildingAge.Rows.Add("14", "14");
buildingAge.Rows.Add("15", "15");
buildingAge.Rows.Add("16", "16");
buildingAge.Rows.Add("17", "17");
buildingAge.Rows.Add("18", "18");
buildingAge.Rows.Add("19", "19");
buildingAge.Rows.Add("20", "20");
buildingAge.Rows.Add("21", "20+");
result.Tables.Add(buildingAge);
DataTable residentialType = new DataTable();
residentialType.Columns.Add("Value");
residentialType.Columns.Add("Text");
residentialType.Rows.Add("H", "Residential Villa");
residentialType.Rows.Add("F", "Residential Flat/Apartment");
result.Tables.Add(residentialType);
}
}
if (pageName == PageType.DomesticHelp)
{
DataTable domesticInsuranceYears = new DataTable();
domesticInsuranceYears.Columns.Add("Value");
domesticInsuranceYears.Columns.Add("Text");
domesticInsuranceYears.Rows.Add("1", "1");
domesticInsuranceYears.Rows.Add("2", "2");
result.Tables.Add(domesticInsuranceYears);
DataTable domesticHelpWorkers = new DataTable();
domesticHelpWorkers.Columns.Add("Value");
domesticHelpWorkers.Columns.Add("Text");
domesticHelpWorkers.Rows.Add("1", "1");
domesticHelpWorkers.Rows.Add("2", "2");
domesticHelpWorkers.Rows.Add("3", "3");
domesticHelpWorkers.Rows.Add("4", "4");
domesticHelpWorkers.Rows.Add("5", "5");
domesticHelpWorkers.Rows.Add("6", "6");
domesticHelpWorkers.Rows.Add("7", "7");
domesticHelpWorkers.Rows.Add("8", "8");
domesticHelpWorkers.Rows.Add("9", "9");
domesticHelpWorkers.Rows.Add("10", "10");
result.Tables.Add(domesticHelpWorkers);
DataTable domesticHelpWorkersType = new DataTable();
domesticHelpWorkersType.Columns.Add("Value");
domesticHelpWorkersType.Columns.Add("Text");
domesticHelpWorkersType.Rows.Add("Domestic", "Domestic");
domesticHelpWorkersType.Rows.Add("Business", "Business");
result.Tables.Add(domesticHelpWorkersType);
DataTable userGender = new DataTable();
userGender.Columns.Add("Value");
userGender.Columns.Add("Text");
userGender.Rows.Add("M", "Male");
userGender.Rows.Add("F", "Female");
result.Tables.Add(userGender);
}
return(new DropDownResult()
{
IsTransactionDone = true,
DataSets = result
});
}
catch (Exception exc)
{
return(new DropDownResult()
{
IsTransactionDone = false,
TransactionErrorMessage = exc.Message
});
}
}
private MotorEndorsementResult InsertMotorEndorsement(BO.MotorEndorsement motorEndorsement)
{
DataTable motorCovers = new DataTable();
motorCovers.Columns.Add("CoverCode", typeof(string));
motorCovers.Columns.Add("CoverDescription", typeof(string));
motorCovers.Columns.Add("CoverAmount", typeof(decimal));
motorCovers.Columns.Add("AddedByEndorsement", typeof(bool));
if (motorEndorsement.Covers != null && motorEndorsement.Covers.Count > 0)
{
foreach (var cover in motorEndorsement.Covers)
{
motorCovers.Rows.Add(cover.CoverCode, cover.CoverDescription, cover.CoverAmount, cover.AddedByEndorsement);
}
}
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@MotorID", motorEndorsement.MotorID),
new SqlParameter("@MotorendorsementID", motorEndorsement.MotorEndorsementID),
new SqlParameter("@EndorsementType", motorEndorsement.EndorsementType ?? ""),
new SqlParameter("@Agency", motorEndorsement.Agency),
new SqlParameter("@AgentCode", motorEndorsement.AgencyCode),
new SqlParameter("@BranchCode", motorEndorsement.AgentBranch ?? ""),
new SqlParameter("@CreatedBy", motorEndorsement.CreatedBy),
new SqlParameter("@DocumentNo", motorEndorsement.DocumentNo ?? ""),
new SqlParameter("@InsuredCode", motorEndorsement.InsuredCode ?? ""),
new SqlParameter("@OldInsuredCode", motorEndorsement.OldInsuredCode ?? " "),
new SqlParameter("@InsuredName", motorEndorsement.InsuredName ?? ""),
new SqlParameter("@OldInsuredName", motorEndorsement.OldInsuredName ?? ""),
new SqlParameter("@RegistrationNo", motorEndorsement.RegistrationNo ?? ""),
new SqlParameter("@OldRegistrationNo", motorEndorsement.OldRegistrationNo ?? ""),
new SqlParameter("@ChassisNo", motorEndorsement.ChassisNo ?? ""),
new SqlParameter("@OldChassisNo", motorEndorsement.OldChassisNo ?? ""),
new SqlParameter("@VechicleValue", motorEndorsement.VehicleValue),
new SqlParameter("@Premium", motorEndorsement.PremiumAmount),
new SqlParameter("@FinanceCompany", motorEndorsement.FinancierCompanyCode ?? ""),
new SqlParameter("@MainClass", motorEndorsement.Mainclass ?? ""),
new SqlParameter("@SubClass", motorEndorsement.Subclass ?? ""),
new SqlParameter("@CommencementDate", motorEndorsement.PolicyCommencementDate),
new SqlParameter("@ExpireDate", motorEndorsement.ExpiryDate),
new SqlParameter("@ExtendedExpireDate", motorEndorsement.ExtendedExpireDate.HasValue ? motorEndorsement.ExtendedExpireDate.Value : (object)DBNull.Value),
new SqlParameter("@CancelDate", motorEndorsement.CancelDate.HasValue ? motorEndorsement.CancelDate.Value : (object)DBNull.Value),
new SqlParameter("@PaymentDate", motorEndorsement.PaymentDate.HasValue ? motorEndorsement.PaymentDate.Value : (object)DBNull.Value),
new SqlParameter("@PaymentType", motorEndorsement.PaymentType ?? ""),
new SqlParameter("@AccountNumber", motorEndorsement.AccountNumber ?? ""),
new SqlParameter("@Remarks", motorEndorsement.Remarks ?? ""),
new SqlParameter("@Source", motorEndorsement.Source ?? ""),
new SqlParameter("@RefundType", motorEndorsement.RefundType ?? ""),
new SqlParameter("@IsSaved", motorEndorsement.IsSaved),
new SqlParameter("@IsActive", motorEndorsement.IsActivePolicy),
new SqlParameter("@dt", motorCovers),
new SqlParameter("@RefoundAmount", motorEndorsement.RefundAmount),
new SqlParameter("@RefoundAfterDiscount", motorEndorsement.RefundAfterDiscount),
new SqlParameter("@NewExcess", motorEndorsement.NewExcess),
new SqlParameter("@CPR", motorEndorsement.CPR),
new SqlParameter("@PremiumBeforeDiscount", motorEndorsement.PremiumBeforeDiscount),
new SqlParameter("@PremiumAfterDiscount", motorEndorsement.PremiumAfterDiscount),
new SqlParameter("@CommissionBeforeDiscount", motorEndorsement.CommisionBeforeDiscount),
new SqlParameter("@CommissionAfterDiscount", motorEndorsement.CommissionAfterDiscount),
new SqlParameter("@UserChangedPremium", motorEndorsement.UserChangedPremium),
new SqlParameter("@VehicleMake", motorEndorsement.VehicleMake),
new SqlParameter("@VehicleModel", motorEndorsement.VehicleModel),
new SqlParameter("@VehicleYear", motorEndorsement.VehicleYear),
new SqlParameter("@VehicleBodyType", motorEndorsement.VehicleBodyType),
new SqlParameter("@Tonnage", motorEndorsement.EngineCC)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.BigInt, ParameterName = "@NewMotorEndorsementID"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@EndorsementNumber", Size = 50
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@DocumentNumber", Size = 50
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@EndorsementLinkID", Size = 50
},
new SPOut()
{
OutPutType = SqlDbType.Int, ParameterName = "@EndorsementCount"
},
};
object[] dataSet = BKICSQL.GetValues(MotorEndorsementSP.PostMotorEndorsement, paras, outParams);
var endorsementID = string.IsNullOrEmpty(dataSet[0].ToString()) ? 0 : Convert.ToInt64(dataSet[0].ToString());
var endorsementNumber = string.IsNullOrEmpty(dataSet[1].ToString()) ? string.Empty : Convert.ToString(dataSet[1].ToString());
var documentNumber = string.IsNullOrEmpty(dataSet[2].ToString()) ? string.Empty : Convert.ToString(dataSet[2].ToString());
var endorsementLinkID = string.IsNullOrEmpty(dataSet[3].ToString()) ? string.Empty : Convert.ToString(dataSet[3].ToString());
var endorsementCount = string.IsNullOrEmpty(dataSet[4].ToString()) ? 0: Convert.ToInt32(dataSet[4].ToString());
return(new MotorEndorsementResult()
{
IsTransactionDone = true,
EndorsementNo = endorsementNumber,
MotorEndorsementID = endorsementID,
LinkID = endorsementLinkID,
DocumentNo = documentNumber,
EndorsementCount = endorsementCount
});
}
/// <summary>
/// Insert the new user to the database.
/// </summary>
/// <param name="details">User details.</param>
/// <returns>User inserted or not.</returns>
public PostUserDetailsResult InsertUserMasterDetails(UserMaster details)
{
try
{
bool isExist = false;
Match password = Regex.Match(details.Password, Constants.RegularExpressions.PasswordStrength);
if (!password.Success)
{
return(new PostUserDetailsResult {
PasswordStrength = true
});
}
if (details.Type != "edit")
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@UserName", details.UserName)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Bit, ParameterName = "@IsUserNameExists"
},
};
object[] dataSet = BKICSQL.GetValues(UsersSP.UserNamePrecheck, param, outParams);
isExist = dataSet[0].ToString() == "True" ? true : false;
}
if (!isExist)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@Id", details.Id),
new SqlParameter("@Agency", string.IsNullOrEmpty(details.Agency)?"":details.Agency),
new SqlParameter("@AgentCode", details.AgentCode ?? string.Empty),
new SqlParameter("@AgentBranch", details.AgentBranch ?? string.Empty),
new SqlParameter("@UserID", details.UserID ?? string.Empty),
new SqlParameter("@UserName", details.UserName ?? string.Empty),
new SqlParameter("@CreatedDate", details.CreatedDate),
// new SqlParameter("@Password", details.Password),
//new SqlParameter("@PasswordExpiryDate", details.PasswordExpiryDate),
new SqlParameter("@Mobile", details.Mobile ?? string.Empty),
new SqlParameter("@Email", details.Email ?? string.Empty),
new SqlParameter("@IsActive", true),
new SqlParameter("@StaffNo", details.StaffNo),
new SqlParameter("@Role", details.Role ?? string.Empty),
new SqlParameter("@CreatedBy", details.CreatedBy),
new SqlParameter("@Type", details.Type)
};
if (details.Type == "insert")
{
Membership.CreateUser(details.UserName, details.Password, details.Email);
//Roles.AddUserToRole(details.UserName, Constants.Roles.User);
Roles.AddUserToRole(details.UserName, details.Role);
}
else if (details.Type == "edit")
{
var memUser = Membership.GetUser(details.UserName);
memUser.Email = details.Email;
memUser.ChangePassword(memUser.ResetPassword(), details.Password);
//memUser.ResetPassword(details.Password);
Membership.UpdateUser(memUser);
}
BKICSQL.enq(UsersSP.PostUserMaster, para);
return(new PostUserDetailsResult
{
IsTransactionDone = true
});
}
else
{
return(new PostUserDetailsResult
{
IsUserAlreadyExists = true
});
}
}
catch (Exception ex)
{
return(new PostUserDetailsResult
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
private MotorEndorsementResult InsertAdminMotorEndorsement(BO.MotorEndorsement motorEndorsement)
{
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@MotorID", motorEndorsement.MotorID),
new SqlParameter("@MotorendorsementID", motorEndorsement.MotorEndorsementID),
new SqlParameter("@EndorsementType", motorEndorsement.EndorsementType ?? ""),
new SqlParameter("@Agency", motorEndorsement.Agency),
new SqlParameter("@AgentCode", motorEndorsement.AgencyCode),
new SqlParameter("@BranchCode", motorEndorsement.AgentBranch ?? ""),
new SqlParameter("@CreatedBy", motorEndorsement.CreatedBy),
new SqlParameter("@DocumentNo", motorEndorsement.DocumentNo ?? ""),
new SqlParameter("@InsuredCode", motorEndorsement.InsuredCode ?? ""),
new SqlParameter("@OldInsuredCode", motorEndorsement.OldInsuredCode ?? " "),
new SqlParameter("@InsuredName", motorEndorsement.InsuredName ?? ""),
new SqlParameter("@OldInsuredName", motorEndorsement.OldInsuredName ?? ""),
new SqlParameter("@RegistrationNo", motorEndorsement.RegistrationNo ?? ""),
new SqlParameter("@OldRegistrationNo", motorEndorsement.OldRegistrationNo ?? ""),
new SqlParameter("@ChassisNo", motorEndorsement.ChassisNo ?? ""),
new SqlParameter("@OldChassisNo", motorEndorsement.OldChassisNo ?? ""),
new SqlParameter("@VechicleValue", motorEndorsement.VehicleValue),
new SqlParameter("@Premium", motorEndorsement.PremiumAmount),
new SqlParameter("@FinanceCompany", motorEndorsement.FinancierCompanyCode ?? ""),
new SqlParameter("@MainClass", motorEndorsement.Mainclass ?? ""),
new SqlParameter("@SubClass", motorEndorsement.Subclass ?? ""),
new SqlParameter("@CommencementDate", motorEndorsement.PolicyCommencementDate),
new SqlParameter("@ExpireDate", motorEndorsement.ExpiryDate),
new SqlParameter("@ExtendedExpireDate", motorEndorsement.ExtendedExpireDate.HasValue ? motorEndorsement.ExtendedExpireDate.Value : (object)DBNull.Value),
new SqlParameter("@CancelDate", motorEndorsement.CancelDate.HasValue ? motorEndorsement.CancelDate.Value : (object)DBNull.Value),
new SqlParameter("@PaymentDate", motorEndorsement.PaymentDate.HasValue ? motorEndorsement.PaymentDate.Value : (object)DBNull.Value),
new SqlParameter("@PaymentType", motorEndorsement.PaymentType ?? ""),
new SqlParameter("@AccountNumber", motorEndorsement.AccountNumber ?? ""),
new SqlParameter("@Remarks", motorEndorsement.Remarks ?? ""),
new SqlParameter("@Source", motorEndorsement.Source ?? ""),
new SqlParameter("@IsSaved", motorEndorsement.IsSaved),
new SqlParameter("@IsActive", motorEndorsement.IsActivePolicy),
new SqlParameter("@RefoundAmount", motorEndorsement.RefundAmount),
new SqlParameter("@RefoundAfterDiscount", motorEndorsement.RefundAfterDiscount),
new SqlParameter("@NewPremium", motorEndorsement.NewPremium),
new SqlParameter("@NewSumInsured", motorEndorsement.NewSumInsured),
new SqlParameter("@NewExcess", motorEndorsement.NewExcess),
new SqlParameter("@CPR", motorEndorsement.CPR),
new SqlParameter("PremiumBeforeDiscount", motorEndorsement.PremiumBeforeDiscount),
new SqlParameter("@PremiumAfterDiscount", motorEndorsement.PremiumAfterDiscount),
new SqlParameter("@CommissionBeforeDiscount", motorEndorsement.CommisionBeforeDiscount),
new SqlParameter("@CommissionAfterDiscount", motorEndorsement.CommissionAfterDiscount),
new SqlParameter("@UserChangedPremium", motorEndorsement.UserChangedPremium),
new SqlParameter("@VehicleMake", motorEndorsement.VehicleMake),
new SqlParameter("@VehicleModel", motorEndorsement.VehicleModel),
new SqlParameter("@VehicleYear", motorEndorsement.VehicleYear),
new SqlParameter("@VehicleBodyType", motorEndorsement.VehicleBodyType),
new SqlParameter("@Tonnage", motorEndorsement.EngineCC)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.BigInt, ParameterName = "@NewMotorEndorsementID"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@EndorsementNumber", Size = 50
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@DocumentNumber", Size = 50
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@EndorsementLinkID", Size = 50
},
new SPOut()
{
OutPutType = SqlDbType.Int, ParameterName = "@EndorsementCount"
},
};
object[] dataSet = BKICSQL.GetValues(MotorEndorsementSP.PostAdminMotorEndorsement, paras, outParams);
var endorsementID = string.IsNullOrEmpty(dataSet[0].ToString()) ? 0 : Convert.ToInt64(dataSet[0].ToString());
var endorsementNumber = string.IsNullOrEmpty(dataSet[1].ToString()) ? string.Empty : Convert.ToString(dataSet[1].ToString());
var documentNumber = string.IsNullOrEmpty(dataSet[2].ToString()) ? string.Empty : Convert.ToString(dataSet[2].ToString());
var endorsementLinkID = string.IsNullOrEmpty(dataSet[3].ToString()) ? string.Empty : Convert.ToString(dataSet[3].ToString());
var endorsementCount = string.IsNullOrEmpty(dataSet[4].ToString()) ? 0 : Convert.ToInt32(dataSet[4].ToString());
return(new MotorEndorsementResult()
{
IsTransactionDone = true,
EndorsementNo = endorsementNumber,
MotorEndorsementID = endorsementID,
LinkID = endorsementLinkID,
DocumentNo = documentNumber,
EndorsementCount = endorsementCount
});
}
catch (Exception ex)
{
_mail.SendMailLogError(ex.Message, motorEndorsement.InsuredCode, "MotorEndorsement", motorEndorsement.Agency, false);
return(new MotorEndorsementResult()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
private PolicyRecord InsertMotorMain(MotorInsurancePolicy policy, string spName)
{
DataTable optionalCovers = new DataTable();
optionalCovers.Columns.Add("CoverCode", typeof(string));
optionalCovers.Columns.Add("CoverDescription", typeof(string));
optionalCovers.Columns.Add("CoverAmount", typeof(decimal));
optionalCovers.Columns.Add("IsOptionalCover", typeof(bool));
if (policy.OptionalCovers != null && policy.OptionalCovers.Count > 0)
{
foreach (var cover in policy.OptionalCovers)
{
optionalCovers.Rows.Add(cover.CoverCode, cover.CoverDescription,
cover.CoverAmount, 1);
}
}
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@MotorID", policy.MotorID),
new SqlParameter("@InsuredCode", policy.InsuredCode),
new SqlParameter("@DOB", policy.DOB),
new SqlParameter("@YearOfMake", policy.YearOfMake),
new SqlParameter("@VehicleMake", policy.VehicleMake),
new SqlParameter("@VehicleModel", policy.VehicleModel),
new SqlParameter("@vehicleTypeCode", policy.vehicleTypeCode),
new SqlParameter("@vehicleBodyType", policy.vehicleBodyType),
new SqlParameter("@VehicleSumInsured", policy.VehicleValue),
new SqlParameter("@BasePremium", policy.PremiumAmount),
new SqlParameter("@PolicyCommenceDate", policy.PolicyCommencementDate),
new SqlParameter("@PolicyEndDate", policy.PolicyEndDate),
new SqlParameter("@RegistrationNumber", policy.RegistrationNumber ?? ""),
new SqlParameter("@ChassisNo", policy.ChassisNo),
new SqlParameter("@EngineCC", policy.EngineCC),
new SqlParameter("@FinancierCompanyCode", !string.IsNullOrEmpty(policy.FinancierCompanyCode) ? policy.FinancierCompanyCode : ""),
new SqlParameter("@ExcessType", !string.IsNullOrEmpty(policy.ExcessType) ? policy.ExcessType : ""),
new SqlParameter("@dt", optionalCovers),
new SqlParameter("OptionalCoverAmount", policy.OptionalCoverAmount),
new SqlParameter("@IsUnderBCFC", policy.IsUnderBCFC),
new SqlParameter("@SeatingCapacity", policy.SeatingCapacity),
new SqlParameter("@Createdby", policy.CreatedBy),
new SqlParameter("@AuthorizedBy", policy.AuthorizedBy),
new SqlParameter("@IsSaved", policy.IsSaved),
new SqlParameter("@IsActive", policy.IsActivePolicy),
new SqlParameter("@PaymentAuthorization", policy.PaymentAuthorizationCode ?? ""),
new SqlParameter("@TransactionNo", policy.TransactionNo ?? ""),
new SqlParameter("@PaymentType", policy.PaymentType ?? ""),
new SqlParameter("@AccountNumber", policy.AccountNumber ?? ""),
new SqlParameter("@Remarks", policy.Remarks ?? ""),
new SqlParameter("@MainClass", policy.Mainclass ?? ""),
new SqlParameter("@SubClass", policy.Subclass ?? ""),
new SqlParameter("@Agency", policy.Agency),
new SqlParameter("@AgentCode", policy.AgencyCode),
new SqlParameter("@AgentBranch", policy.AgentBranch),
new SqlParameter("ExcessAmount", ExcessAmount),
new SqlParameter("@PremiumBeforeDiscount", PremiumBeforeDiscount),
new SqlParameter("@PremiumAfterDiscount", PremiumAfterDiscount),
new SqlParameter("@CommissionBeforeDiscount", CommissionBeforeDiscount),
new SqlParameter("@CommissionAfterDiscount", CommissionAfterDiscount),
new SqlParameter("@TaxOnPremiumBeforeDiscount", TaxOnPremiumBeforeDiscount),
new SqlParameter("@TaxOnPremiumAfterDiscount", TaxOnPremiumAfterDiscount),
new SqlParameter("@TaxOnCommissionBeforeDiscount", TaxOnCommissionBeforeDiscount),
new SqlParameter("@TaxOnCommissionAfterDiscount", TaxOnCommissionAfterDiscount),
new SqlParameter("@Discount", Discount),
new SqlParameter("@IsHIR", IsHIR),
new SqlParameter("@HIRReason", HIRReason ?? string.Empty),
new SqlParameter("@HIRStatus", HIRStatus),
new SqlParameter("@UserChangedPremium", policy.UserChangedPremium),
new SqlParameter("@AgeLoadingAmount", AgeLoadingAmount),
new SqlParameter("@ExcessDiscountPercent", ExcessDiscountPercent),
new SqlParameter("@ExcessAdditionalAmount", ExcessAdditionalAmount),
new SqlParameter("@ClaimLoadingPercent", ClaimLoadPercent),
new SqlParameter("@ClaimLoadingAmount", ClaimLoadingAmount),
new SqlParameter("@ClaimAmount", policy.ClaimAmount),
new SqlParameter("@OtherLoadingAmount", policy.LoadAmount),
new SqlParameter("@OldDocumentNumber", policy.OldDocumentNumber ?? string.Empty),
new SqlParameter("@RenewalDocumentNumber", policy.DocumentNo ?? string.Empty),
new SqlParameter("@OldRenewalCount", policy.RenewalCount),
new SqlParameter("@RenewalDelayedDays", policy.RenewalDelayedDays),
new SqlParameter("@ActualRenewalStartDate", policy.ActualRenewalStartDate.HasValue ? policy.ActualRenewalStartDate : (object)DBNull.Value)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.BigInt, ParameterName = "@NewMotorID"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@DocumentNumber", Size = 100
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@LinkIDNew", Size = 100
},
new SPOut()
{
OutPutType = SqlDbType.Int, ParameterName = "@RenewalCount"
},
};
object[] dataSet = BKICSQL.GetValues(spName, paras, outParams);
var MotorID = Convert.ToInt64(dataSet[0] != null ? dataSet[0] : 0);
var DocNo = Convert.ToString(dataSet[1]);
var LinkID = Convert.ToString(dataSet[2]);
var RenewalCount = Convert.ToInt32(dataSet[3]);
return(new PolicyRecord
{
IsInserted = true,
DocumentNumber = DocNo,
LinkID = LinkID,
NewMotorID = MotorID,
RenewalCount = RenewalCount
});
}
/// <summary>
/// Get home report based on type(Report by branch or user)
/// </summary>
/// <param name="reportReq">Report request.</param>
/// <returns>Report details.</returns>
public TravelHomeReportResponse GetHomeReport(AdminFetchReportRequest reportReq)
{
try
{
if (reportReq.ReportType == Constants.ReportType.HomeUserReport)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", reportReq.Agency),
new SqlParameter("@AgentCode", reportReq.AgentCode),
new SqlParameter("@AuthorizedUserID", reportReq.AuthorizedUserID),
new SqlParameter("@DateFrom", reportReq.DateFrom),
new SqlParameter("@DateTo", reportReq.DateTo)
};
DataTable dt = BKICSQL.edt(StoredProcedures.ReportSP.GetHomeUserReport, paras);
List <TravelHomeReportDetails> response = new List <TravelHomeReportDetails>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var res = new TravelHomeReportDetails();
res.AuthorizedCode = dr.IsNull("AuthorizedCode") ? string.Empty : Convert.ToString(dr["AuthorizedCode"]);
res.HandledBy = dr.IsNull("HandledBy") ? string.Empty : Convert.ToString(dr["HandledBy"]);
res.PolicyNo = dr.IsNull("Policy No") ? string.Empty : Convert.ToString(dr["Policy No"]);
res.EndorsementNo = dr.IsNull("EndorsementNo") ? string.Empty : Convert.ToString(dr["EndorsementNo"]);
res.SubClass = dr.IsNull("SubClass") ? string.Empty : Convert.ToString(dr["SubClass"]);
res.SumInsured = dr.IsNull("SumInsured") ? decimal.Zero : Convert.ToDecimal(dr["SumInsured"]);
res.NewPremium = dr.IsNull("NewPremium") ? decimal.Zero : Convert.ToDecimal(dr["NewPremium"]);
res.RenewalPremium = dr.IsNull("RenewalPremium") ? decimal.Zero : Convert.ToDecimal(dr["RenewalPremium"]);
res.AdditionalPremium = dr.IsNull("AdditionalPremium") ? decimal.Zero : Convert.ToDecimal(dr["AdditionalPremium"]);
res.RefundPremium = dr.IsNull("RefundPremium") ? decimal.Zero : Convert.ToDecimal(dr["RefundPremium"]);
res.Vat = dr.IsNull("Vat") ? decimal.Zero : Convert.ToDecimal(dr["vat"]);
response.Add(res);
}
}
return(new TravelHomeReportResponse
{
IsTransactionDone = true,
TravelHomeReportDetails = response
});
}
else if (reportReq.ReportType == Constants.ReportType.HomeBranchReport)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", reportReq.Agency),
new SqlParameter("@AgentCode", reportReq.AgentCode),
new SqlParameter("@BranchCode", reportReq.BranchCode),
new SqlParameter("@DateFrom", reportReq.DateFrom),
new SqlParameter("@DateTo", reportReq.DateTo)
};
DataTable dt = BKICSQL.edt(StoredProcedures.ReportSP.GetHomeBranchReport, paras);
List <TravelHomeReportDetails> response = new List <TravelHomeReportDetails>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var res = new TravelHomeReportDetails();
res.BranchCode = dr.IsNull("BranchCode") ? string.Empty : Convert.ToString(dr["BranchCode"]);
res.PolicyNo = dr.IsNull("Policy No") ? string.Empty : Convert.ToString(dr["Policy No"]);
res.EndorsementNo = dr.IsNull("EndorsementNo") ? string.Empty : Convert.ToString(dr["EndorsementNo"]);
res.SubClass = dr.IsNull("SubClass") ? string.Empty : Convert.ToString(dr["SubClass"]);
res.SumInsured = dr.IsNull("SumInsured") ? decimal.Zero : Convert.ToDecimal(dr["SumInsured"]);
res.NewPremium = dr.IsNull("NewPremium") ? decimal.Zero : Convert.ToDecimal(dr["NewPremium"]);
res.RenewalPremium = dr.IsNull("RenewalPremium") ? decimal.Zero : Convert.ToDecimal(dr["RenewalPremium"]);
res.AdditionalPremium = dr.IsNull("AdditionalPremium") ? decimal.Zero : Convert.ToDecimal(dr["AdditionalPremium"]);
res.RefundPremium = dr.IsNull("RefundPremium") ? decimal.Zero : Convert.ToDecimal(dr["RefundPremium"]);
res.Vat = dr.IsNull("Vat") ? decimal.Zero : Convert.ToDecimal(dr["vat"]);
response.Add(res);
}
}
return(new TravelHomeReportResponse
{
IsTransactionDone = true,
TravelHomeReportDetails = response
});
}
}
catch (Exception ex)
{
return(new TravelHomeReportResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message,
});
}
return(null);
}
/// <summary>
/// Get main report based on insurance type(Motor or Travel or Home)
/// </summary>
/// <param name="reportReq">Report request.</param>
/// <returns>Report details.</returns>
public MainReportResponse GetMainReport(AdminFetchReportRequest reportReq)
{
try
{
if (reportReq.InsuranceType == Constants.Insurance.Motor)
{
if (reportReq.ReportType == Constants.ReportType.MotorMainReport)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", reportReq.Agency),
new SqlParameter("@AgentCode", reportReq.AgentCode),
new SqlParameter("@DateFrom", reportReq.DateFrom),
new SqlParameter("@DateTo", reportReq.DateTo)
};
DataTable dt = BKICSQL.edt(StoredProcedures.ReportSP.GetMotorMainReport, paras);
List <MainReportDetails> response = new List <MainReportDetails>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var res = new MainReportDetails();
res.BranchCode = dr.IsNull("BranchCode") ? string.Empty : Convert.ToString(dr["BranchCode"]);
res.BranchName = dr.IsNull("BranchName") ? string.Empty : Convert.ToString(dr["BranchName"]);
res.InsuredName = dr.IsNull("InsuredName") ? string.Empty : Convert.ToString(dr["InsuredName"]);
res.AuthorizedUser = dr.IsNull("AuthorizedBy") ? string.Empty : Convert.ToString(dr["AuthorizedBy"]);
res.AuthorizedDate = dr.IsNull("AuthorizedDate") ? string.Empty : Convert.ToDateTime(dr["AuthorizedDate"]).Date.CovertToLocalFormat();
res.HandledBy = dr.IsNull("HandledBy") ? string.Empty : Convert.ToString(dr["HandledBy"]);
res.CommenceDate = dr.IsNull("CommenceDate") ? string.Empty : Convert.ToDateTime(dr["CommenceDate"]).Date.CovertToLocalFormat();
res.ExpiryDate = dr.IsNull("ExpiryDate") ? string.Empty : Convert.ToDateTime(dr["ExpiryDate"]).Date.CovertToLocalFormat();
res.PaymentMethod = dr.IsNull("PaymentMethod") ? string.Empty : Convert.ToString(dr["PaymentMethod"]);
res.PolicyNo = dr.IsNull("PolicyNo") ? string.Empty : Convert.ToString(dr["PolicyNo"]);
res.EndorsementNo = dr.IsNull("EndorsementNo") ? string.Empty : Convert.ToString(dr["EndorsementNo"]);
res.SubClass = dr.IsNull("SubClass") ? string.Empty : Convert.ToString(dr["SubClass"]);
res.Commission = dr.IsNull("Commission") ? decimal.Zero : Convert.ToDecimal(dr["Commission"]);
res.RefundCommision = dr.IsNull("RefundCommission") ? decimal.Zero : Convert.ToDecimal(dr["RefundCommission"]);
res.Discount = dr.IsNull("Discount") ? decimal.Zero : Convert.ToDecimal(dr["Discount"]);
res.PremiumLessCredit = dr.IsNull("PremiumLessCredit") ? decimal.Zero : Convert.ToDecimal(dr["PremiumLessCredit"]);
res.PremiumReference = dr.IsNull("PremiumReference") ? string.Empty : Convert.ToString(dr["PremiumReference"]);
res.CommisionReference = dr.IsNull("CommissionReference") ? string.Empty : Convert.ToString(dr["CommissionReference"]);
res.BatchDate = dr.IsNull("BatchDate") ? string.Empty : Convert.ToString(dr["BatchDate"]);
res.CPR = dr.IsNull("CPR") ? string.Empty : Convert.ToString(dr["CPR"]);
res.NewPremium = dr.IsNull("NewPremium") ? decimal.Zero : Convert.ToDecimal(dr["NewPremium"]);
res.RenewalPremium = dr.IsNull("RenewalPremium") ? decimal.Zero : Convert.ToDecimal(dr["RenewalPremium"]);
res.AdditionalPremium = dr.IsNull("AdditionalPremium") ? decimal.Zero : Convert.ToDecimal(dr["AdditionalPremium"]);
res.RefundPremium = dr.IsNull("RefundPremium") ? decimal.Zero : Convert.ToDecimal(dr["RefundPremium"]);
res.Vat = dr.IsNull("Vat") ? decimal.Zero : Convert.ToDecimal(dr["vat"]);
response.Add(res);
}
}
return(new MainReportResponse
{
IsTransactionDone = true,
MainReportDetails = response,
});
}
}
else if (reportReq.InsuranceType == Constants.Insurance.Travel &&
reportReq.ReportType == Constants.ReportType.TravelMainReport)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", reportReq.Agency),
new SqlParameter("@AgentCode", reportReq.AgentCode),
new SqlParameter("@DateFrom", reportReq.DateFrom),
new SqlParameter("@DateTo", reportReq.DateTo)
};
DataTable dt = BKICSQL.edt(StoredProcedures.ReportSP.GetTravelMainReport, paras);
List <MainReportDetails> response = new List <MainReportDetails>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var res = new MainReportDetails();
res.BranchCode = dr.IsNull("BranchCode") ? string.Empty : Convert.ToString(dr["BranchCode"]);
res.BranchName = dr.IsNull("BranchName") ? string.Empty : Convert.ToString(dr["BranchName"]);
res.InsuredName = dr.IsNull("InsuredName") ? string.Empty : Convert.ToString(dr["InsuredName"]);
res.PolicyNo = dr.IsNull("POLICYNO") ? string.Empty : Convert.ToString(dr["POLICYNO"]);
res.EndorsementNo = dr.IsNull("ENDORSEMENTNO") ? string.Empty : Convert.ToString(dr["ENDORSEMENTNO"]);
res.SubClass = dr.IsNull("SUBCLASS") ? string.Empty : Convert.ToString(dr["SUBCLASS"]);
res.AuthorizedUser = dr.IsNull("AuthorizedBy") ? string.Empty : Convert.ToString(dr["AuthorizedBy"]);
res.AuthorizedDate = dr.IsNull("AuthorizedDate") ? string.Empty : Convert.ToDateTime(dr["AuthorizedDate"]).Date.CovertToLocalFormat();
res.HandledBy = dr.IsNull("HandledBy") ? string.Empty : Convert.ToString(dr["HandledBy"]);
res.CommenceDate = dr.IsNull("CommenceDate") ? string.Empty : Convert.ToDateTime(dr["CommenceDate"]).Date.CovertToLocalFormat();
res.ExpiryDate = dr.IsNull("ExpiryDate") ? string.Empty : Convert.ToDateTime(dr["ExpiryDate"]).Date.CovertToLocalFormat();
res.PaymentMethod = dr.IsNull("PaymentMethod") ? string.Empty : Convert.ToString(dr["PaymentMethod"]);
res.Commission = dr.IsNull("Commission") ? decimal.Zero : Convert.ToDecimal(dr["Commission"]);
res.Discount = dr.IsNull("Discount") ? decimal.Zero : Convert.ToDecimal(dr["Discount"]);
res.PremiumLessCredit = dr.IsNull("PremiumLessCredit") ? decimal.Zero : Convert.ToDecimal(dr["PremiumLessCredit"]);
res.PremiumReference = dr.IsNull("PremiumReference") ? string.Empty : Convert.ToString(dr["PremiumReference"]);
res.CommisionReference = dr.IsNull("CommissionReference") ? string.Empty : Convert.ToString(dr["CommissionReference"]);
res.BatchDate = dr.IsNull("BatchDate") ? string.Empty : Convert.ToString(dr["BatchDate"]);
res.CPR = dr.IsNull("CPR") ? string.Empty : Convert.ToString(dr["CPR"]);
res.NewPremium = dr.IsNull("NewPremium") ? decimal.Zero : Convert.ToDecimal(dr["NewPremium"]);
res.RenewalPremium = dr.IsNull("RenewalPremium") ? decimal.Zero : Convert.ToDecimal(dr["RenewalPremium"]);
res.AdditionalPremium = dr.IsNull("AdditionalPremium") ? decimal.Zero : Convert.ToDecimal(dr["AdditionalPremium"]);
res.RefundPremium = dr.IsNull("RefundPremium") ? decimal.Zero : Convert.ToDecimal(dr["RefundPremium"]);
response.Add(res);
}
}
return(new MainReportResponse
{
IsTransactionDone = true,
MainReportDetails = response,
});
}
else if (reportReq.InsuranceType == Constants.Insurance.Home &&
reportReq.ReportType == Constants.ReportType.HomeMainReport)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", reportReq.Agency),
new SqlParameter("@AgentCode", reportReq.AgentCode),
new SqlParameter("@DateFrom", reportReq.DateFrom),
new SqlParameter("@DateTo", reportReq.DateTo)
};
DataTable dt = BKICSQL.edt(StoredProcedures.ReportSP.GetHomeMainReport, paras);
List <MainReportDetails> response = new List <MainReportDetails>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var res = new MainReportDetails();
res.BranchCode = dr.IsNull("BranchCode") ? string.Empty : Convert.ToString(dr["BranchCode"]);
res.BranchName = dr.IsNull("BranchName") ? string.Empty : Convert.ToString(dr["BranchName"]);
res.InsuredName = dr.IsNull("InsuredName") ? string.Empty : Convert.ToString(dr["InsuredName"]);
res.PolicyNo = dr.IsNull("POLICYNO") ? string.Empty : Convert.ToString(dr["POLICYNO"]);
res.EndorsementNo = dr.IsNull("ENDORSEMENTNO") ? string.Empty : Convert.ToString(dr["ENDORSEMENTNO"]);
res.SubClass = dr.IsNull("SUBCLASS") ? string.Empty : Convert.ToString(dr["SUBCLASS"]);
res.AuthorizedUser = dr.IsNull("AuthorizedBy") ? string.Empty : Convert.ToString(dr["AuthorizedBy"]);
res.AuthorizedDate = dr.IsNull("AuthorizedDate") ? string.Empty : Convert.ToDateTime(dr["AuthorizedDate"]).Date.CovertToLocalFormat();
res.HandledBy = dr.IsNull("HandledBy") ? string.Empty : Convert.ToString(dr["HandledBy"]);
res.CommenceDate = dr.IsNull("CommenceDate") ? string.Empty : Convert.ToDateTime(dr["CommenceDate"]).Date.CovertToLocalFormat();
res.ExpiryDate = dr.IsNull("ExpiryDate") ? string.Empty : Convert.ToDateTime(dr["ExpiryDate"]).Date.CovertToLocalFormat();
res.PaymentMethod = dr.IsNull("PaymentMethod") ? string.Empty : Convert.ToString(dr["PaymentMethod"]);
res.Commission = dr.IsNull("Commission") ? decimal.Zero : Convert.ToDecimal(dr["Commission"]);
res.RefundCommision = dr.IsNull("RefundCommission") ? decimal.Zero : Convert.ToDecimal(dr["RefundCommission"]);
res.Discount = dr.IsNull("Discount") ? decimal.Zero : Convert.ToDecimal(dr["Discount"]);
res.PremiumLessCredit = dr.IsNull("PremiumLessCredit") ? decimal.Zero : Convert.ToDecimal(dr["PremiumLessCredit"]);
res.PremiumReference = dr.IsNull("PremiumReference") ? string.Empty : Convert.ToString(dr["PremiumReference"]);
res.CommisionReference = dr.IsNull("CommissionReference") ? string.Empty : Convert.ToString(dr["CommissionReference"]);
res.BatchDate = dr.IsNull("BatchDate") ? string.Empty : Convert.ToString(dr["BatchDate"]);
res.CPR = dr.IsNull("CPR") ? string.Empty : Convert.ToString(dr["CPR"]);
res.NewPremium = dr.IsNull("NewPremium") ? decimal.Zero : Convert.ToDecimal(dr["NewPremium"]);
res.RenewalPremium = dr.IsNull("RenewalPremium") ? decimal.Zero : Convert.ToDecimal(dr["RenewalPremium"]);
res.AdditionalPremium = dr.IsNull("AdditionalPremium") ? decimal.Zero : Convert.ToDecimal(dr["AdditionalPremium"]);
res.RefundPremium = dr.IsNull("RefundPremium") ? decimal.Zero : Convert.ToDecimal(dr["RefundPremium"]);
res.Vat = dr.IsNull("Vat") ? decimal.Zero : Convert.ToDecimal(dr["Vat"]);
response.Add(res);
}
}
return(new MainReportResponse
{
IsTransactionDone = true,
MainReportDetails = response,
});
}
return(null);
}
catch (Exception ex)
{
return(new MainReportResponse
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message,
});
}
}
/// <summary>
/// Calculate endorsement premium by endorsement type.
/// </summary>
/// <param name="homeEndorsement">Endorement quote request.</param>
/// <returns>Returns endorsement premium and commision.</returns>
public MotorEndorsementQuoteResult GetMotorEndorsementQuote(MotorEndorsementQuote motorEndorsement)
{
if (motorEndorsement.EndorsementType == MotorEndorsementTypes.ChangeSumInsured)
{
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", motorEndorsement.Agency),
new SqlParameter("@AgentCode", motorEndorsement.AgentCode),
new SqlParameter("@MainClass", motorEndorsement.MainClass),
new SqlParameter("@SubClass", motorEndorsement.SubClass),
new SqlParameter("@InsuredCode", motorEndorsement.InsuredCode),
new SqlParameter("@EffectiveFromDate", motorEndorsement.EffectiveFromDate),
new SqlParameter("@EffectiveToDate", motorEndorsement.EffectiveToDate),
//new SqlParameter("@PaidPremium",motorEndorsement.PaidPremium),
new SqlParameter("@NewSumInsured", motorEndorsement.NewSumInsured),
new SqlParameter("@EndorsementType", motorEndorsement.EndorsementType),
new SqlParameter("@DocumentNo", motorEndorsement.DocumentNo)
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@EndorsementPremium", Precision = 38, Scale = 3
},
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@RefundPremium", Precision = 38, Scale = 3
},
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@RefundVat", Precision = 38, Scale = 3
},
};
object[] dataSet = BKICSQL.GetValues(MotorEndorsementSP.GetAdminQuote, paras, outParams);
var endorsementPremium = string.IsNullOrEmpty(dataSet[0].ToString()) ? 0 : decimal.Parse(dataSet[0].ToString(), CultureInfo.InvariantCulture.NumberFormat);
var refundPremium = string.IsNullOrEmpty(dataSet[1].ToString()) ? 0 : decimal.Parse(dataSet[1].ToString(), CultureInfo.InvariantCulture.NumberFormat);
var refundVat = string.IsNullOrEmpty(dataSet[2].ToString()) ? 0 : decimal.Parse(dataSet[2].ToString(), CultureInfo.InvariantCulture.NumberFormat);
return(new MotorEndorsementQuoteResult()
{
IsTransactionDone = true,
EndorsementPremium = endorsementPremium,
RefundPremium = refundPremium,
RefundVat = refundVat
});
}
catch (Exception ex)
{
return(new MotorEndorsementQuoteResult()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
else
{
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@Agency", motorEndorsement.Agency),
new SqlParameter("@AgentCode", motorEndorsement.AgentCode),
new SqlParameter("DocumentNo", motorEndorsement.DocumentNo),
new SqlParameter("@MainClass", motorEndorsement.MainClass),
new SqlParameter("@SubClass", motorEndorsement.SubClass),
new SqlParameter("@OldInsuredCode", motorEndorsement.InsuredCode ?? string.Empty),
new SqlParameter("@NewInsuredCode", motorEndorsement.NewInsuredCode),
new SqlParameter("@EffectiveFromDate", motorEndorsement.EffectiveFromDate),
new SqlParameter("@EffectiveToDate", motorEndorsement.EffectiveToDate),
new SqlParameter("@CancelationDate", motorEndorsement.CancelationDate),
new SqlParameter("@ExtendedDays", motorEndorsement.ExtendedDays),
new SqlParameter("@PaidPremium", motorEndorsement.PaidPremium),
new SqlParameter("@SumInsured", motorEndorsement.OldSumInsured),
new SqlParameter("@EndorsementType", motorEndorsement.EndorsementType ?? ""),
new SqlParameter("@RefundType", motorEndorsement.RefundType ?? ""),
};
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@EndorsementPremium", Precision = 38, Scale = 3
},
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@Commission", Precision = 38, Scale = 3
},
new SPOut()
{
OutPutType = SqlDbType.Decimal, ParameterName = "@RefundVat", Precision = 38, Scale = 3
},
};
object[] dataSet = BKICSQL.GetValues(MotorEndorsementSP.GetQuote, paras, outParams);
var endorsementPremium = string.IsNullOrEmpty(dataSet[0].ToString()) ? 0 : decimal.Parse(dataSet[0].ToString(), CultureInfo.InvariantCulture.NumberFormat);
var commission = string.IsNullOrEmpty(dataSet[1].ToString()) ? 0 : decimal.Parse(dataSet[1].ToString(), CultureInfo.InvariantCulture.NumberFormat);
var refundVat = string.IsNullOrEmpty(dataSet[2].ToString()) ? 0 : decimal.Parse(dataSet[2].ToString(), CultureInfo.InvariantCulture.NumberFormat);
return(new MotorEndorsementQuoteResult()
{
IsTransactionDone = true,
EndorsementPremium = endorsementPremium,
Commision = commission,
RefundVat = refundVat
});
}
catch (Exception ex)
{
return(new MotorEndorsementQuoteResult()
{
IsTransactionDone = false,
TransactionErrorMessage = ex.Message
});
}
}
}
