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;
}
}
}
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;
}
}
}
//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;
}
}
}