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