Example #1
0
        public static void Init()   //Load data from Defaults table
        {
            ReportsSavePath = CCFBGlobal.pathReports;
            SqlConnection  conn    = new SqlConnection(CCFBGlobal.connectionString);
            SqlCommand     command = new SqlCommand("SELECT * FROM " + tbName + " ORDER BY EditForm, FldName", conn);
            SqlDataAdapter dadAdpt = new SqlDataAdapter(command);
            DataSet        dset    = new DataSet();
            int            NbrRows = dadAdpt.Fill(dset);

            foreach (DataRow drow in dset.Tables[0].Rows)
            {
                switch (drow.Field <string>("fldname").ToLower())
                {
                case "agencynumber":            AgencyNumber = drow.Field <string>(constFldValue); break;

                case "alertmindaystext":        AlertMinDaysText = drow.Field <string>(constFldValue); break;

                case "alertminimumdays":        AlertMinimumDays = Convert.ToInt32(drow[constFldValue]); break;

                case "alertminmonthstext":      AlertMinMonthsText = drow.Field <string>(constFldValue); break;

                case "alertminimummonths":      AlertMinimumMonths = Convert.ToInt32(drow[constFldValue]); break;

                case "alertmonthsvc":           AlertMonthSvc = Convert.ToInt32(drow[constFldValue]); break;

                case "alertmonthsvctext":       AlertMonthSvcText = drow.Field <string>(constFldValue); break;

                case "alertweeksvc":            AlertWeekSvc = Convert.ToInt32(drow[constFldValue]); break;

                case "alertweeksvctext":        AlertWeekSvcText = drow.Field <string>(constFldValue); break;

                case "allowduplicatehhnames":   AllowDuplicateHHNames = drow.Field <bool>(constBoolVal); break;

                case "allowduplicatemembernames": AllowDuplicateMemberNames = drow.Field <bool>(constBoolVal); break;

                case "allowlbsmanualentry":     AllowLbsManualEntry = drow.Field <bool>(constBoolVal); break;

                case "apptlogrefreshrate":      ApptLogRefreshRate = Convert.ToInt32(drow[constFldValue]); break;

                case "automaticallygiveservice": AutomaticallyGiveService = drow.Field <bool>(constBoolVal); break;

                case "capturesignature":        CaptureSignature = drow.Field <bool>(constBoolVal); break;

                case "capturetefapsignature":   CaptureTEFAPSignature = drow.Field <bool>(constBoolVal); break;

                case "commsigvalidfor":         CommSigValidFor = Convert.ToInt32(drow[constFldValue]); break;

                case "county":                  County = drow.Field <string>(constFldValue); break;

                case "csfplbsperservice":       CSFPLbsPerService = Convert.ToInt32(drow[constFldValue]); break;

                case "defaultcity":             DefaultCity = drow.Field <string>(constFldValue); break;

                case "defaultfmidype":          DefaultFMIDType = Convert.ToInt32(drow[constFldValue]); break;

                case "defaultstate":            DefaultState = drow.Field <string>(constFldValue); break;

                case "defaultzipcode":          DefaultZipcode = drow.Field <string>(constFldValue); break;

                case "donorid01":               DonorId01 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid02":               DonorId02 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid03":               DonorId03 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid04":               DonorId04 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid05":               DonorId05 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid06":               DonorId06 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid07":               DonorId07 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid08":               DonorId08 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid09":               DonorId09 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid10":               DonorId10 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid11":               DonorId11 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid12":               DonorId12 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid13":               DonorId13 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid14":               DonorId14 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid15":               DonorId15 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid16":               DonorId16 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid17":               DonorId17 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid18":               DonorId18 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid19":               DonorId19 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid20":               DonorId20 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid2ndharvest":       DonorID2ndHarvest = Convert.ToInt32(drow[constFldValue]); break;

                case "donoridefap":             DonorIDEFAP = Convert.ToInt32(drow[constFldValue]); break;

                case "donoridtefap":            DonorIDTEFAP = Convert.ToInt32(drow[constFldValue]); break;

                case "donornwh":                DonorIDNWH = Convert.ToInt32(drow[constFldValue]); break;

                case "efapleadagency":          EFAPLeadAgency = drow.Field <string>(constFldValue); break;

                case "emailaddress":            EmailAddress = drow.Field <string>(constFldValue); break;

                case "enableadditionalhhmdatatab": EnableAdditionalHHMDataTab = drow.Field <bool>(constBoolVal); break;

                case "enableappointments":      EnableAppointments = drow.Field <bool>(constBoolVal); break;

                case "enablebabyservices":      EnableBabyServices = drow.Field <bool>(constBoolVal); break;

                case "enablebackpack":          EnableBackPack = drow.Field <bool>(constBoolVal); break;

                case "enablebarcodeprompts":    EnableBarcodePrompts = drow.Field <bool>(constBoolVal); break;

                case "enablecashdonations":     EnableCashDonations = drow.Field <bool>(constBoolVal); break;

                case "enablecdbgreporting":     EnableCDBGReporting = drow.Field <bool>(constBoolVal); break;

                case "enableclientphone":       EnableClientPhone = drow.Field <bool>(constBoolVal); break;

                case "enableclientreceipt":     EnableClientReceipt = drow.Field <bool>(constBoolVal); break;

                case "enablecsfp":              EnableCSFP = drow.Field <bool>(constBoolVal); break;

                case "enablecsfponnewsvc":      EnableCSFPOnNewSvc = drow.Field <bool>(constBoolVal); break;

                case "enablecsfpshowroutes":    EnableCSFPShowRoutes = drow.Field <bool>(constBoolVal); break;

                case "enableethnicityhhmtab":   EnableEthnicityHHMTab = drow.Field <bool>(constBoolVal); break;

                case "enablefasttrack":         EnableFastTrack = drow.Field <bool>(constBoolVal); break;

                case "enablefooddonations":     EnableFoodDonations = drow.Field <bool>(constBoolVal); break;

                case "enablefoodservices":      EnableFoodServices = drow.Field <bool>(constBoolVal); break;

                case "enableFTscale": EnableFTscale = drow.Field <bool>(constBoolVal); break;

                case "lbsIncludeCommodityWt": LbsIncludeCommodityWt = drow.Field <bool>(constBoolVal); break;

                case "enablehhuserdefinedfieldstab": EnableHHUserDefinedFields = drow.Field <bool>(constBoolVal); break;

                case "enablehomedeliv":         EnableHomeDeliv = drow.Field <bool>(constBoolVal); break;

                case "enablehouseholdincome":   EnableHouseholdIncome = drow.Field <bool>(constBoolVal); break;

                case "enablehudcategory":       EnableHUDCategory = drow.Field <bool>(constBoolVal); break;

                case "enableidflds":            EnableIDFlds = drow.Field <bool>(constBoolVal); break;

                case "enablepointstracking":    EnablePointsTracking = drow.Field <bool>(constBoolVal); break;

                case "enableprintclientcard":   EnablePrintClientCard = drow.Field <bool>(constBoolVal); break;

                case "enableschsupply":     EnableSchSupply = drow.Field <bool>(constBoolVal); break;

                case "enableservicegroups":     EnableServiceGroups = drow.Field <bool>(constBoolVal); break;

                case "enablesupplemental":      EnableSupplemental = drow.Field <bool>(constBoolVal); break;

                case "enabletefap":             EnableTEFAP = drow.Field <bool>(constBoolVal); break;

                case "enabletransporation":     EnableTransportation = drow.Field <bool>(constBoolVal); break;

                case "enableverifyid":          EnableVerifyId = drow.Field <bool>(constBoolVal); break;

                case "enablevolunteerhours":    EnableVolunteerHours = drow.Field <bool>(constBoolVal); break;

                case "enablevouchers":          EnableVouchers = drow.Field <bool>(constBoolVal); break;

                case "enableworksinarea":       EnableWorksInArea = drow.Field <bool>(constBoolVal); break;

                //case "familycardslot1": FamilyCardSlot1 = Convert.ToInt32(drow[constFldValue]); break;
                //case "familycardslot2": FamilyCardSlot2 = Convert.ToInt32(drow[constFldValue]); break;
                //case "familycardslot3": FamilyCardSlot3 = Convert.ToInt32(drow[constFldValue]); break;
                //case "familycardslot4": FamilyCardSlot4 = Convert.ToInt32(drow[constFldValue]); break;
                case "faxnumber":               FaxNumber = drow.Field <string>(constFldValue); break;

                case "filterperiodfromaddress": FilterPeriodFromAddress = drow.Field <bool>(constBoolVal); break;

                case "findclientautorefresh":   FindClientAutoRefresh = drow.Field <bool>(constBoolVal); break;

                case "fiscalyearstartmonth":    FiscalYearStartMonth = Convert.ToInt32(drow[constFldValue]); break;

                case "foodbankname":            FoodBankName = drow.Field <string>(constFldValue); break;

                case "includecommoditylbsincoalition": IncludeCommodityLbsInCoalition = drow.Field <bool>(constBoolVal); break;

                case "includecommoditylbsinfoodlifeline": IncludeCommodityLbsInFoodLifeline = drow.Field <bool>(constBoolVal); break;

                case "includecommoditylbsinnorhtwestharvest": IncludeCommodityLbsInNorhtwestHarvest = drow.Field <bool>(constBoolVal); break;

                case "includecommoditylbsinsecondharvestinland": IncludeCommodityLbsInCoalition = drow.Field <bool>(constBoolVal); break;

                case "includelbsonsvclist":     IncludeLbsOnSvcList = drow.Field <bool>(constBoolVal); break;

                case "inkinddollarsperhour":    InkindDollarsPerHr = Convert.ToDecimal(drow[constFldValue]); break;

                case "inkinddollarsperlb":      InkindDollarsPerLb = Convert.ToDecimal(drow[constFldValue]); break;

                case "maxpointsperweek":        MaxPointsPerWeek = Convert.ToInt32(drow[constFldValue]); break;

                case "mergeteens":              MergeTeens = drow.Field <bool>(constBoolVal); break;

                case "mustbeacommodityday":     MustBeACommodityDay = drow.Field <bool>(constBoolVal); break;

                case "nbrdaysallowmods":        NbrDaysAllowMods = Convert.ToInt32(drow[constFldValue]); break;

                case "nbrmealsperservice":      NbrMealsPerService = Convert.ToInt32(drow[constFldValue]); break;

                case "nbrsvcdatesfuture":       NbrSvcDatesFuture = Convert.ToInt32(drow[constFldValue]); break;

                case "nbrsvcdatespast":         NbrSvcDatesPast = Convert.ToInt32(drow[constFldValue]); break;

                case "overridelevel":           OverRideLevel = Convert.ToInt32(drow[constFldValue]); break;

                case "phonenumber":             PhoneNumber = drow.Field <string>(constFldValue); break;

                case "physicaladdress":         PhysicalAddress = drow.Field <string>(constFldValue); break;

                case "pointsperfammbr":         PointsPerFamMbr = Convert.ToInt32(drow[constFldValue]); break;

                case "pointsperweek":           PointsPerWeek = Convert.ToInt32(drow[constFldValue]); break;

                case "pointsperweekoutofarea":  PointsPerWeekOutOfArea = Convert.ToInt32(drow[constFldValue]); break;

                case "postaladdress":           PostalAddress = drow.Field <string>(constFldValue); break;

                case "preparedby":              PreparedBy = drow.Field <string>(constFldValue); break;

                case "reportssavepath":         ReportsSavePath = drow.Field <string>(constFldValue); break;

                case "servicelogrefreshrate":   ServiceLogRefreshRate = Convert.ToInt32(drow[constFldValue]); break;

                case "servicemenutype":         ServiceMenuType = Convert.ToInt32(drow[constFldValue]); break;

                case "transientid":             TransientId = Convert.ToInt32(drow[constFldValue]); break;

                case "barcodeusefamilymember":  BarcodeUseFamilyMember = drow.Field <bool>(constBoolVal); break;

                case "usecalendarweeks":        UseCalendarWeeks = drow.Field <bool>(constBoolVal); break;

                case "usetimeinoutforvols":     UseTimeInOutForVols = drow.Field <bool>(constBoolVal); break;

                case "usefamilylist":
                    if (drow[constFldValue].ToString() == "0")
                    {
                        UseFamilyList = UseFamilyListCode.Normally;
                    }
                    else if (drow[constFldValue].ToString() == "1")
                    {
                        UseFamilyList = UseFamilyListCode.Sometimes;
                    }
                    else if (drow[constFldValue].ToString() == "2")
                    {
                        UseFamilyList = UseFamilyListCode.Always;
                    }
                    else
                    {
                        UseFamilyList = UseFamilyListCode.Never;
                    }
                    break;

                case "warnsvceachperson":       WarnSvcEachPerson = drow.Field <bool>(constBoolVal); break;

                case "donorpercentcalcmethod":
                    if (drow[constFldValue].ToString() == "0")
                    {
                        DonorPercentCalcMethod = DonorCalcPercentMethod.LbsServed;
                    }
                    else
                    {
                        DonorPercentCalcMethod = DonorCalcPercentMethod.LbsDonated;
                    }
                    break;
                }
            }
        }
