public DataSet getRegionSrch(clsRegion objRegionnfo)
{
dataAccess = new DataAccess();
if (objRegionnfo.RegionCode == null)
{
objRegionnfo.RegionCode = "";
}
if (objRegionnfo.RegionName == null)
{
objRegionnfo.RegionName = "";
}
if (objRegionnfo.EffectiveFromDate == null)
{
objRegionnfo.EffectiveFromDate = "";
}
if (objRegionnfo.EffectiveFromDate1 == null)
{
objRegionnfo.EffectiveFromDate1 = "";
}
if (objRegionnfo.EffectiveToDate == null)
{
objRegionnfo.EffectiveToDate = "";
}
if (objRegionnfo.EffectiveToDate1 == null)
{
objRegionnfo.EffectiveToDate1 = "";
}
Object[] parameters = new Object[] { objRegionnfo.RegionCode, objRegionnfo.RegionName, objRegionnfo.EffectiveFromDate, objRegionnfo.EffectiveFromDate1, objRegionnfo.EffectiveToDate, objRegionnfo.EffectiveToDate1 };
return(dataAccess.LoadDataSet(parameters, "P_Adm_RegionListAll", "RegionList"));
}
public ctrlRegion(Region vista)
{
this.vista = vista;
vista.Load += new EventHandler(cargarData);
vista.btnAgregar.Click += new EventHandler(agregar);
vista.btnEliminar.Click += new EventHandler(eliminar);
vista.btnModificar.Click += new EventHandler(modificar);
region = new suportRegion();
recipiente = new clsRegion();
}
public void eliminar(clsRegion region)
{
SQLiteConnection conn = SQLiteConnector.CreateConnection();
SQLiteCommand sqliteCommand;
sqliteCommand = conn.CreateCommand();
sqliteCommand.CommandText = "DELETE FROM Region WHERE paisId = " + region.codigo + ";";
sqliteCommand.ExecuteNonQuery();
conn.Close();
}
public DataSet SaveRegionMaster(clsRegion objRegion)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objRegion.RegionId,
objRegion.RegionCode,
objRegion.RegionName,
objRegion.EffectiveFromDate,
objRegion.EffectiveToDate,
objRegion.LoginUserId,
objRegion.PageMethod };
return(dataAccess.LoadDataSet(parameters, "P_Adm_Region_InsertUpdate", "Regiontab"));
}
public void modificar(clsRegion region)
{
SQLiteConnection conn = SQLiteConnector.CreateConnection();
SQLiteCommand sqliteCommand;
sqliteCommand = conn.CreateCommand();
sqliteCommand.CommandText = @"UPDATE Region SET " +
"paisId = " + region.codigo + "," +
"continente = '" + region.continente + "'," +
"pais = '" + region.pais + "';";
sqliteCommand.ExecuteNonQuery();
conn.Close();
}
public void agregar(clsRegion region)
{
SQLiteConnection conn = SQLiteConnector.CreateConnection();
SQLiteCommand sqliteCommand;
sqliteCommand = conn.CreateCommand();
sqliteCommand.CommandText = @"INSERT INTO Region(paisId, continente, pais) VALUES (" +
"" + region.codigo + ", " +
"'" + region.continente + "', " +
"'" + region.pais + "');";
sqliteCommand.ExecuteNonQuery();
conn.Close();
}
public DataSet getRegionAll(clsRegion objRegioninfo)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objRegioninfo.RegionId };
return(dataAccess.LoadDataSet(parameters, "P_Adm_RegionList", "RegionList"));
}
