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);
}