예제 #1
0
        //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"));
        }
예제 #2
0
        //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);
        }
예제 #3
0
        //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"));
        }
예제 #4
0
        //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"));
        }
예제 #5
0
        //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);
        }
예제 #6
0
 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"));
 }
예제 #7
0
 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"));
 }
예제 #8
0
 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"));
 }
예제 #9
0
 public DataSet getProductCodeAndUWCode(clsIHPremiumRating ObjIHPremiumRating)
 {
     dataAccessDS = new DataAccess();
     object[] parameters = new object[] { ObjIHPremiumRating.PolicyId, ObjIHPremiumRating.PolVersionId };
     return(dataAccessDS.LoadDataSet(parameters, "Pol_Policy_UWCodeandProductCode", "ProductUWCode"));
 }
예제 #10
0
 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"));
 }