/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromOtittracktotals(ref DataRow row, Otittracktotals entity) { row.SetField("trackno", entity.trackno); row.SetField("addondesc-1", entity.addondesc1); row.SetField("addonamt-1", entity.addonamt1); row.SetField("addontype-1", entity.addontype1); row.SetField("addonnet-1", entity.addonnet1); row.SetField("addondesc-2", entity.addondesc2); row.SetField("addonamt-2", entity.addonamt2); row.SetField("addontype-2", entity.addontype2); row.SetField("addonnet-2", entity.addonnet2); row.SetField("addondesc-3", entity.addondesc3); row.SetField("addonamt-3", entity.addonamt3); row.SetField("addontype-3", entity.addontype3); row.SetField("addonnet-3", entity.addonnet3); row.SetField("addondesc-4", entity.addondesc4); row.SetField("addonamt-4", entity.addonamt4); row.SetField("addontype-4", entity.addontype4); row.SetField("addonnet-4", entity.addonnet4); row.SetField("estprodstdt", entity.estprodstdt); row.SetField("revprodstdt", entity.revprodstdt); row.SetField("actprodstdt", entity.actprodstdt); row.SetField("estcompdt", entity.estcompdt); row.SetField("revcompdt", entity.revcompdt); row.SetField("actcompdt", entity.actcompdt); row.SetField("estdeptdt", entity.estdeptdt); row.SetField("revdeptdt", entity.revdeptdt); row.SetField("actdeptdt", entity.actdeptdt); row.SetField("estdockarrdt", entity.estdockarrdt); row.SetField("revdockarrdt", entity.revdockarrdt); row.SetField("actdockarrdt", entity.actdockarrdt); row.SetField("estdockreddt", entity.estdockreddt); row.SetField("revdockreddt", entity.revdockreddt); row.SetField("actdockreddt", entity.actdockreddt); row.SetField("estdockdemudt", entity.estdockdemudt); row.SetField("revdemudt", entity.revdemudt); row.SetField("actdockdemudt", entity.actdockdemudt); row.SetField("estatwhsedt", entity.estatwhsedt); row.SetField("revatwhsedt", entity.revatwhsedt); row.SetField("actatwhsedt", entity.actatwhsedt); row.SetField("estlastfreedt", entity.estlastfreedt); row.SetField("revlastfreedt", entity.revlastfreedt); row.SetField("actlastfreedt", entity.actlastfreedt); row.SetField("estwhseunldt", entity.estwhseunldt); row.SetField("revwhseunldt", entity.revwhseunldt); row.SetField("actwhseunldt", entity.actwhseunldt); row.SetField("estemptydt", entity.estemptydt); row.SetField("revemptydt", entity.revemptydt); row.SetField("actemptydt", entity.actemptydt); row.SetField("estretdt", entity.estretdt); row.SetField("revretdt", entity.revretdt); row.SetField("actretdt", entity.actretdt); row.SetField("seecostfl", entity.seecostfl); row.SetField("additaddonallowed", entity.additaddonallowed); row.SetField("additaddonamt", entity.additaddonamt); row.SetField("totqtyord", entity.totqtyord); row.SetField("totcubes", entity.totcubes); row.SetField("totlineamt", entity.totlineamt); row.SetField("totweight", entity.totweight); row.SetField("userfield", entity.userfield); }
public static Otittracktotals BuildOtittracktotalsFromRow(DataRow row) { Otittracktotals entity = new Otittracktotals(); entity.trackno = row.IsNull("trackno") ? 0 : row.Field <int>("trackno"); entity.addondesc1 = row.IsNull("addondesc-1") ? string.Empty : row.Field <string>("addondesc-1"); entity.addonamt1 = row.IsNull("addonamt-1") ? decimal.Zero : row.Field <decimal>("addonamt-1"); entity.addontype1 = row.IsNull("addontype-1") ? string.Empty : row.Field <string>("addontype-1"); entity.addonnet1 = row.IsNull("addonnet-1") ? decimal.Zero : row.Field <decimal>("addonnet-1"); entity.addondesc2 = row.IsNull("addondesc-2") ? string.Empty : row.Field <string>("addondesc-2"); entity.addonamt2 = row.IsNull("addonamt-2") ? decimal.Zero : row.Field <decimal>("addonamt-2"); entity.addontype2 = row.IsNull("addontype-2") ? string.Empty : row.Field <string>("addontype-2"); entity.addonnet2 = row.IsNull("addonnet-2") ? decimal.Zero : row.Field <decimal>("addonnet-2"); entity.addondesc3 = row.IsNull("addondesc-3") ? string.Empty : row.Field <string>("addondesc-3"); entity.addonamt3 = row.IsNull("addonamt-3") ? decimal.Zero : row.Field <decimal>("addonamt-3"); entity.addontype3 = row.IsNull("addontype-3") ? string.Empty : row.Field <string>("addontype-3"); entity.addonnet3 = row.IsNull("addonnet-3") ? decimal.Zero : row.Field <decimal>("addonnet-3"); entity.addondesc4 = row.IsNull("addondesc-4") ? string.Empty : row.Field <string>("addondesc-4"); entity.addonamt4 = row.IsNull("addonamt-4") ? decimal.Zero : row.Field <decimal>("addonamt-4"); entity.addontype4 = row.IsNull("addontype-4") ? string.Empty : row.Field <string>("addontype-4"); entity.addonnet4 = row.IsNull("addonnet-4") ? decimal.Zero : row.Field <decimal>("addonnet-4"); entity.estprodstdt = row.Field <DateTime?>("estprodstdt"); entity.revprodstdt = row.Field <DateTime?>("revprodstdt"); entity.actprodstdt = row.Field <DateTime?>("actprodstdt"); entity.estcompdt = row.Field <DateTime?>("estcompdt"); entity.revcompdt = row.Field <DateTime?>("revcompdt"); entity.actcompdt = row.Field <DateTime?>("actcompdt"); entity.estdeptdt = row.Field <DateTime?>("estdeptdt"); entity.revdeptdt = row.Field <DateTime?>("revdeptdt"); entity.actdeptdt = row.Field <DateTime?>("actdeptdt"); entity.estdockarrdt = row.Field <DateTime?>("estdockarrdt"); entity.revdockarrdt = row.Field <DateTime?>("revdockarrdt"); entity.actdockarrdt = row.Field <DateTime?>("actdockarrdt"); entity.estdockreddt = row.Field <DateTime?>("estdockreddt"); entity.revdockreddt = row.Field <DateTime?>("revdockreddt"); entity.actdockreddt = row.Field <DateTime?>("actdockreddt"); entity.estdockdemudt = row.Field <DateTime?>("estdockdemudt"); entity.revdemudt = row.Field <DateTime?>("revdemudt"); entity.actdockdemudt = row.Field <DateTime?>("actdockdemudt"); entity.estatwhsedt = row.Field <DateTime?>("estatwhsedt"); entity.revatwhsedt = row.Field <DateTime?>("revatwhsedt"); entity.actatwhsedt = row.Field <DateTime?>("actatwhsedt"); entity.estlastfreedt = row.Field <DateTime?>("estlastfreedt"); entity.revlastfreedt = row.Field <DateTime?>("revlastfreedt"); entity.actlastfreedt = row.Field <DateTime?>("actlastfreedt"); entity.estwhseunldt = row.Field <DateTime?>("estwhseunldt"); entity.revwhseunldt = row.Field <DateTime?>("revwhseunldt"); entity.actwhseunldt = row.Field <DateTime?>("actwhseunldt"); entity.estemptydt = row.Field <DateTime?>("estemptydt"); entity.revemptydt = row.Field <DateTime?>("revemptydt"); entity.actemptydt = row.Field <DateTime?>("actemptydt"); entity.estretdt = row.Field <DateTime?>("estretdt"); entity.revretdt = row.Field <DateTime?>("revretdt"); entity.actretdt = row.Field <DateTime?>("actretdt"); entity.seecostfl = row.Field <bool>("seecostfl"); entity.additaddonallowed = row.Field <bool>("additaddonallowed"); entity.additaddonamt = row.IsNull("additaddonamt") ? decimal.Zero : row.Field <decimal>("additaddonamt"); entity.totqtyord = row.IsNull("totqtyord") ? decimal.Zero : row.Field <decimal>("totqtyord"); entity.totcubes = row.IsNull("totcubes") ? decimal.Zero : row.Field <decimal>("totcubes"); entity.totlineamt = row.IsNull("totlineamt") ? decimal.Zero : row.Field <decimal>("totlineamt"); entity.totweight = row.IsNull("totweight") ? decimal.Zero : row.Field <decimal>("totweight"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }