public static ReportEntity Create(ReportEntity report) { //Place your Business logic here report.id = report.id; return(report); }
public IEnumerable <DomainEntity.ReportEntity> GetReport(DomainEntity.ReportEntity entity) { try { var reportList = new List <DomainEntity.ReportEntity>(); string query = String.Empty; using (JDAContext) { if (DBOPEN(Function.getConnectionString(entity.login_entity), JDAContext)) { if (entity.pONumber != 0) { query = " AND b.ASAUTO in ('S','C') AND a.PONUMB = " + entity.pONumber + " "; } else { if (entity.storeNumber != 0 && entity.vendorCode == 0) { query = " AND b.ASAUTO in ('S','C') AND c.STRNUM = " + entity.storeNumber + " AND d.POSDAT BETWEEN " + entity.receivingDate + " AND " + entity.cancelDate + ""; } if (entity.storeNumber == 0 && entity.vendorCode != 0) { query = " AND b.ASAUTO in ('S','C') AND b.ASNUM = " + entity.vendorCode + " AND d.POSDAT BETWEEN " + entity.receivingDate + " AND " + entity.cancelDate + ""; } if (entity.storeNumber != 0 && entity.vendorCode != 0) { query = " AND b.ASAUTO in ('S','C') AND b.ASNUM = " + entity.vendorCode + " AND C.STRNUM = " + entity.storeNumber + " AND d.POSDAT BETWEEN " + entity.receivingDate + " AND " + entity.cancelDate + ""; } } string querystring = "SELECT " + "a.PONUMB, " + "a.POMRCV, " + "case when b.ASAUTO = 'C' then 'CROSS DOCK' else 'STOCK OPERATION' end as ASAUTO , " + "a.POLOC, " + "c.STRNAM, " + "a.POVNUM, " + "b.ASNAME, " + "d.POSDAT, " + "d.POCDAT, " + "f.IVPLTI, " + "f.IVPLHI, " + "case when b.ASAUTO = 'C' then 'X-DOCK' else 'STOCK OP' end as LOCATION, " + "e.INUMBR, " + "f.IDESCR, " + "g.IUPC, " + "e.POMUM, " + "e.POMQTY/e.POMPK as ORDERQTY " + "FROM " + entity.login_entity.dBname + ".POMRCH a " + "INNER JOIN " + entity.login_entity.dBname + ".APSUPP b ON a.POVNUM = b.ASNUM " + "INNER JOIN " + entity.login_entity.dBname + ".TBLSTR c ON a.POLOC = c.STRNUM " + "INNER JOIN " + entity.login_entity.dBname + ".POMHDR d ON a.PONUMB = d.PONUMB " + "INNER JOIN " + entity.login_entity.dBname + ".POMRCD e ON a.PONUMB = e.PONUMB " + "INNER JOIN " + entity.login_entity.dBname + ".INVMST f ON e.INUMBR = f.INUMBR " + "INNER JOIN " + entity.login_entity.dBname + ".INVUPC g ON e.INUMBR = g.INUMBR " + "WHERE a.POSTAT = '3' and d.POSTAT = '3'" + query; var JDACommand = new OdbcCommand(querystring, JDAContext); JDACommand.CommandTimeout = 0; var JDAReader = JDACommand.ExecuteReader(); while (JDAReader.Read()) { var reportDetails = new DomainEntity.ReportEntity(); reportDetails.pONumber = JDAReader.GetInt32(JDAReader.GetOrdinal("PONUMB")); reportDetails.rANumber = JDAReader.GetInt32(JDAReader.GetOrdinal("POMRCV")); reportDetails.aSAuto = JDAReader.GetString(JDAReader.GetOrdinal("ASAUTO")); reportDetails.storeNumber = JDAReader.GetInt32(JDAReader.GetOrdinal("POLOC")); reportDetails.storeName = JDAReader.GetString(JDAReader.GetOrdinal("STRNAM")); reportDetails.vendorCode = JDAReader.GetInt32(JDAReader.GetOrdinal("POVNUM")); reportDetails.vendorName = JDAReader.GetString(JDAReader.GetOrdinal("ASNAME")); reportDetails.receivingDate = JDAReader.GetString(JDAReader.GetOrdinal("POSDAT")); reportDetails.cancelDate = JDAReader.GetString(JDAReader.GetOrdinal("POCDAT")); reportDetails.ti = JDAReader.GetInt32(JDAReader.GetOrdinal("IVPLTI")); reportDetails.hi = JDAReader.GetInt32(JDAReader.GetOrdinal("IVPLHI")); reportDetails.Location = JDAReader.GetString(JDAReader.GetOrdinal("LOCATION")); reportDetails.iNumber = JDAReader.GetInt32(JDAReader.GetOrdinal("INUMBR")); reportDetails.iDecription = JDAReader.GetString(JDAReader.GetOrdinal("IDESCR")); reportDetails.upc = JDAReader.GetString(JDAReader.GetOrdinal("IUPC")); reportDetails.um = JDAReader.GetString(JDAReader.GetOrdinal("POMUM")); reportDetails.orderQty = JDAReader.GetInt32(JDAReader.GetOrdinal("ORDERQTY")); reportList.Add(reportDetails); } JDAReader.Close(); JDACommand.Dispose(); } } return(reportList); } catch (Exception ex) { throw ex; } finally { JDAContext.Close(); } }
public void Add(DomainEntity.ReportEntity entity) { _rALDbContext.ReportTables.Add(_mapper.Map <DomainEntity.ReportEntity, LoginData.ReportTable>(entity)); }
public void Update(DomainEntity.ReportEntity entity) { throw new NotImplementedException(); }