//static DataModelTestDataContext dm = new DataModelTestDataContext();
public static List <ConfiguracionB> ObtenerConfiguraciones()
{
// metodo agregado
#region SQL compact connection
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeDataReader rdr = null;
List <ConfiguracionB> result = new List <ConfiguracionB>();
try
{
conn = new SqlCeConnection("Data Source=" + System.IO.Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location), "HRNPCIData.sdf"));
conn.Open();
cmd = new SqlCeCommand("SELECT * From Configuracion", conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ConfiguracionB f = new ConfiguracionB();
if (!DBNull.Value.Equals(rdr[0]))
{
f.iCodigoConfiguracion = rdr.GetInt32(0);
}
if (!DBNull.Value.Equals(rdr[1]))
{
f.vParametro = rdr.GetString(1);
}
if (!DBNull.Value.Equals(rdr[2]))
{
f.vRutaEstatica = rdr.GetString(2);
}
if (!DBNull.Value.Equals(rdr[3]))
{
f.dtFechaCreacion = rdr.GetDateTime(3);
}
if (!DBNull.Value.Equals(rdr[4]))
{
f.dtFechaActualizacion = rdr.GetDateTime(4);
}
result.Add(f);
}
rdr.Close();
cmd.Dispose();
}
catch (Exception)
{
return(null);
}
finally
{
conn.Close();
}
return(result);
#endregion
}
public static bool GuardarConfiguracion(ConfiguracionB c, int modo)
{
#region linq to class
//try
//{
// //RemoteModelDataContext dm = new RemoteModelDataContext();
// switch (modo)
// {
// case 0: //guarda por primera vez
// dm.Configuracions.InsertOnSubmit(c);
// dm.SubmitChanges();
// break;
// case 1: //Actualiza ruta
// Configuracion aux = dm.Configuracions.Where(i => i.iCodigoConfiguracion == c.iCodigoConfiguracion).First();
// aux.vRutaEstatica = c.vRutaEstatica;
// aux.dtFechaActualizacion = c.dtFechaActualizacion;
// dm.SubmitChanges();
// break;
// }
//}
//catch (Exception)
//{
// return false;
//}
//return true;
#endregion
#region SQL compact connection
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
try
{
switch (modo)
{
case 0:
conn = new SqlCeConnection("Data Source=" + System.IO.Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location), "HRNPCIData.sdf"));
conn.Open();
cmd = new SqlCeCommand("INSERT INTO Configuracion( " +
"vParametro, " +
"vRutaEstatica, " +
"dtFechaCreacion, " +
"dtFechaActualizacion ) " +
"VALUES (" +
"@vParametro, " +
"@vRutaEstatica, " +
"@dtFechaCreacion, " +
"@dtFechaActualizacion ) ", conn);
cmd.Parameters.AddWithValue("@vParametro", (c.vParametro.Trim() as object) ?? DBNull.Value);
cmd.Parameters.AddWithValue("@vRutaEstatica", (c.vRutaEstatica.Trim() as object) ?? DBNull.Value);
cmd.Parameters.AddWithValue("@dtFechaCreacion", (c.dtFechaCreacion as object) ?? DBNull.Value);
cmd.Parameters.AddWithValue("@dtFechaActualizacion", (c.dtFechaActualizacion as object) ?? DBNull.Value);
break;
case 1:
conn = new SqlCeConnection("Data Source=" + System.IO.Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location), "HRNPCIData.sdf"));
conn.Open();
cmd = new SqlCeCommand("UPDATE SET Configuracion " +
"vParametro = @vParametro," +
"dtFechaActualizacion = @dtFechaActualizacion " +
"WHERE iCodigoConfiguracion = @iCodigoConfiguracion", conn);
cmd.Parameters.AddWithValue("@iCodigoConfiguracion", (c.iCodigoConfiguracion as object) ?? DBNull.Value);
cmd.Parameters.AddWithValue("@vParametro", (c.vRutaEstatica.Trim() as object) ?? DBNull.Value);
cmd.Parameters.AddWithValue("@dtFechaActualizacion", (c.dtFechaActualizacion as object) ?? DBNull.Value);
break;
}
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
#endregion
}
