public static CRMPolicy PolicyTypeDataRowToObject(DataRow dr) { CRMPolicy TheCRMPolicyType = new CRMPolicy { PolicyID = int.Parse(dr["PolicyID"].ToString()), PolicyName = dr["PolicyName"].ToString(), PolicyFromOrganization = dr["PolicyFromOrganization"].ToString(), TenureInYears = dr["TenureInYears"].ToString(), TenureInMonths = int.Parse(dr["TenureInMonths"].ToString()), AllowDeathCompensation = bool.Parse(dr["AllowDeathCompensation"].ToString()), AllowMediclaim = bool.Parse(dr["AllowMediclaim"].ToString()), AllowPolicySurrender = bool.Parse(dr["AllowPolicySurrender"].ToString()), AllowPreMaturity = bool.Parse(dr["AllowPreMaturity"].ToString()), AllowRevival = bool.Parse(dr["AllowRevival"].ToString()), DatabaseTableName = dr["DatabaseTableName"].ToString(), StoredProcedureName = dr["StoredProcedureName"].ToString(), EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat), OfficeID = int.Parse(dr["OfficeID"].ToString()), OfficeName = dr["OfficeName"].ToString(), PolicyTypeID = int.Parse(dr["PolicyTypeID"].ToString()), PolicyTypeDescription = dr["PolicyTypeDescription"].ToString(), PolicySubType = dr["PolicySubType"].ToString() }; return(TheCRMPolicyType); }
public int UpdateCRMPolicy(CRMPolicy theCRMPolicy) { int ReturnValue = 0; using (SqlCommand UpdateCommand = new SqlCommand()) { UpdateCommand.CommandType = CommandType.StoredProcedure; UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; UpdateCommand.Parameters.Add(GetParameter("@PolicyID", SqlDbType.Int, theCRMPolicy.PolicyID)); UpdateCommand.Parameters.Add(GetParameter("@PolicyName", SqlDbType.VarChar, theCRMPolicy.PolicyName)); UpdateCommand.Parameters.Add(GetParameter("@PolicyFromOrganization", SqlDbType.VarChar, theCRMPolicy.PolicyFromOrganization)); UpdateCommand.Parameters.Add(GetParameter("@TenureInYears", SqlDbType.Decimal, theCRMPolicy.TenureInYears)); UpdateCommand.Parameters.Add(GetParameter("@TenureInMonths", SqlDbType.Int, theCRMPolicy.TenureInMonths)); UpdateCommand.Parameters.Add(GetParameter("@AllowDeathCompensation", SqlDbType.Bit, theCRMPolicy.AllowDeathCompensation)); UpdateCommand.Parameters.Add(GetParameter("@AllowMediclaim", SqlDbType.Bit, theCRMPolicy.AllowMediclaim)); UpdateCommand.Parameters.Add(GetParameter("@AllowPolicySurrender", SqlDbType.Bit, theCRMPolicy.AllowPolicySurrender)); UpdateCommand.Parameters.Add(GetParameter("@AllowPreMaturity", SqlDbType.Bit, theCRMPolicy.AllowPreMaturity)); UpdateCommand.Parameters.Add(GetParameter("@AllowRevival", SqlDbType.Bit, theCRMPolicy.AllowRevival)); UpdateCommand.Parameters.Add(GetParameter("@DatabaseTableName", SqlDbType.VarChar, theCRMPolicy.DatabaseTableName)); UpdateCommand.Parameters.Add(GetParameter("@StoredProcedureName", SqlDbType.VarChar, theCRMPolicy.StoredProcedureName)); UpdateCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, theCRMPolicy.EffectiveDateFrom)); UpdateCommand.Parameters.Add(GetParameter("@OfficeId", SqlDbType.Int, theCRMPolicy.OfficeID)); UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); UpdateCommand.CommandText = "pCRM_Policies_Update"; ExecuteStoredProcedure(UpdateCommand); ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public static List <CRMPolicy> GetCRMPolicyTypeList() { List <CRMPolicy> CRMPolicyList = new List <CRMPolicy>(); DataTable CRMPolicyTypeTable = CRMPolicyDataAccess.GetInstance.GetCRMPolicyTypeList(); foreach (DataRow dr in CRMPolicyTypeTable.Rows) { CRMPolicy TheCRMPolicy = PolicyTypeDataRowToObject(dr); CRMPolicyList.Add(TheCRMPolicy); } return(CRMPolicyList); }
public static List <CRMPolicy> GetCRMPolicyTypeOfficewiseList(bool allOffices = false, bool showDeleted = false) { List <CRMPolicy> CRMPolicyList = new List <CRMPolicy>(); DataTable CRMPolicyTableType = CRMPolicyDataAccess.GetInstance.GetCRMPolicyTypeOfficewiseList(allOffices, showDeleted); foreach (DataRow dr in CRMPolicyTableType.Rows) { CRMPolicy TheCRMPolicy = PolicyTypeDataRowToObject(dr); CRMPolicyList.Add(TheCRMPolicy); } return(CRMPolicyList); }
public static List <CRMPolicy> GetCRMPolicyTypeListByOfficeID(bool showInOfficewise = false) { List <CRMPolicy> CRMPolicyList = new List <CRMPolicy>(); DataTable CRMPolicyTableType = CRMPolicyDataAccess.GetInstance.GetCRMPolicyTypeListByOfficeID(showInOfficewise); foreach (DataRow dr in CRMPolicyTableType.Rows) { CRMPolicy TheCRMPolicy = PolicyTypeDataRowToObject(dr); CRMPolicyList.Add(TheCRMPolicy); } return(CRMPolicyList); }
public static CRMPolicy GetCRMPolicyTypeByID(int policyTypeID) { CRMPolicy TheCRMPolicyType; DataRow CRMPolicyTypeRow = CRMPolicyDataAccess.GetInstance.GetCRMPolicyTypeByID(policyTypeID); if (CRMPolicyTypeRow != null) { TheCRMPolicyType = PolicyTypeDataRowToObject(CRMPolicyTypeRow); } else { TheCRMPolicyType = new CRMPolicy(); } return(TheCRMPolicyType); }
public int DeleteCRMPolicy(CRMPolicy theCRMPolicy) { int ReturnValue = 0; using (SqlCommand DeleteCommand = new SqlCommand()) { DeleteCommand.CommandType = CommandType.StoredProcedure; DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; DeleteCommand.Parameters.Add(GetParameter("@PolicyID", SqlDbType.Int, theCRMPolicy.PolicyID)); DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); DeleteCommand.CommandText = "pCRM_Policies_Delete"; ExecuteStoredProcedure(DeleteCommand); ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public static List <CRMPolicy> GetPolicy() { List <CRMPolicy> CRMPolicyList = new List <CRMPolicy>(); DataTable GetPolicyTable = CrmPremiumDataAccess.GetInstance.GetPolicy(); foreach (DataRow dr in GetPolicyTable.Rows) { CRMPolicy ThePolicy = new CRMPolicy { PolicyID = int.Parse(dr["PolicyID"].ToString()), PolicyName = dr["PolicyName"].ToString(), PremiumTableReferenceName = dr["PremiumTableReferenceName"].ToString(), PremiumTableDescriptiveName = dr["PremiumTableDescriptiveName"].ToString(), TenureInYears = dr["TenureInYears"].ToString(), EffectiveDateFrom = dr["EffectiveDateFrom"].ToString() }; CRMPolicyList.Add(ThePolicy); } return(CRMPolicyList); }
public static int DeleteCRMPolicy(CRMPolicy theCRMPolicy) { return(CRMPolicyDataAccess.GetInstance.DeleteCRMPolicy(theCRMPolicy)); }
public static int InsertCRMPolicy(CRMPolicy theCRMPolicy) { return(CRMPolicyDataAccess.GetInstance.InsertCRMPolicy(theCRMPolicy)); }
public int DeleteCRMPolicy(CRMPolicy theCRMPolicy) { return(CRMPolicyIntegration.DeleteCRMPolicy(theCRMPolicy)); }
public int UpdateCRMPolicy(CRMPolicy theCRMPolicy) { return(CRMPolicyIntegration.UpdateCRMPolicy(theCRMPolicy)); }
public int InsertCRMPolicy(CRMPolicy theCRMPolicy) { return(CRMPolicyIntegration.InsertCRMPolicy(theCRMPolicy)); }