private MeCreditcardHistoryInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
MeCreditcardHistoryInfo info = new MeCreditcardHistoryInfo();
info.Memberid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Creditcardid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Balance = dar.IsDBNull(++i) ? 0 : dar.GetFloat(i);
info.Amount = dar.IsDBNull(++i) ? 0 : dar.GetFloat(i);
info.Addorsub = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i);
info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public static float GetFloat(System.Data.IDataReader rdr, string Column, float NullValue)
{
if (rdr[Column] != DBNull.Value)
{
return(rdr.GetFloat(rdr.GetOrdinal(Column)));
}
else
{
return(NullValue);
}
}
//Obtiene el tiempo total dedicado a una actividad concreta a lo largo de la semana
private float ObtenerTiempoTotal(string actividad, int semana)
{
float tiempo = 0;
System.Data.IDataReader reader = estadisticasDB.TiempoTotalActividad(actividad, semana, anno);
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
tiempo = reader.GetFloat(0);
}
}
return(tiempo);
}
//Suma el tiempo de esta ultima sesion a la categoria elegida por el usuario
private void GuardarTiempoCategoria()
{
float minutos = Tempo_UltimaEscena.GetMinutos(); //tiempo que se ha estado trabajando esta ronda
//Recuperar de la bd los minutos almacenados para hoy de esta actividad
float minutosGuardados = 0;
System.Data.IDataReader reader = estadisticasDB.BuscarTiempoActividad(categoria, fechaActual);
while (reader.Read())
{
minutosGuardados = reader.GetFloat(0);
}
//Sumar minutos y guardarlos
minutos += minutosGuardados;
estadisticasDB.GuardarTiempoActividad(categoria, minutos, fechaActual);
estadisticasDB.close();
}
//Mostrar el tiempo que se ha utilizado el temporizador en el dia
private void ActualizarTiempoTotal()
{
//Recuperar de la bd el tiempo de trabajo almacenado hoy
EstadisticasDB estadisticasDB = new EstadisticasDB(); //Abrir conexion a la bd
string fechaActual = DateTime.Today.Date.ToShortDateString();
float tiempoHoy = 0.0f;
System.Data.IDataReader reader = estadisticasDB.TiempoTotalActividadHoy(fechaActual); //Realizar consulta a la bd
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
tiempoHoy = reader.GetFloat(0);
}
}
int horas = (int)(tiempoHoy / 60.0f);
int minutos = (int)(tiempoHoy % 60.0f);
tiempoTotal.text = horas.ToString("D2") + ":" + minutos.ToString("D2");
estadisticasDB.close(); //Cerrar la conexion a la bd
}
private MeCreditcardInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
MeCreditcardInfo info = new MeCreditcardInfo();
info.Firstname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Lastname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Cardnumber = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Cardtype = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Expirationmonth = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Expirationyear = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.City = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.State = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Zipcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Memberid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Balance = dar.IsDBNull(++i) ? 0 : dar.GetFloat(i);
info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i);
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private CartitemInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
CartitemInfo info = new CartitemInfo();
info.CartID = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.ProductID = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Productname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Quantity = dar.IsDBNull(++i) ? -1 : dar.GetInt32(i);
info.Amount = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i));
info.TemporaryID = dar.IsDBNull(++i) ? 0 : long.Parse(dar.GetValue(i).ToString());
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private ProductInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
ProductInfo info = new ProductInfo();
info.Code = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Introduce = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Features = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Filepreview = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Cid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Cname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i);
info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i);
info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Timecreate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Provider = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Advertise = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Price = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i));
info.Pricealter = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i), 2);
info.Allowcomment = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Album = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Relateditem = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Relatednews = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i);
info.lCategory = (new CCategory(LANG)).Wcmm_Getlist_ofiid(info.Id, Webcmm.Id.Product);
info.lCategoryattr = (new CCategoryattr(LANG)).Wcmm_Getlist_ofiid(info.Id, Webcmm.Id.Product);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
private CartInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
CartInfo info = new CartInfo();
info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i);
info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i);
info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Timecomplete = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Lang = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Memberid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Membername = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Paymenttype = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Amount = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i));
info.Shippingfee = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i));
info.Discountfee = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i));
info.Couponcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Checkout = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_Address2 = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_City = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_District = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_Nationalid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Shipping_Zipcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Shipping_Nationalname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_Address2 = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_City = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_District = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_Nationalid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Billing_Zipcode = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Billing_Nationalname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public static Single Single(System.Data.IDataReader reader, MapPoint mapPoint, Single defaultValue = 0)
{
try
{
return(mapPoint.IsInResultSet() && !reader.IsDBNull(mapPoint.Index) ? reader.GetFloat(mapPoint.Index) : defaultValue);
}
catch (Exception)
{
throw;
}
}
public static float?GetFloat(System.Data.IDataReader rdr, string Column)
{
return(rdr [Column] != DBNull.Value ? (float?)rdr.GetFloat(rdr.GetOrdinal(Column)) : null);
}
public void SetFromReader <T>(T obj, System.Data.IDataReader reader, Action <T, string, object> setMethod)
where T : class
{
if (!reader.IsDBNull(this.Index))
{
switch (this.SqlType)
{
case System.Data.SqlDbType.BigInt:
setMethod(obj, FieldName, reader.GetInt64(this.Index));
break;
case System.Data.SqlDbType.Image:
case System.Data.SqlDbType.VarBinary:
case System.Data.SqlDbType.Binary:
long size = reader.GetBytes(this.Index, 0, null, 0, 0);
byte[] values = new byte[size];
int bufferSize = 1024;
long bytesRead = 0;
int curPos = 0;
while (bytesRead < size)
{
bytesRead += reader.GetBytes(this.Index, curPos, values, curPos, bufferSize);
curPos += bufferSize;
}
setMethod(obj, FieldName, values);
break;
case System.Data.SqlDbType.Bit:
setMethod(obj, FieldName, reader.GetBoolean(this.Index));
break;
case System.Data.SqlDbType.Char:
setMethod(obj, FieldName, reader.GetChar(this.Index));
break;
case System.Data.SqlDbType.SmallDateTime:
case System.Data.SqlDbType.Date:
case System.Data.SqlDbType.DateTime:
case System.Data.SqlDbType.DateTime2:
setMethod(obj, FieldName, reader.GetDateTime(this.Index));
break;
case System.Data.SqlDbType.SmallMoney:
case System.Data.SqlDbType.Money:
case System.Data.SqlDbType.Decimal:
setMethod(obj, FieldName, reader.GetDecimal(this.Index));
break;
case System.Data.SqlDbType.Float:
setMethod(obj, FieldName, reader.GetDouble(this.Index));
break;
case System.Data.SqlDbType.Int:
setMethod(obj, FieldName, reader.GetInt32(this.Index));
break;
case System.Data.SqlDbType.Text:
case System.Data.SqlDbType.NVarChar:
case System.Data.SqlDbType.NText:
case System.Data.SqlDbType.VarChar:
case System.Data.SqlDbType.NChar:
setMethod(obj, FieldName, reader.GetString(this.Index));
break;
case System.Data.SqlDbType.Real:
setMethod(obj, FieldName, reader.GetFloat(this.Index));
break;
case System.Data.SqlDbType.SmallInt:
setMethod(obj, FieldName, reader.GetInt16(this.Index));
break;
case System.Data.SqlDbType.TinyInt:
setMethod(obj, FieldName, reader.GetByte(this.Index));
break;
case System.Data.SqlDbType.UniqueIdentifier:
setMethod(obj, FieldName, reader.GetGuid(this.Index));
break;
default:
break;
}
}
else
{
setMethod(obj, FieldName, null);
}
}
float System.Data.IDataRecord.GetFloat(int i)
{
return(_dataReader.GetFloat(i));
}
public static float AsFloat(this System.Data.IDataReader reader, string name, float defaultValue = 0f)
{
var o = reader[name];
return(o != null && o != DBNull.Value ? reader.GetFloat(reader.GetOrdinal(name)) : defaultValue);
}