Example #2
0
        public static void Init()   //Load data from Defaults table
        {
            SqlConnection  conn    = new SqlConnection(CCFBGlobal.connectionString);
            SqlCommand     command = new SqlCommand("SELECT * FROM " + tbName + " ORDER BY EditForm, FldName", conn);
            SqlDataAdapter dadAdpt = new SqlDataAdapter(command);
            DataSet        dset    = new DataSet();
            int            NbrRows = dadAdpt.Fill(dset);

            foreach (DataRow drow in dset.Tables[0].Rows)
            {
                switch (drow.Field <string>("fldname").ToLower())
                {
                case "foodbankname": FoodBankName = drow.Field <string>(constFldValue); break;

                case "postaladdress": PostalAddress = drow.Field <string>(constFldValue); break;

                case "physicaladdress": PhysicalAddress = drow.Field <string>(constFldValue); break;

                case "phonenumber": PhoneNumber = drow.Field <string>(constFldValue); break;

                case "county": County = drow.Field <string>(constFldValue); break;

                case "emailaddress": EmailAddress = drow.Field <string>(constFldValue); break;

                case "faxnumber": FaxNumber = drow.Field <string>(constFldValue); break;

                case "enablebarcodeprompts": EnableBarcodePrompts = drow.Field <bool>(constBoolVal); break;

                case "enablefoodservices": EnableFoodServices = drow.Field <bool>(constBoolVal); break;

                case "enableappointments": EnableAppointments = drow.Field <bool>(constBoolVal); break;

                case "enablefooddonations": EnableFoodDonations = drow.Field <bool>(constBoolVal); break;

                case "enablecashdonations": EnableCashDonations = drow.Field <bool>(constBoolVal); break;

                case "enablevolunteerhours": EnableVolunteerHours = drow.Field <bool>(constBoolVal); break;

                case "enableprintclientcard": EnablePrintClientCard = drow.Field <bool>(constBoolVal); break;

                case "enablevouchers": EnableVouchers = drow.Field <bool>(constBoolVal); break;

                case "enablecsfp": EnableCSFP = drow.Field <bool>(constBoolVal); break;

                case "enabletefap": EnableTEFAP = drow.Field <bool>(constBoolVal); break;

                case "mustbeacommodityday": MustBeACommodityDay = drow.Field <bool>(constBoolVal); break;

                case "enablebabyservices": EnableBabyServices = drow.Field <bool>(constBoolVal); break;

                case "enablesupplemental": EnableSupplemental = drow.Field <bool>(constBoolVal); break;

                case "enableclientphone": EnableClientPhone = drow.Field <bool>(constBoolVal); break;

                case "enableverifyid": EnableVerifyId = drow.Field <bool>(constBoolVal); break;

                case "enablehouseholdincome": EnableHouseholdIncome = drow.Field <bool>(constBoolVal); break;

                case "enablehhuserdefinedfieldstab": EnableHHUserDefinedFields = drow.Field <bool>(constBoolVal); break;

                case "enableadditionalhhmdatatab": EnableAdditionalHHMDataTab = drow.Field <bool>(constBoolVal); break;

                case "enableethnicityhhmtab": EnableEthnicityHHMTab = drow.Field <bool>(constBoolVal); break;

                case "enableworksinarea": EnableWorksInArea = drow.Field <bool>(constBoolVal); break;

                case "defaultcity": DefaultCity = drow.Field <string>(constFldValue); break;

                case "defaultstate": DefaultState = drow.Field <string>(constFldValue); break;

                case "defaultzipcode": DefaultZipcode = drow.Field <string>(constFldValue); break;

                case "allowduplicatehhnames": AllowDuplicateHHNames = drow.Field <bool>(constBoolVal); break;

                case "allowduplicatemembernames": AllowDuplicateMemberNames = drow.Field <bool>(constBoolVal); break;

                case "usefamilylist":
                    if (drow[constFldValue].ToString() == "0")
                    {
                        UseFamilyList = UseFamilyListCode.Normally;
                    }
                    else if (drow[constFldValue].ToString() == "1")
                    {
                        UseFamilyList = UseFamilyListCode.Sometimes;
                    }
                    else if (drow[constFldValue].ToString() == "2")
                    {
                        UseFamilyList = UseFamilyListCode.Always;
                    }
                    else
                    {
                        UseFamilyList = UseFamilyListCode.Never;
                    }
                    break;

                case "findclientautorefresh": FindClientAutoRefresh = drow.Field <bool>(constBoolVal); break;

                case "servicelogrefreshrate": ServiceLogRefreshRate = Convert.ToInt32(drow[constFldValue]); break;

                case "apptlogrefreshrate": ApptLogRefreshRate = Convert.ToInt32(drow[constFldValue]); break;

                case "nbrmealsperservice": NbrMealsPerService = Convert.ToInt32(drow[constFldValue]); break;

                case "nbrdaysallowmods": NbrDaysAllowMods = Convert.ToInt32(drow[constFldValue]); break;

                case "nbrsvcdatesfuture": NbrSvcDatesFuture = Convert.ToInt32(drow[constFldValue]); break;

                case "nbrsvcdatespast": NbrSvcDatesPast = Convert.ToInt32(drow[constFldValue]); break;

                case "familycardslot1": FamilyCardSlot1 = Convert.ToInt32(drow[constFldValue]); break;

                case "familycardslot2": FamilyCardSlot2 = Convert.ToInt32(drow[constFldValue]); break;

                case "familycardslot3": FamilyCardSlot3 = Convert.ToInt32(drow[constFldValue]); break;

                case "familycardslot4": FamilyCardSlot4 = Convert.ToInt32(drow[constFldValue]); break;

                case "fiscalyearstartmonth": FiscalYearStartMonth = Convert.ToInt32(drow[constFldValue]); break;

                case "inkinddollarsperhour": InkindDollarsPerHr = Convert.ToDecimal(drow[constFldValue]); break;

                case "inkinddollarsperlb": InkindDollarsPerLb = Convert.ToDecimal(drow[constFldValue]); break;

                case "donorid01": DonorId01 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid02": DonorId02 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid03": DonorId03 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid04": DonorId04 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid05": DonorId05 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid06": DonorId06 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid07": DonorId07 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid08": DonorId08 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid09": DonorId09 = Convert.ToInt32(drow[constFldValue]); break;

                case "donorid10": DonorId10 = Convert.ToInt32(drow[constFldValue]); break;

                case "includecommoditylbsincoalition": IncludeCommodityLbsInCoalition = drow.Field <bool>(constBoolVal); break;

                case "includecommoditylbsinfoodlifeline": IncludeCommodityLbsInFoodLifeline = drow.Field <bool>(constBoolVal); break;

                case "includecommoditylbsinnorhtwestharvest": includecommoditylbsinnorhtwestharvest = drow.Field <bool>(constBoolVal); break;

                case "includecommoditylbsinsecondharvestinland": IncludeCommodityLbsInCoalition = drow.Field <bool>(constBoolVal); break;

                case "donorpercentcalcmethod":
                    if (drow[constFldValue].ToString() == "0")
                    {
                        DonorPercentCalcMethod = DonorCalcPercentMethod.LbsServed;
                    }
                    else
                    {
                        DonorPercentCalcMethod = DonorCalcPercentMethod.LbsDonated;
                    }
                    break;

                case "preparedby":      PreparedBy = drow.Field <string>(constFldValue); break;

                case "reportssavepath": ReportsSavePath = drow.Field <string>(constFldValue); break;

                case "transientid": TransientId = Convert.ToInt32(drow[constFldValue]); break;

                case "usetimeinoutforvols": UseTimeInOutForVols = drow.Field <bool>(constBoolVal); break;
                }
            }
        }
Example #3
0
 //Load data from Defaults table
 public static void Init()
 {
     ReportsSavePath = CCFBGlobal.pathReports;
     SqlConnection conn = new SqlConnection(CCFBGlobal.connectionString);
     SqlCommand command = new SqlCommand("SELECT * FROM " + tbName + " ORDER BY EditForm, FldName", conn);
     SqlDataAdapter dadAdpt = new SqlDataAdapter(command);
     DataSet dset = new DataSet();
     int NbrRows = dadAdpt.Fill(dset);
     foreach (DataRow drow in dset.Tables[0].Rows)
     {
         switch (drow.Field<string>("fldname").ToLower())
         {
             case "agencynumber": AgencyNumber = drow.Field<string>(constFldValue); break;
             case "alertmindaystext": AlertMinDaysText = drow.Field<string>(constFldValue); break;
             case "alertminimumdays": AlertMinimumDays = Convert.ToInt32(drow[constFldValue]); break;
             case "alertminmonthstext": AlertMinMonthsText = drow.Field<string>(constFldValue); break;
             case "alertminimummonths": AlertMinimumMonths = Convert.ToInt32(drow[constFldValue]); break;
             case "alertmonthsvc": AlertMonthSvc = Convert.ToInt32(drow[constFldValue]); break;
             case "alertmonthsvctext": AlertMonthSvcText = drow.Field<string>(constFldValue); break;
             case "alertweeksvc": AlertWeekSvc = Convert.ToInt32(drow[constFldValue]); break;
             case "alertweeksvctext": AlertWeekSvcText = drow.Field<string>(constFldValue); break;
             case "allowduplicatehhnames": AllowDuplicateHHNames = drow.Field<bool>(constBoolVal); break;
             case "allowduplicatemembernames": AllowDuplicateMemberNames = drow.Field<bool>(constBoolVal); break;
             case "apptlogrefreshrate": ApptLogRefreshRate = Convert.ToInt32(drow[constFldValue]); break;
             case "automaticallygiveservice": AutomaticallyGiveService = drow.Field<bool>(constBoolVal); break;
             case "capturesignature": CaptureSignature = drow.Field<bool>(constBoolVal); break;
             case "capturetefapsignature": CaptureTEFAPSignature = drow.Field<bool>(constBoolVal); break;
             case "commsigvalidfor": CommSigValidFor = Convert.ToInt32(drow[constFldValue]); break;
             case "county": County = drow.Field<string>(constFldValue); break;
             case "csfplbsperservice": CSFPLbsPerService = Convert.ToInt32(drow[constFldValue]); break;
             case "defaultcity": DefaultCity = drow.Field<string>(constFldValue); break;
             case "defaultfmidype": DefaultFMIDType = Convert.ToInt32(drow[constFldValue]); break;
             case "defaultstate": DefaultState = drow.Field<string>(constFldValue); break;
             case "defaultzipcode": DefaultZipcode = drow.Field<string>(constFldValue); break;
             case "donorid01": DonorId01 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid02": DonorId02 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid03": DonorId03 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid04": DonorId04 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid05": DonorId05 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid06": DonorId06 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid07": DonorId07 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid08": DonorId08 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid09": DonorId09 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid10": DonorId10 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid11": DonorId11 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid12": DonorId12 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid13": DonorId13 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid14": DonorId14 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid15": DonorId15 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid16": DonorId16 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid17": DonorId17 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid18": DonorId18 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid19": DonorId19 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid20": DonorId20 = Convert.ToInt32(drow[constFldValue]); break;
             case "donorid2ndharvest": DonorID2ndHarvest = Convert.ToInt32(drow[constFldValue]); break;
             case "donoridefap": DonorIDEFAP = Convert.ToInt32(drow[constFldValue]); break;
             case "donoridtefap": DonorIDTEFAP = Convert.ToInt32(drow[constFldValue]); break;
             case "donornwh": DonorIDNWH = Convert.ToInt32(drow[constFldValue]); break;
             case "efapleadagency": EFAPLeadAgency = drow.Field<string>(constFldValue); break;
             case "emailaddress": EmailAddress = drow.Field<string>(constFldValue); break;
             case "enableadditionalhhmdatatab": EnableAdditionalHHMDataTab = drow.Field<bool>(constBoolVal); break;
             case "enableappointments": EnableAppointments = drow.Field<bool>(constBoolVal); break;
             case "enablebabyservices": EnableBabyServices = drow.Field<bool>(constBoolVal); break;
             case "enablebackpack": EnableBackPack = drow.Field<bool>(constBoolVal); break;
             case "enablebarcodeprompts": EnableBarcodePrompts = drow.Field<bool>(constBoolVal); break;
             case "enablecashdonations": EnableCashDonations = drow.Field<bool>(constBoolVal); break;
             case "enablecdbgreporting": EnableCDBGReporting = drow.Field<bool>(constBoolVal); break;
             case "enableclientphone": EnableClientPhone = drow.Field<bool>(constBoolVal); break;
             case "enableclientreceipt": EnableClientReceipt = drow.Field<bool>(constBoolVal); break;
             case "enablecsfp": EnableCSFP = drow.Field<bool>(constBoolVal); break;
             case "enablecsfponnewsvc": EnableCSFPOnNewSvc = drow.Field<bool>(constBoolVal); break;
             case "enablecsfpshowroutes": EnableCSFPShowRoutes = drow.Field<bool>(constBoolVal); break;
             case "enableethnicityhhmtab": EnableEthnicityHHMTab = drow.Field<bool>(constBoolVal); break;
             case "enablefasttrack": EnableFastTrack = drow.Field<bool>(constBoolVal); break;
             case "enablefooddonations": EnableFoodDonations = drow.Field<bool>(constBoolVal); break;
             case "enablefoodservices": EnableFoodServices = drow.Field<bool>(constBoolVal); break;
             case "enableFTscale": EnableFTscale = drow.Field<bool>(constBoolVal); break;
             case "lbsIncludeCommodityWt": LbsIncludeCommodityWt = drow.Field<bool>(constBoolVal); break;
             case "enablehhuserdefinedfieldstab": EnableHHUserDefinedFields = drow.Field<bool>(constBoolVal); break;
             case "enablehomedeliv": EnableHomeDeliv = drow.Field<bool>(constBoolVal); break;
             case "enablehouseholdincome": EnableHouseholdIncome = drow.Field<bool>(constBoolVal); break;
             case "enablehudcategory": EnableHUDCategory = drow.Field<bool>(constBoolVal); break;
             case "enableidflds": EnableIDFlds = drow.Field<bool>(constBoolVal); break;
             case "enablepointstracking": EnablePointsTracking = drow.Field<bool>(constBoolVal); break;
             case "enableprintclientcard": EnablePrintClientCard = drow.Field<bool>(constBoolVal); break;
             case "enableservicegroups": EnableServiceGroups = drow.Field<bool>(constBoolVal); break;
             case "enablesupplemental": EnableSupplemental = drow.Field<bool>(constBoolVal); break;
             case "enabletefap": EnableTEFAP = drow.Field<bool>(constBoolVal); break;
             case "enabletransporation": EnableTransportation = drow.Field<bool>(constBoolVal); break;
             case "enableverifyid": EnableVerifyId = drow.Field<bool>(constBoolVal); break;
             case "enablevolunteerhours": EnableVolunteerHours = drow.Field<bool>(constBoolVal); break;
             case "enablevouchers": EnableVouchers = drow.Field<bool>(constBoolVal); break;
             case "enableworksinarea": EnableWorksInArea = drow.Field<bool>(constBoolVal); break;
             //case "familycardslot1": FamilyCardSlot1 = Convert.ToInt32(drow[constFldValue]); break;
             //case "familycardslot2": FamilyCardSlot2 = Convert.ToInt32(drow[constFldValue]); break;
             //case "familycardslot3": FamilyCardSlot3 = Convert.ToInt32(drow[constFldValue]); break;
             //case "familycardslot4": FamilyCardSlot4 = Convert.ToInt32(drow[constFldValue]); break;
             case "faxnumber": FaxNumber = drow.Field<string>(constFldValue); break;
             case "filterperiodfromaddress": FilterPeriodFromAddress = drow.Field<bool>(constBoolVal); break;
             case "findclientautorefresh": FindClientAutoRefresh = drow.Field<bool>(constBoolVal); break;
             case "fiscalyearstartmonth": FiscalYearStartMonth = Convert.ToInt32(drow[constFldValue]); break;
             case "foodbankname": FoodBankName = drow.Field<string>(constFldValue); break;
             case "includecommoditylbsincoalition": IncludeCommodityLbsInCoalition = drow.Field<bool>(constBoolVal); break;
             case "includecommoditylbsinfoodlifeline": IncludeCommodityLbsInFoodLifeline = drow.Field<bool>(constBoolVal); break;
             case "includecommoditylbsinnorhtwestharvest": IncludeCommodityLbsInNorhtwestHarvest = drow.Field<bool>(constBoolVal); break;
             case "includecommoditylbsinsecondharvestinland": IncludeCommodityLbsInCoalition = drow.Field<bool>(constBoolVal); break;
             case "includelbsonsvclist": IncludeLbsOnSvcList = drow.Field<bool>(constBoolVal); break;
             case "inkinddollarsperhour": InkindDollarsPerHr = Convert.ToDecimal(drow[constFldValue]); break;
             case "inkinddollarsperlb": InkindDollarsPerLb = Convert.ToDecimal(drow[constFldValue]); break;
             case "maxpointsperweek": MaxPointsPerWeek = Convert.ToInt32(drow[constFldValue]); break;
             case "mergeteens": MergeTeens = drow.Field<bool>(constBoolVal); break;
             case "mustbeacommodityday": MustBeACommodityDay = drow.Field<bool>(constBoolVal); break;
             case "nbrdaysallowmods": NbrDaysAllowMods = Convert.ToInt32(drow[constFldValue]); break;
             case "nbrmealsperservice": NbrMealsPerService = Convert.ToInt32(drow[constFldValue]); break;
             case "nbrsvcdatesfuture": NbrSvcDatesFuture = Convert.ToInt32(drow[constFldValue]); break;
             case "nbrsvcdatespast": NbrSvcDatesPast = Convert.ToInt32(drow[constFldValue]); break;
             case "overridelevel": OverRideLevel = Convert.ToInt32(drow[constFldValue]); break;
             case "phonenumber": PhoneNumber = drow.Field<string>(constFldValue); break;
             case "physicaladdress": PhysicalAddress = drow.Field<string>(constFldValue); break;
             case "pointsperfammbr": PointsPerFamMbr = Convert.ToInt32(drow[constFldValue]); break;
             case "pointsperweek": PointsPerWeek = Convert.ToInt32(drow[constFldValue]); break;
             case "pointsperweekoutofarea": PointsPerWeekOutOfArea = Convert.ToInt32(drow[constFldValue]); break;
             case "postaladdress": PostalAddress = drow.Field<string>(constFldValue); break;
             case "preparedby": PreparedBy = drow.Field<string>(constFldValue); break;
             case "reportssavepath": ReportsSavePath = drow.Field<string>(constFldValue); break;
             case "servicelogrefreshrate": ServiceLogRefreshRate = Convert.ToInt32(drow[constFldValue]); break;
             case "servicemenutype": ServiceMenuType = Convert.ToInt32(drow[constFldValue]); break;
             case "transientid": TransientId = Convert.ToInt32(drow[constFldValue]); break;
             case "barcodeusefamilymember": BarcodeUseFamilyMember = drow.Field<bool>(constBoolVal); break;
             case "usecalendarweeks": UseCalendarWeeks = drow.Field<bool>(constBoolVal); break;
             case "usetimeinoutforvols": UseTimeInOutForVols = drow.Field<bool>(constBoolVal); break;
             case "usefamilylist":
                 if (drow[constFldValue].ToString() == "0")
                     UseFamilyList = UseFamilyListCode.Normally;
                 else if (drow[constFldValue].ToString() == "1")
                     UseFamilyList = UseFamilyListCode.Sometimes;
                 else if (drow[constFldValue].ToString() == "2")
                     UseFamilyList = UseFamilyListCode.Always;
                 else
                     UseFamilyList = UseFamilyListCode.Never;
                 break;
             case "warnsvceachperson": WarnSvcEachPerson = drow.Field<bool>(constBoolVal); break;
             case "donorpercentcalcmethod":
                 if (drow[constFldValue].ToString() == "0")
                     DonorPercentCalcMethod = DonorCalcPercentMethod.LbsServed;
                 else
                     DonorPercentCalcMethod = DonorCalcPercentMethod.LbsDonated;
                 break;
         }
     }
 }