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