/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcsrdetailranks(ref DataRow row, Icsrdetailranks entity) { row.SetField("ranklevel", entity.ranklevel); row.SetField("rankpct", entity.rankpct); row.SetField("rankpctrec", entity.rankpctrec); row.SetField("rankpctlev", entity.rankpctlev); row.SetField("minhits", entity.minhits); row.SetField("minhitsrec", entity.minhitsrec); row.SetField("minhitslev", entity.minhitslev); row.SetField("usgmths", entity.usgmths); row.SetField("usgmthsrec", entity.usgmthsrec); row.SetField("usgmthslev", entity.usgmthslev); row.SetField("maxleadtime", entity.maxleadtime); row.SetField("maxleadrec", entity.maxleadrec); row.SetField("maxleadlev", entity.maxleadlev); row.SetField("minleadtime", entity.minleadtime); row.SetField("minleadrec", entity.minleadrec); row.SetField("minleadlev", entity.minleadlev); row.SetField("safewhsemid", entity.safewhsemid); row.SetField("whsedaysrec", entity.whsedaysrec); row.SetField("whsedayslev", entity.whsedayslev); row.SetField("safewhsemin", entity.safewhsemin); row.SetField("whsepctrec", entity.whsepctrec); row.SetField("whsepctlev", entity.whsepctlev); row.SetField("safevendmid", entity.safevendmid); row.SetField("venddaysrec", entity.venddaysrec); row.SetField("venddayslev", entity.venddayslev); row.SetField("safevendmin", entity.safevendmin); row.SetField("vendpctrec", entity.vendpctrec); row.SetField("vendpctlev", entity.vendpctlev); row.SetField("minsafety", entity.minsafety); row.SetField("minsaferec", entity.minsaferec); row.SetField("minsafelev", entity.minsafelev); row.SetField("maxsafety", entity.maxsafety); row.SetField("maxsaferec", entity.maxsaferec); row.SetField("maxsafelev", entity.maxsafelev); row.SetField("safetymonths", entity.safetymonths); row.SetField("safemthsrec", entity.safemthsrec); row.SetField("safemthslev", entity.safemthslev); row.SetField("safetymajority", entity.safetymajority); row.SetField("safemajorrec", entity.safemajorrec); row.SetField("safemajorlev", entity.safemajorlev); row.SetField("safetyrcpts", entity.safetyrcpts); row.SetField("rcptsrec", entity.rcptsrec); row.SetField("rcptslev", entity.rcptslev); row.SetField("safevendmax", entity.safevendmax); row.SetField("safevendmaxrec", entity.safevendmaxrec); row.SetField("safevendmaxlev", entity.safevendmaxlev); row.SetField("safewhsemax", entity.safewhsemax); row.SetField("safewhsemaxrec", entity.safewhsemaxrec); row.SetField("safewhsemaxlev", entity.safewhsemaxlev); row.SetField("minleadtimewhse", entity.minleadtimewhse); row.SetField("minleadtimewhserec", entity.minleadtimewhserec); row.SetField("minleadtimewhselev", entity.minleadtimewhselev); row.SetField("maxleadtimewhse", entity.maxleadtimewhse); row.SetField("maxleadtimewhserec", entity.maxleadtimewhserec); row.SetField("maxleadtimewhselev", entity.maxleadtimewhselev); row.SetField("minsafevendty", entity.minsafevendty); row.SetField("maxsafevendty", entity.maxsafevendty); row.SetField("midsafevendty", entity.midsafevendty); row.SetField("minvendtyrec", entity.minvendtyrec); row.SetField("minvendtylev", entity.minvendtylev); row.SetField("maxvendtyrec", entity.maxvendtyrec); row.SetField("maxvendtylev", entity.maxvendtylev); row.SetField("midvendtyrec", entity.midvendtyrec); row.SetField("midvendtylev", entity.midvendtylev); row.SetField("minsafewhsety", entity.minsafewhsety); row.SetField("maxsafewhsety", entity.maxsafewhsety); row.SetField("midsafewhsety", entity.midsafewhsety); row.SetField("minwhsetyrec", entity.minwhsetyrec); row.SetField("minwhsetylev", entity.minwhsetylev); row.SetField("maxwhsetyrec", entity.maxwhsetyrec); row.SetField("maxwhsetylev", entity.maxwhsetylev); row.SetField("midwhsetyrec", entity.midwhsetyrec); row.SetField("midwhsetylev", entity.midwhsetylev); row.SetField("userfield", entity.userfield); }
public static Icsrdetailranks BuildIcsrdetailranksFromRow(DataRow row) { Icsrdetailranks entity = new Icsrdetailranks(); entity.ranklevel = row.IsNull("ranklevel") ? string.Empty : row.Field <string>("ranklevel"); entity.rankpct = row.IsNull("rankpct") ? decimal.Zero : row.Field <decimal>("rankpct"); entity.rankpctrec = row.IsNull("rankpctrec") ? string.Empty : row.Field <string>("rankpctrec"); entity.rankpctlev = row.IsNull("rankpctlev") ? decimal.Zero : row.Field <decimal>("rankpctlev"); entity.minhits = row.IsNull("minhits") ? 0 : row.Field <int>("minhits"); entity.minhitsrec = row.IsNull("minhitsrec") ? string.Empty : row.Field <string>("minhitsrec"); entity.minhitslev = row.IsNull("minhitslev") ? 0 : row.Field <int>("minhitslev"); entity.usgmths = row.IsNull("usgmths") ? 0 : row.Field <int>("usgmths"); entity.usgmthsrec = row.IsNull("usgmthsrec") ? string.Empty : row.Field <string>("usgmthsrec"); entity.usgmthslev = row.IsNull("usgmthslev") ? 0 : row.Field <int>("usgmthslev"); entity.maxleadtime = row.IsNull("maxleadtime") ? 0 : row.Field <int>("maxleadtime"); entity.maxleadrec = row.IsNull("maxleadrec") ? string.Empty : row.Field <string>("maxleadrec"); entity.maxleadlev = row.IsNull("maxleadlev") ? 0 : row.Field <int>("maxleadlev"); entity.minleadtime = row.IsNull("minleadtime") ? 0 : row.Field <int>("minleadtime"); entity.minleadrec = row.IsNull("minleadrec") ? string.Empty : row.Field <string>("minleadrec"); entity.minleadlev = row.IsNull("minleadlev") ? 0 : row.Field <int>("minleadlev"); entity.safewhsemid = row.IsNull("safewhsemid") ? decimal.Zero : row.Field <decimal>("safewhsemid"); entity.whsedaysrec = row.IsNull("whsedaysrec") ? string.Empty : row.Field <string>("whsedaysrec"); entity.whsedayslev = row.IsNull("whsedayslev") ? decimal.Zero : row.Field <decimal>("whsedayslev"); entity.safewhsemin = row.IsNull("safewhsemin") ? decimal.Zero : row.Field <decimal>("safewhsemin"); entity.whsepctrec = row.IsNull("whsepctrec") ? string.Empty : row.Field <string>("whsepctrec"); entity.whsepctlev = row.IsNull("whsepctlev") ? decimal.Zero : row.Field <decimal>("whsepctlev"); entity.safevendmid = row.IsNull("safevendmid") ? decimal.Zero : row.Field <decimal>("safevendmid"); entity.venddaysrec = row.IsNull("venddaysrec") ? string.Empty : row.Field <string>("venddaysrec"); entity.venddayslev = row.IsNull("venddayslev") ? decimal.Zero : row.Field <decimal>("venddayslev"); entity.safevendmin = row.IsNull("safevendmin") ? decimal.Zero : row.Field <decimal>("safevendmin"); entity.vendpctrec = row.IsNull("vendpctrec") ? string.Empty : row.Field <string>("vendpctrec"); entity.vendpctlev = row.IsNull("vendpctlev") ? decimal.Zero : row.Field <decimal>("vendpctlev"); entity.minsafety = row.IsNull("minsafety") ? decimal.Zero : row.Field <decimal>("minsafety"); entity.minsaferec = row.IsNull("minsaferec") ? string.Empty : row.Field <string>("minsaferec"); entity.minsafelev = row.IsNull("minsafelev") ? decimal.Zero : row.Field <decimal>("minsafelev"); entity.maxsafety = row.IsNull("maxsafety") ? decimal.Zero : row.Field <decimal>("maxsafety"); entity.maxsaferec = row.IsNull("maxsaferec") ? string.Empty : row.Field <string>("maxsaferec"); entity.maxsafelev = row.IsNull("maxsafelev") ? decimal.Zero : row.Field <decimal>("maxsafelev"); entity.safetymonths = row.IsNull("safetymonths") ? 0 : row.Field <int>("safetymonths"); entity.safemthsrec = row.IsNull("safemthsrec") ? string.Empty : row.Field <string>("safemthsrec"); entity.safemthslev = row.IsNull("safemthslev") ? 0 : row.Field <int>("safemthslev"); entity.safetymajority = row.IsNull("safetymajority") ? 0 : row.Field <int>("safetymajority"); entity.safemajorrec = row.IsNull("safemajorrec") ? string.Empty : row.Field <string>("safemajorrec"); entity.safemajorlev = row.IsNull("safemajorlev") ? 0 : row.Field <int>("safemajorlev"); entity.safetyrcpts = row.IsNull("safetyrcpts") ? 0 : row.Field <int>("safetyrcpts"); entity.rcptsrec = row.IsNull("rcptsrec") ? string.Empty : row.Field <string>("rcptsrec"); entity.rcptslev = row.IsNull("rcptslev") ? 0 : row.Field <int>("rcptslev"); entity.safevendmax = row.IsNull("safevendmax") ? decimal.Zero : row.Field <decimal>("safevendmax"); entity.safevendmaxrec = row.IsNull("safevendmaxrec") ? string.Empty : row.Field <string>("safevendmaxrec"); entity.safevendmaxlev = row.IsNull("safevendmaxlev") ? decimal.Zero : row.Field <decimal>("safevendmaxlev"); entity.safewhsemax = row.IsNull("safewhsemax") ? 0 : row.Field <int>("safewhsemax"); entity.safewhsemaxrec = row.IsNull("safewhsemaxrec") ? string.Empty : row.Field <string>("safewhsemaxrec"); entity.safewhsemaxlev = row.IsNull("safewhsemaxlev") ? 0 : row.Field <int>("safewhsemaxlev"); entity.minleadtimewhse = row.IsNull("minleadtimewhse") ? 0 : row.Field <int>("minleadtimewhse"); entity.minleadtimewhserec = row.IsNull("minleadtimewhserec") ? string.Empty : row.Field <string>("minleadtimewhserec"); entity.minleadtimewhselev = row.IsNull("minleadtimewhselev") ? 0 : row.Field <int>("minleadtimewhselev"); entity.maxleadtimewhse = row.IsNull("maxleadtimewhse") ? 0 : row.Field <int>("maxleadtimewhse"); entity.maxleadtimewhserec = row.IsNull("maxleadtimewhserec") ? string.Empty : row.Field <string>("maxleadtimewhserec"); entity.maxleadtimewhselev = row.IsNull("maxleadtimewhselev") ? 0 : row.Field <int>("maxleadtimewhselev"); entity.minsafevendty = row.IsNull("minsafevendty") ? string.Empty : row.Field <string>("minsafevendty"); entity.maxsafevendty = row.IsNull("maxsafevendty") ? string.Empty : row.Field <string>("maxsafevendty"); entity.midsafevendty = row.IsNull("midsafevendty") ? string.Empty : row.Field <string>("midsafevendty"); entity.minvendtyrec = row.IsNull("minvendtyrec") ? string.Empty : row.Field <string>("minvendtyrec"); entity.minvendtylev = row.IsNull("minvendtylev") ? string.Empty : row.Field <string>("minvendtylev"); entity.maxvendtyrec = row.IsNull("maxvendtyrec") ? string.Empty : row.Field <string>("maxvendtyrec"); entity.maxvendtylev = row.IsNull("maxvendtylev") ? string.Empty : row.Field <string>("maxvendtylev"); entity.midvendtyrec = row.IsNull("midvendtyrec") ? string.Empty : row.Field <string>("midvendtyrec"); entity.midvendtylev = row.IsNull("midvendtylev") ? string.Empty : row.Field <string>("midvendtylev"); entity.minsafewhsety = row.IsNull("minsafewhsety") ? string.Empty : row.Field <string>("minsafewhsety"); entity.maxsafewhsety = row.IsNull("maxsafewhsety") ? string.Empty : row.Field <string>("maxsafewhsety"); entity.midsafewhsety = row.IsNull("midsafewhsety") ? string.Empty : row.Field <string>("midsafewhsety"); entity.minwhsetyrec = row.IsNull("minwhsetyrec") ? string.Empty : row.Field <string>("minwhsetyrec"); entity.minwhsetylev = row.IsNull("minwhsetylev") ? string.Empty : row.Field <string>("minwhsetylev"); entity.maxwhsetyrec = row.IsNull("maxwhsetyrec") ? string.Empty : row.Field <string>("maxwhsetyrec"); entity.maxwhsetylev = row.IsNull("maxwhsetylev") ? string.Empty : row.Field <string>("maxwhsetylev"); entity.midwhsetyrec = row.IsNull("midwhsetyrec") ? string.Empty : row.Field <string>("midwhsetyrec"); entity.midwhsetylev = row.IsNull("midwhsetylev") ? string.Empty : row.Field <string>("midwhsetylev"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }