public bool Delete(Embajada objToProcess) { bool flag = false; try { DbConnection connection = this.instance.CreateConnection(); try { connection.Open(); DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_EMBAJADA_DELETE"); storedProcCommand.Connection = connection; this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)objToProcess.Id); this.instance.AddInParameter(storedProcCommand, "@ID_USUARIO", DbType.Int32, (object)objToProcess.IdUltimaModificacion); this.instance.ExecuteNonQuery(storedProcCommand); flag = true; } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } finally { connection.Close(); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } return(flag); }
private Embajada GetByPK(int id) { DbConnection connection = this.instance.CreateConnection(); Embajada objToLoad = new Embajada(); try { connection.Open(); DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_GET_EMBAJADA_BY_PK"); storedProcCommand.Connection = connection; this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)id); DbDataAdapter dataAdapter = this.instance.GetDataAdapter(); DataTable dataTable = new DataTable(); dataAdapter.SelectCommand = storedProcCommand; dataAdapter.Fill(dataTable); if (dataTable.Rows.Count > 0) { this.LoadFromDataRow(ref objToLoad, dataTable.Rows[0]); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } finally { connection.Close(); } return(objToLoad); }
public bool Create(Embajada objToProcess) { bool flag = false; try { DbConnection connection = this.instance.CreateConnection(); try { connection.Open(); DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_EMBAJADA_CREATE"); storedProcCommand.Connection = connection; this.instance.AddOutParameter(storedProcCommand, "@ID", DbType.Int32, 4); this.instance.AddInParameter(storedProcCommand, "@NOMBRE", DbType.String, (object)objToProcess.Nombre); this.instance.AddInParameter(storedProcCommand, "@ACTIVO", DbType.Boolean, (object)objToProcess.Activo); this.instance.AddInParameter(storedProcCommand, "@ID_CREACION", DbType.Int32, (object)objToProcess.IdCreacion); this.instance.ExecuteNonQuery(storedProcCommand); objToProcess.Id = Convert.ToInt32(storedProcCommand.Parameters["@ID"].Value); flag = true; } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } finally { connection.Close(); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } return(flag); }
public bool Update(Embajada objToProcess) { bool flag = false; try { DbConnection connection = this.instance.CreateConnection(); try { connection.Open(); DbCommand storedProcCommand = this.instance.GetStoredProcCommand("PA_EMBAJADA_UPDATE"); storedProcCommand.Connection = connection; this.instance.AddInParameter(storedProcCommand, "@ID", DbType.Int32, (object)objToProcess.Id); this.instance.AddInParameter(storedProcCommand, "@NOMBRE", DbType.String, (object)objToProcess.Nombre); this.instance.AddInParameter(storedProcCommand, "@ACTIVO", DbType.Boolean, (object)objToProcess.Activo); this.instance.AddInParameter(storedProcCommand, "@ID_ULTIMA_MODIFICACION", DbType.Int32, (object)objToProcess.IdUltimaModificacion); this.instance.ExecuteNonQuery(storedProcCommand); flag = true; } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } finally { connection.Close(); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } return(flag); }
public bool Delete(Embajada objToProcess) { EmbajadaDao embajadaDao = new EmbajadaDao(); bool flag = embajadaDao.Delete(objToProcess); this.error = embajadaDao.Error; return(flag); }
public bool Save(Embajada objEnt) { EmbajadaDao embajadaDao = new EmbajadaDao(); bool flag = objEnt.Id == int.MinValue ? embajadaDao.Create(objEnt) : embajadaDao.Update(objEnt); this.error = embajadaDao.Error; return(flag); }
public Embajada Load(int id) { EmbajadaDao embajadaDao = new EmbajadaDao(); Embajada embajada = embajadaDao.Load(id); this.error = embajadaDao.Error; return(embajada); }
private void LoadFromDataRow(ref Embajada objToLoad, DataRow drData) { try { objToLoad.Id = Convert.ToInt32(drData["ID"]); objToLoad.Nombre = drData["NOMBRE"].ToString(); objToLoad.Activo = Convert.ToBoolean(drData["ACTIVO"]); objToLoad.IdCreacion = Convert.ToInt32(drData["ID_CREACION"]); objToLoad.FechaCreacion = Convert.ToDateTime(drData["FECHA_CREACION"]); objToLoad.IdUltimaModificacion = Convert.ToInt32(drData["ID_ULTIMA_MODIFICACION"]); objToLoad.FechaUltimaModificacion = Convert.ToDateTime(drData["FECHA_ULTIMA_MODIFICACION"]); } catch (Exception ex) { objToLoad = new Embajada(); this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } }
public List <Embajada> GetEmbajadas(string nombre, bool activo, bool showAllActivo) { List <Embajada> embajadaList = new List <Embajada>(); try { foreach (DataRow row in (InternalDataCollectionBase)this.GetList(nombre, activo, showAllActivo).Rows) { Embajada objToLoad = new Embajada(); this.LoadFromDataRow(ref objToLoad, row); embajadaList.Add(objToLoad); } } catch (Exception ex) { this.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message; } return(embajadaList); }
protected void gvEmbajadas_DeleteCommand(object sender, GridCommandEventArgs e) { GridEditableItem editColumn = (GridEditableItem)e.Item; int idToDelete = Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[editColumn.ItemIndex]["ID"]); EmbajadaBll objBllSave = new EmbajadaBll(); Embajada objEntity = new Embajada(); objEntity.Id = idToDelete; objEntity.IdUltimaModificacion = this.IdUserCurrent; if (!objBllSave.Delete(objEntity)) { } else { this.gvEmbajadas.Rebind(); } }
private void SaveInfo(bool isCreate, GridCommandEventArgs e) { GridEditableItem editColumn = (GridEditableItem)e.Item; Hashtable newValues = new Hashtable(); e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editColumn); string nombreEmb = newValues["NOMBRE"].ToString(); bool activo = Convert.ToBoolean(newValues["ACTIVO"]); EmbajadaBll objBllSave = new EmbajadaBll(); Embajada objEntity = new Embajada(); if (isCreate) { objEntity.IdCreacion = this.IdUserCurrent; objEntity.FechaCreacion = DateTime.Now; } else { int idToUpdate = Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[editColumn.ItemIndex]["ID"]); objEntity.Id = idToUpdate; } objEntity.Nombre = nombreEmb; objEntity.Activo = activo; objEntity.IdUltimaModificacion = this.IdUserCurrent; objEntity.FechaUltimaModificacion = DateTime.Now; if (!objBllSave.Save(objEntity)) { //objBllSave.Error; this.gvEmbajadas.EditIndexes.Clear(); this.gvEmbajadas.Rebind(); string mensaje = string.Format("{0}", objBllSave.Error); erroresCarga.Text = mensaje; } else { this.gvEmbajadas.EditIndexes.Clear(); this.gvEmbajadas.Rebind(); } }