public int InsertPolicySurrender(PolicySurrender thePolicySurrender)
{
int ReturnValue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
InsertCommand.Parameters.Add(GetParameter("@CustomerAccountID", SqlDbType.Int, thePolicySurrender.CustomerAccountID));
InsertCommand.Parameters.Add(GetParameter("@SurrenderDate", SqlDbType.VarChar, thePolicySurrender.SurrenderDate));
//InsertCommand.Parameters.Add(GetParameter("@SurrenderFormNumber", SqlDbType.VarChar, thePolicySurrender.SurrenderFormNumber));
InsertCommand.Parameters.Add(GetParameter("@SurrenderPrincipalPayable ", SqlDbType.Decimal, thePolicySurrender.SurrenderPrincipalPayable));
InsertCommand.Parameters.Add(GetParameter("@SurrenderPrincipalPaid", SqlDbType.Decimal, thePolicySurrender.SurrenderPrincipalPaid));
InsertCommand.Parameters.Add(GetParameter("@SurrenderInterestPayable", SqlDbType.Decimal, thePolicySurrender.SurrenderInterestPayable));
InsertCommand.Parameters.Add(GetParameter("@SurrenderInterestPaid", SqlDbType.Decimal, thePolicySurrender.SurrenderInterestPaid));
InsertCommand.Parameters.Add(GetParameter("@SurrenderBonusPayable", SqlDbType.Decimal, thePolicySurrender.SurrenderBonusPayable));
InsertCommand.Parameters.Add(GetParameter("@SurrenderBonusPaid", SqlDbType.Decimal, thePolicySurrender.SurrenderBonusPaid));
InsertCommand.Parameters.Add(GetParameter("@SurrenderPrincipalDeductions", SqlDbType.Decimal, thePolicySurrender.SurrenderPrincipalDeductions));
InsertCommand.Parameters.Add(GetParameter("@SurrenderPrincipalDeductionsRemarks", SqlDbType.VarChar, thePolicySurrender.SurrenderPrincipalDeductionsRemarks));
InsertCommand.Parameters.Add(GetParameter("@SurrenderTotalPayable", SqlDbType.Decimal, thePolicySurrender.SurrenderTotalPayable));
InsertCommand.Parameters.Add(GetParameter("@SurrenderTotalPaid ", SqlDbType.Decimal, thePolicySurrender.SurrenderTotalPaid));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_Surrenders_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static PolicySurrender GetSurrenderChargesbyCustomerAccountID(int customerAccountID)
{
DataRow ThePolicySurrenderRow = PolicySurrenderDataAccess.GetInstance.GetSurrenderChargesbyCustomerAccountID(customerAccountID);
PolicySurrender ThePolicySurrender = new PolicySurrender();
ThePolicySurrender.SurrenderInterestPaid = decimal.Parse(ThePolicySurrenderRow["SurrenderInterestPaid"].ToString());
ThePolicySurrender.SurrenderPrincipalDeductions = decimal.Parse(ThePolicySurrenderRow["SurrenderPrincipalDeductions"].ToString());
return(ThePolicySurrender);
}
public static List <PolicySurrender> GetPolicySurrenderList(bool allOffices = false, bool showDeleted = false)
{
List <PolicySurrender> PolicySurrenderList = new List <PolicySurrender>();
DataTable SurrenderTable = PolicySurrenderDataAccess.GetInstance.GetPolicySurrenderList(allOffices, showDeleted);
foreach (DataRow dr in SurrenderTable.Rows)
{
PolicySurrender ThePolicySurrender = DataRowToObject(dr);
PolicySurrenderList.Add(ThePolicySurrender);
}
return(PolicySurrenderList);
}
public static PolicySurrender DataRowToObject(DataRow dr)
{
PolicySurrender ThePolicySurrender = new PolicySurrender();
ThePolicySurrender.SurrenderID = int.Parse(dr["SurrenderID"].ToString());
ThePolicySurrender.CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString());
ThePolicySurrender.CustomerAccountCode = dr["CustomerAccountCode"].ToString();
ThePolicySurrender.CustomerName = dr["CustomerName"].ToString();
ThePolicySurrender.SurrenderFormNumber = dr["SurrenderFormNumber"].ToString();
ThePolicySurrender.SurrenderDate = DateTime.Parse(dr["SurrenderDate"].ToString()).ToString(MicroConstants.DateFormat);
ThePolicySurrender.SurrenderPrincipalPayable = decimal.Parse(dr["SurrenderPrincipalPayable"].ToString());
ThePolicySurrender.SurrenderPrincipalPaid = decimal.Parse(dr["SurrenderPrincipalPaid"].ToString());
ThePolicySurrender.SurrenderInterestPayable = decimal.Parse(dr["SurrenderInterestPayable"].ToString());
ThePolicySurrender.SurrenderInterestPaid = decimal.Parse(dr["SurrenderInterestPaid"].ToString());
ThePolicySurrender.SurrenderBonusPayable = decimal.Parse(dr["SurrenderBonusPayable"].ToString());
ThePolicySurrender.SurrenderBonusPaid = decimal.Parse(dr["SurrenderBonusPaid"].ToString());
ThePolicySurrender.SurrenderPrincipalDeductions = decimal.Parse(dr["SurrenderPrincipalDeductions"].ToString());
ThePolicySurrender.SurrenderPrincipalDeductionsRemarks = dr["SurrenderPrincipalDeductionsRemarks"].ToString();
ThePolicySurrender.SurrenderTotalPayable = decimal.Parse(dr["SurrenderTotalPayable"].ToString());
ThePolicySurrender.SurrenderTotalPaid = decimal.Parse(dr["SurrenderTotalPaid"].ToString());
return(ThePolicySurrender);
}
public int InsertPolicySurrender(PolicySurrender thePolicySurrender)
{
return(PolicySurrenderIntegration.InsertPolicySurrender(thePolicySurrender));
}
public static int InsertPolicySurrender(PolicySurrender thePolicySurrender)
{
return(PolicySurrenderDataAccess.GetInstance.InsertPolicySurrender(thePolicySurrender));
}
