public static List <RebatesOfficeWise> GetRebateOfficeWiseList(bool allOffices = false, bool showDeleted = false)
        {
            List <RebatesOfficeWise> CRMPolicyList = new List <RebatesOfficeWise>();

            DataTable RebatesOfficeWiseTableType = RebatesOfficeWiseDataAccess.GetInstance.GetRebateOfficeWiseList(allOffices, showDeleted);

            foreach (DataRow dr in RebatesOfficeWiseTableType.Rows)
            {
                RebatesOfficeWise TheRebatesOfficeWise = RebateDataRowToObject(dr);

                CRMPolicyList.Add(TheRebatesOfficeWise);
            }

            return(CRMPolicyList);
        }
        public static List <RebatesOfficeWise> GetRebatesSelectByOfficeID(bool ShowInOfficewise = false)
        {
            List <RebatesOfficeWise> RebatesOfficeWiseList = new List <RebatesOfficeWise>();

            DataTable RebatesOfficeWiseTableType = RebatesOfficeWiseDataAccess.GetInstance.GetRebatesSelectByOfficeID(ShowInOfficewise);

            foreach (DataRow dr in RebatesOfficeWiseTableType.Rows)
            {
                RebatesOfficeWise TheRebatesOfficeWise = RebateDataRowToObject(dr);

                RebatesOfficeWiseList.Add(TheRebatesOfficeWise);
            }

            return(RebatesOfficeWiseList);
        }
        public static RebatesOfficeWise RebateDataRowToObject(DataRow dr)
        {
            RebatesOfficeWise TheRebate = new RebatesOfficeWise();

            //TheRebate.RebateOfficewiseID = int.Parse(dr["RebateOfficewiseID"].ToString());
            TheRebate.RebateID = int.Parse(dr["RebateID"].ToString());
            TheRebate.PolicyTypeDescription = dr["PolicyTypeDescription"].ToString();
            TheRebate.PolicyName            = dr["PolicyName"].ToString();
            TheRebate.RebatePer             = dr["RebatePer"].ToString();
            TheRebate.RebateValue           = dr["RebateValue"].ToString();
            TheRebate.EffectiveDateFrom     = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat);
            TheRebate.OfficeID   = int.Parse(dr["OfficeID"].ToString());
            TheRebate.OfficeName = dr["OfficeName"].ToString();
            //TheRebate.PolicyID = int.Parse(dr["PolicyID"].ToString());
            //TheRebate.PolicyFromOrganization = dr["PolicyFromOrganization"].ToString();
            //TheRebate.OfficeCode = dr["OfficeCode"].ToString();
            //TheRebate.EffectiveDateTo = DateTime.Parse(dr["EffectiveDateTo"].ToString()).ToString(MicroConstants.DateFormat);
            return(TheRebate);
        }