private static PCCIHDP PCCIHDPFromRow(DataRow dr) { PCCIHDP header = new PCCIHDP(); header.PriceChangeNumber = Convert.ToInt32(dr["CIPCNO"]); header.PriceChangeType = dr["CIPCTP"].ToString(); header.RepriceOrMarkdown = dr["CIRORM"].ToString(); header.CreationType = dr["CICRTP"]?.ToString(); header.Status = dr["CIST"]?.ToString(); header.ApprovedDateTime = DateTimeFromMerretStrings(dr["CIAPPD"].ToString(), dr["CIAPPT"].ToString()); header.BaseStartDateTime = DateTimeFromMerretStrings(dr["CISTDT"].ToString(), dr["CISTTM"].ToString()); header.DeparmentNumber = dr["CIDEPT"]?.ToString(); header.CountryCode = dr["CICTRY"]?.ToString(); header.ZoneCurrencyCode = dr["CIZCCY"]?.ToString(); header.CreationType = dr["CICRTP"]?.ToString(); header.Status = dr["CIST"]?.ToString(); header.DeparmentNumber = dr["CIDEPT"]?.ToString(); header.CountryCode = dr["CICTRY"]?.ToString(); header.ZoneCurrencyCode = dr["CIZCCY"]?.ToString(); header.StorePriceZone = (decimal)dr["CIPZON"]; header.DateCreated = DateTimeFromMerretStrings(dr["CIDTCT"].ToString(), "000000"); header.MaintainedDateTime = DateTimeFromMerretStrings(dr["CIMNTD"].ToString(), dr["CIMNTT"].ToString()); header.UpdateDateTime = DateTimeFromMerretStrings(dr["CIUDAT"].ToString(), dr["CIUTIM"].ToString()); return(header); }
public static List <PCCIHDP> PCCIHDPFromDataTable(DataTable dt) { List <PCCIHDP> rows = new List <PCCIHDP>(); PCCIHDP row = null; foreach (DataRow dr in dt.Rows) { row = PCCIHDPFromRow(dr); rows.Add(row); } return(rows); }