//end
//for bind age based on program//
public DataSet getAgeusingProgram(clsIHPremiumRating objclsIHPremium)
{
object[] parameters = new object[1] {
objclsIHPremium.Program
};
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_IHPremium_Get_AgebyProgram", "IHAgebyProgram"));
}
//end
public DataSet Check_Slip(clsIHPremiumRating objclsIHPremium)
{
object[] parameters = new object[] { objclsIHPremium.Age, objclsIHPremium.Program, objclsIHPremium.Area,
objclsIHPremium.premiumrating, objclsIHPremium.Discount, objclsIHPremium.Dedcutible };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_IH_PremiumRating_Slip", "P_IH_PremiumRating_Slip"));
// return dataAccessDS.ExecuteNonQuery("P_TM_IHPremiumRating_Update", parameters);
}
//end
//Function for Search the Record
public DataSet Search_IHPremiumData(clsIHPremiumRating objclsIHPremium)
{
object[] parameters = new object[] { objclsIHPremium.IH_ID, objclsIHPremium.Program, objclsIHPremium.Area, objclsIHPremium.Dedcutible,
objclsIHPremium.Age, objclsIHPremium.EffFromDate, objclsIHPremium.EffToDate, objclsIHPremium.Discount, objclsIHPremium.UniqueNo, objclsIHPremium.UnderWriterName, objclsIHPremium.ProductName };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_TM_IHPremiumRating_Search", "TM_IH_TempPremiumRating_Search"));
}
//Function for TRACK aGE gAP
public DataSet Check_AgeGap(clsIHPremiumRating objclsIHPremium)
{
object[] parameters = new object[1] {
objclsIHPremium.Program
};
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_IHPremium_Age_Gap", "Check_AgeGap"));
}
//end
//Function for Update the Record
public DataSet Update_IHPremiumData(clsIHPremiumRating objclsIHPremium)
{
object[] parameters = new object[] { objclsIHPremium.IH_ID, objclsIHPremium.Program, objclsIHPremium.Area,
objclsIHPremium.Dedcutible, objclsIHPremium.premiumrating, objclsIHPremium.EffToDate, objclsIHPremium.EffFromDate,
objclsIHPremium.lastupdatedby, objclsIHPremium.Discount, objclsIHPremium.UnderWriterName, objclsIHPremium.ProductName, objclsIHPremium.UniqueNo };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "P_TM_IHPremiumRating_Update", "TM_IH_TempPremiumRating_Update"));
// return dataAccessDS.ExecuteNonQuery("P_TM_IHPremiumRating_Update", parameters);
}
public DataSet getIHCardPrinting(clsIHPremiumRating ObjIHPremiumRating)
{
object[] parameters = new object[] { ObjIHPremiumRating.Name,
ObjIHPremiumRating.PolicyNo,
ObjIHPremiumRating.SixtinthDigitsNo,
ObjIHPremiumRating.Scheme,
ObjIHPremiumRating.Program,
ObjIHPremiumRating.PlanType,
ObjIHPremiumRating.EffFromDate,
ObjIHPremiumRating.EffToDate };
dataAccessDS = new DataAccess();
return(dataAccessDS.LoadDataSet(parameters, "Get_TMIHCardPrinting", "TM_IH_CardPrinting"));
}
public DataSet getDiscount(clsIHPremiumRating objRating)
{
dataAccessDS = new DataAccess();
object[] parameters = new Object[] { objRating.UnderWriterName, objRating.ProductName };
return(dataAccessDS.LoadDataSet(parameters, "P_Get_IHPremuimRating_Discount", "IHDiscount"));
}
public DataSet getProductName(clsIHPremiumRating ObjIHPremiumRating)
{
dataAccessDS = new DataAccess();
object[] parameters = new object[] { ObjIHPremiumRating.UnderWriterName, ObjIHPremiumRating.ProductName, ObjIHPremiumRating.calledFrom };
return(dataAccessDS.LoadDataSet(parameters, "P_Get_ProductName_From_UWCode", "P_Get_ProductName_From_UWCode"));
}
public DataSet getProductCodeAndUWCode(clsIHPremiumRating ObjIHPremiumRating)
{
dataAccessDS = new DataAccess();
object[] parameters = new object[] { ObjIHPremiumRating.PolicyId, ObjIHPremiumRating.PolVersionId };
return(dataAccessDS.LoadDataSet(parameters, "Pol_Policy_UWCodeandProductCode", "ProductUWCode"));
}
public DataSet getDropDownValuesFroIHRating(clsIHPremiumRating ObjIHPremiumRating)
{
dataAccessDS = new DataAccess();
object[] parameters = new object[] { ObjIHPremiumRating.UnderWriterName, ObjIHPremiumRating.ProductName };
return(dataAccessDS.LoadDataSet(parameters, "P_Get_IHPremuimRating_Values", "P_Get_IHPremuimRating_Values"));
}