public int UpdatePremium(CRMPremium theCrmPremium)
{
int ReturnValue = 0;
SqlCommand UpdateCommand = new SqlCommand();
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("PremiumTableID", SqlDbType.Int, theCrmPremium.PremiumTableID));
UpdateCommand.Parameters.Add(GetParameter("PremiumTableReferenceName", SqlDbType.VarChar, theCrmPremium.PremiumTableReferenceName));
UpdateCommand.Parameters.Add(GetParameter("PremiumTableDescriptiveName", SqlDbType.VarChar, theCrmPremium.PremiumTableDescriptiveName));
UpdateCommand.Parameters.Add(GetParameter("TenureInYears", SqlDbType.Decimal, theCrmPremium.TenureInYears));
UpdateCommand.Parameters.Add(GetParameter("EffectiveDateFrom", SqlDbType.VarChar, theCrmPremium.EffectiveDateFrom));
UpdateCommand.Parameters.Add(GetParameter("PolicyID", SqlDbType.Int, theCrmPremium.PolicyID));
UpdateCommand.Parameters.Add(GetParameter("@OfficeId", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.CommandText = "pCRM_PremiumTables_Update";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
public int DeletePremium(CRMPremium theCrmPremium)
{
int ReturnValue = 0;
SqlCommand DeleteCommand = new SqlCommand();
DeleteCommand.CommandType = CommandType.StoredProcedure;
DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
DeleteCommand.Parameters.Add(GetParameter("@PremiumTableID", SqlDbType.Int, theCrmPremium.PremiumTableID));
DeleteCommand.CommandText = "pCRM_PremiumTables_Delete";
ExecuteStoredProcedure(DeleteCommand);
ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
public static CRMPremium GetPremiumById(int recordId)
{
DataRow CRMPolicyRow = CrmPremiumDataAccess.GetInstance.GetPremiumById(recordId);
CRMPremium TheCRMPremium = new CRMPremium
{
PremiumTableID = int.Parse(CRMPolicyRow["PremiumTableID"].ToString()),
PolicyID = int.Parse(CRMPolicyRow["PolicyID"].ToString()),
PremiumTableReferenceName = CRMPolicyRow["PremiumTableReferenceName"].ToString(),
PremiumTableDescriptiveName = CRMPolicyRow["PremiumTableDescriptiveName"].ToString(),
TenureInYears = double.Parse(CRMPolicyRow["TenureInYears"].ToString())
};
//TheCRMPremium.EffectiveDateFrom = CRMPolicyRow["EffectiveDateFrom"].ToString();
return(TheCRMPremium);
}
public static List <CRMPremium> GetPremium()
{
List <CRMPremium> CRMPremiumList = new List <CRMPremium>();
DataTable GetPremiumTable = CrmPremiumDataAccess.GetInstance.GetPremium();
foreach (DataRow dr in GetPremiumTable.Rows)
{
CRMPremium ThePremium = new CRMPremium
{
PremiumTableID = int.Parse(dr["PremiumTableID"].ToString()),
PolicyID = int.Parse(dr["PolicyID"].ToString()), /*ThePremium.PolicyName = dr["PolicyName"].ToString();*/
PremiumTableReferenceName = dr["PremiumTableReferenceName"].ToString(),
PremiumTableDescriptiveName = dr["PremiumTableDescriptiveName"].ToString(),
TenureInYears = double.Parse(dr["TenureInYears"].ToString()),
EffectiveDateFrom = dr["EffectiveDateFrom"].ToString()
};
CRMPremiumList.Add(ThePremium);
}
return(CRMPremiumList);
}
public static int DeletePremium(CRMPremium theCrmPremium)
{
return(CrmPremiumDataAccess.GetInstance.DeletePremium(theCrmPremium));
}
public static int InsertPremium(CRMPremium theCrmPremium)
{
return(CrmPremiumDataAccess.GetInstance.InsertPremium(theCrmPremium));
}
public int DeletePremium(CRMPremium theCrmPremium)
{
return(CrmPremiumIntegration.DeletePremium(theCrmPremium));
}
public int UpdatePremium(CRMPremium theCrmPremium)
{
return(CrmPremiumIntegration.UpdatePremium(theCrmPremium));
}
public int InsertPremium(CRMPremium theCrmPremium)
{
return(CrmPremiumIntegration.InsertPremium(theCrmPremium));
}