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