public UniversalEntity RetrieveDiameters(SqlCommand command) { UniversalEntity ue = new UniversalEntity(); createConnection(); command.Connection = sq; try { ArrayList al; dr = command.ExecuteReader(); while (dr.Read()) { al = new ArrayList(); if (!dr.IsDBNull(dr.GetOrdinal("Diameter"))) { al.Add(Utilities.ConvertToInt(dr["Diameter"].ToString())); } ue.Add(al); } } catch (System.Data.SqlClient.SqlException ex) { } finally { closeConnection(); } return(ue); }
public UniversalEntity RetrieveUserLocationBySurname(SqlCommand command) { UniversalEntity ue = new UniversalEntity(); createConnection(); command.Connection = sq; try { string t = string.Empty; dr = command.ExecuteReader(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("UserLocation"))) { t = dr["UserLocation"].ToString(); } ue.Add(t); } } catch (System.Data.SqlClient.SqlException ex) { } finally { closeConnection(); } return(ue); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (dr.Read()) { UOrder ent = new UOrder(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (dr.Read()) { AlternativeOrderDetails ent = new AlternativeOrderDetails(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (!dr.Read()) { FAbonent2018 ent = new FAbonent2018(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
public UniversalEntity RetrieveFActByOrderID5HighRub(SqlCommand command) { UniversalEntity ue = new UniversalEntity(); createConnection(); command.Connection = sq; try { ArrayList al; dr = command.ExecuteReader(); while (dr.Read()) { al = new ArrayList(); if (!dr.IsDBNull(dr.GetOrdinal("diameter"))) { al.Add(Utilities.ConvertToInt(dr["diameter"].ToString())); } /*if (!dr.IsDBNull(dr.GetOrdinal("Price"))) * al.Add(dr["Price"].ToString());*/ if (!dr.IsDBNull(dr.GetOrdinal("PriceRub"))) { al.Add(dr["PriceRub"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("summa"))) { al.Add(dr["summa"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ocount"))) { al.Add(dr["ocount"].ToString()); } al.Add(1); ue.Add(al); } } catch (System.Data.SqlClient.SqlException ex) { } finally { closeConnection(); } return(ue); }
public UniversalEntity RetrieveReplacementActBySOrderID5LowStored(SqlCommand command) { UniversalEntity ue = new UniversalEntity(); createConnection(); command.Connection = sq; try { ArrayList al; dr = command.ExecuteReader(); while (dr.Read()) { al = new ArrayList(); if (!dr.IsDBNull(dr.GetOrdinal("diameter"))) { al.Add(Utilities.ConvertToInt(dr["diameter"].ToString())); } if (!dr.IsDBNull(dr.GetOrdinal("nom_zavod"))) { al.Add(dr["nom_zavod"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("StartValue"))) { al.Add(dr["StartValue"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ReplacementPrice"))) { al.Add(dr["ReplacementPrice"].ToString()); } /*if (!dr.IsDBNull(dr.GetOrdinal("PriceRub"))) * al.Add(dr["PriceRub"].ToString());*/ al.Add(1); ue.Add(al); } } catch (System.Data.SqlClient.SqlException ex) { } finally { closeConnection(); } return(ue); }
public UniversalEntity GetRateByDateAndWP(SqlCommand command) { UniversalEntity ue = new UniversalEntity(); createConnection(); command.Connection = sq; try { ArrayList al; dr = command.ExecuteReader(); while (dr.Read()) { al = new ArrayList(); if (!dr.IsDBNull(dr.GetOrdinal("R"))) { al.Add(Utilities.ConvertToDouble(dr["R"].ToString())); } /* if (!dr.IsDBNull(dr.GetOrdinal("d"))) * al.Add(Utilities.ConvertToInt(dr["d"].ToString())); * * if (!dr.IsDBNull(dr.GetOrdinal("DateIn"))) * al.Add(Convert.ToDateTime(dr["DateIn"]));*/ ue.Add(al); } } catch (System.Data.SqlClient.SqlException ex) { } finally { closeConnection(); } return(ue); }
public UniversalEntity RetrieveAllSumActBySOrderIDHigh(SqlCommand command) { UniversalEntity ue = new UniversalEntity(); createConnection(); command.Connection = sq; try { ArrayList al; dr = command.ExecuteReader(); while (dr.Read()) { al = new ArrayList(); if (!dr.IsDBNull(dr.GetOrdinal("diameter"))) { al.Add(Utilities.ConvertToInt(dr["diameter"].ToString())); //0 } /*if (!dr.IsDBNull(dr.GetOrdinal("Price"))) * al.Add(dr["Price"].ToString());*/ if (!dr.IsDBNull(dr.GetOrdinal("DismantlingPrice"))) //1 { al.Add(dr["DismantlingPrice"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("InstallPrice"))) //2 { al.Add(dr["InstallPrice"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("PhysicalPrice"))) //3 { al.Add(dr["PhysicalPrice"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("summadis"))) //4 { al.Add(dr["summadis"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("summainst"))) //5 { al.Add(dr["summainst"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("sumphys"))) //6 { al.Add(dr["sumphys"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ocdis"))) //7 { al.Add(dr["ocdis"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ocinst"))) //8 { al.Add(dr["ocinst"].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ocphys"))) //9 { al.Add(dr["ocphys"].ToString()); } al.Add(1); ue.Add(al); } } catch (System.Data.SqlClient.SqlException ex) { } finally { closeConnection(); } return(ue); }