public int Actualizar(UbigeoBE e_Ubigeo)
{
using (SqlConnection connection = Conectar(m_BaseDatos))
{
try
{
ComandoSP("usp_UbigeoActualizar", connection);
ParametroSP("@UbigeoId", e_Ubigeo.UbigeoId);
ParametroSP("@UbigeoCodigo", e_Ubigeo.UbigeoCodigo);
ParametroSP("@Departamento", e_Ubigeo.Departamento);
ParametroSP("@Provincia", e_Ubigeo.Provincia);
ParametroSP("@Distrito", e_Ubigeo.Distrito);
ParametroSP("@EstadoId", e_Ubigeo.EstadoId);
ParametroSP("@UsuarioModificacionRegistro", e_Ubigeo.UsuarioModificacionRegistro);
ParametroSP("@NroIpRegistro", e_Ubigeo.NroIpRegistro);
return(comando.ExecuteNonQuery());
}
catch (SqlException ex)
{
throw new Exception("Clase DataAccess " + Nombre_Clase + "\r\n" + "Descripción: " + ex.Message);
}
finally
{
connection.Dispose();
}
}
}
public UbigeoBEList GetListaProvincia(String idDepartamento)
{
UbigeoBEList lista = new UbigeoBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "sgsnet_sps_listado_provincia";
db.AddParameter("@vi_ch_cod_dpto", DbType.String, ParameterDirection.Input, idDepartamento);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
UbigeoBE oUbigeoBE = CrearEntidadProvincia(DReader);
lista.Add(oUbigeoBE);
}
DReader.Close();
}
catch
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public UbigeoBEList GetListaLeyendaUbigeo()
{
UbigeoBEList lista = new UbigeoBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "sgsnet_sps_listado_leyenda_ubigeo";
DReader = db.GetDataReader();
}
while (DReader.Read())
{
UbigeoBE oUbigeoBE = CrearEntidadLeyendaUbigeo(DReader);
lista.Add(oUbigeoBE);
}
DReader.Close();
}
catch
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public List <UbigeoBE> Get_Ubigeo_Distrito(String codDpto, String codProv)
{
String cadena;
String sql = "Ubigeo_Get_Distrito";
SqlParameter[] arrParameters = new SqlParameter[2];
UbigeoBE objUbigeoBE = null;
List <UbigeoBE> lstUbigeoBE = null;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@coddpto", codDpto);
arrParameters[1] = new SqlParameter("@codprov", codProv);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (lstUbigeoBE == null)
{
lstUbigeoBE = new List <UbigeoBE>();
}
objUbigeoBE = new UbigeoBE();
objUbigeoBE.CodDist = dr["coddist"].ToString();
objUbigeoBE.CodDpto = dr["coddpto"].ToString();
objUbigeoBE.CodProv = dr["codprov"].ToString();
objUbigeoBE.Nombre = dr["nombre"].ToString();
objUbigeoBE.Precio = Convert.ToDecimal(dr["precio"]);
lstUbigeoBE.Add(objUbigeoBE);
}
}
}
}
return(lstUbigeoBE);
}
catch (Exception)
{
throw;
}
}
protected void gvDistrito_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
#region Editar
if (e.CommandName.Equals("Editar"))
{
GridViewRow gvRow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
gvDistrito.EditIndex = gvRow.RowIndex;
LlenarDistritos();
}
#endregion
#region Cancelar
if (e.CommandName.Equals("Cancelar"))
{
gvDistrito.EditIndex = -1;
LlenarDistritos();
}
#endregion
#region Actualizar
if (e.CommandName.Equals("Actualizar"))
{
GridViewRow gvRow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
TextBox txtPrecio = (TextBox)gvRow.FindControl("txtPrecio");
UbigeoBE objUbigeoBE = new UbigeoBE();
objUbigeoBE.CodDpto = ddlDepartamento.SelectedValue;
objUbigeoBE.CodProv = ddlProvincia.SelectedValue;
objUbigeoBE.CodDist = e.CommandArgument.ToString();
objUbigeoBE.Nombre = txtPrecio.Text;
UbigeoBC objUbigeoBC = new UbigeoBC();
objUbigeoBC.Update_Ubigeo_Precio(objUbigeoBE);
gvDistrito.EditIndex = -1;
LlenarDistritos();
Tools.Unload(GetType(), this);
}
#endregion
}
catch (Exception ex)
{
Tools.Error(GetType(), this, ex);
}
}
public void Update_Ubigeo_Precio(UbigeoBE objUbigeoBE)
{
try
{
objUbigeoDALC.Update_Ubigeo_Precio(objUbigeoBE);
}
catch (Exception)
{
throw;
}
}
public bool Anular(UbigeoBE e_Ubigeo)
{
try
{
UbigeoDA o_Ubigeo = new UbigeoDA(m_BaseDatos);
int resp = o_Ubigeo.Anular(e_Ubigeo);
return(resp > 0);
}
catch (Exception ex)
{
throw new Exception("Clase Business: " + Nombre_Clase + "\r\n" + "Descripción: " + ex.Message);
}
}
private UbigeoBE CrearEntidadDistrito(IDataReader DReader)
{
UbigeoBE oUbigeoBE = new UbigeoBE();
int indice;
indice = DReader.GetOrdinal("cod_distrito");
oUbigeoBE.coddist = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
indice = DReader.GetOrdinal("nom_distrito");
oUbigeoBE.nombre = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
return(oUbigeoBE);
}
private UbigeoBE CrearEntidadProvincia(IDataReader DReader)
{
UbigeoBE oUbigeoBE = new UbigeoBE();
int indice;
indice = DReader.GetOrdinal("codprovincia");
oUbigeoBE.codprov = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
indice = DReader.GetOrdinal("provincia");
oUbigeoBE.nombre = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
return(oUbigeoBE);
}
private UbigeoBE CrearEntidadDepartamento(IDataReader DReader)
{
UbigeoBE oUbigeoBE = new UbigeoBE();
int indice;
//u.coddpto AS cod_departamento
indice = DReader.GetOrdinal("cod_departamento");
oUbigeoBE.coddpto = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
//RTRIM(LTRIM(u.nombre)) AS departamento
indice = DReader.GetOrdinal("departamento");
oUbigeoBE.nombre = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
return(oUbigeoBE);
}
public List <UbigeoBE> Get_Ubigeo_Departamento()
{
String cadena;
String sql = "Ubigeo_Select_Departamento";
UbigeoBE objUbigeoBE = null;
List <UbigeoBE> lstUbigeoBE = null;
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (lstUbigeoBE == null)
{
lstUbigeoBE = new List <UbigeoBE>();
}
objUbigeoBE = new UbigeoBE();
objUbigeoBE.CodDist = dr["coddist"].ToString();
objUbigeoBE.CodDpto = dr["coddpto"].ToString();
objUbigeoBE.CodProv = dr["codprov"].ToString();
objUbigeoBE.Nombre = dr["nombre"].ToString();
lstUbigeoBE.Add(objUbigeoBE);
}
}
}
}
return(lstUbigeoBE);
}
catch (Exception)
{
throw;
}
}
private UbigeoBE ViewModelToBE(UbigeoViewModel m_vm)
{
UbigeoBE m_BE = new UbigeoBE();
m_BE.UbigeoId = m_vm.UbigeoId;
m_BE.UbigeoCodigo = m_vm.UbigeoCodigo;
m_BE.Departamento = m_vm.Departamento;
m_BE.Provincia = m_vm.Provincia;
m_BE.Distrito = m_vm.Distrito;
m_BE.UsuarioRegistro = m_vm.UsuarioRegistro;
m_BE.UsuarioModificacionRegistro = m_vm.UsuarioModificacionRegistro;
m_BE.FechaRegistro = m_vm.FechaRegistro;
m_BE.UsuarioModificacionRegistro = m_vm.UsuarioModificacionRegistro;
m_BE.FechaModificacionRegistro = m_vm.FechaModificacionRegistro;
m_BE.NroIpRegistro = HttpContext.Current.Request.UserHostAddress;
m_BE.EstadoId = m_vm.EstadoId;
return(m_BE);
}
private UbigeoBE CrearEntidadLeyendaUbigeo(IDataReader DReader)
{
UbigeoBE oUbigeoBE = new UbigeoBE();
int indice;
indice = DReader.GetOrdinal("cod_departamento");
oUbigeoBE.coddpto = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
indice = DReader.GetOrdinal("cod_provincia");
oUbigeoBE.codprov = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
indice = DReader.GetOrdinal("cod_distrito");
oUbigeoBE.coddist = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
indice = DReader.GetOrdinal("departamento");
oUbigeoBE.nombre = DReader.IsDBNull(indice) ? String.Empty : DReader.GetString(indice);
return(oUbigeoBE);
}
public UbigeoBE SeleccionaDescripcion(string DescUbigeo)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Selecciona_Descripcion");
db.AddInParameter(dbCommand, "@pDescUbigeo", DbType.String, DescUbigeo);
IDataReader reader = db.ExecuteReader(dbCommand);
UbigeoBE Ubigeo = null;
while (reader.Read())
{
Ubigeo = new UbigeoBE();
Ubigeo.IdUbigeo = reader["IdUbigeo"].ToString();
}
reader.Close();
reader.Dispose();
return(Ubigeo);
}
private UbigeoViewModel BEToViewModel(UbigeoBE m_BE)
{
UbigeoViewModel m_vm = new UbigeoViewModel();
m_vm.UbigeoId = m_BE.UbigeoId;
m_vm.UbigeoCodigo = m_BE.UbigeoCodigo;
m_vm.Departamento = m_BE.Departamento;
m_vm.Provincia = m_BE.Provincia;
m_vm.Distrito = m_BE.Distrito;
m_vm.UsuarioRegistro = m_BE.UsuarioRegistro;
m_vm.UsuarioModificacionRegistro = m_BE.UsuarioModificacionRegistro;
m_vm.FechaRegistro = m_BE.FechaRegistro;
m_vm.UsuarioModificacionRegistro = m_BE.UsuarioModificacionRegistro;
m_vm.FechaModificacionRegistro = m_BE.FechaModificacionRegistro;
m_vm.NroIpRegistro = m_BE.NroIpRegistro;
m_vm.EstadoId = m_BE.EstadoId.Value;
m_vm.EstadoNombre = new EstadosBL().Consultar_PK(m_BE.EstadoId.Value).FirstOrDefault().Nombre;
return(m_vm);
}
public List <UbigeoBE> SeleccionaDepartamento()
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Selecciona_Departamentos");
IDataReader reader = db.ExecuteReader(dbCommand);
List <UbigeoBE> Ubigeolist = new List <UbigeoBE>();
UbigeoBE Ubigeo;
while (reader.Read())
{
Ubigeo = new UbigeoBE();
Ubigeo.IdDepartament = reader["IdDepartament"].ToString();
Ubigeo.NomDpto = reader["NomDpto"].ToString();
Ubigeolist.Add(Ubigeo);
}
reader.Close();
reader.Dispose();
return(Ubigeolist);
}
public List <UbigeoBE> Listado()
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Ubigeo_Lista");
IDataReader reader = db.ExecuteReader(dbCommand);
List <UbigeoBE> Ubigeolist = new List <UbigeoBE>();
UbigeoBE Ubigeo;
while (reader.Read())
{
Ubigeo = new UbigeoBE();
Ubigeo.IdUbigeo = reader["IdUbigeo"].ToString();
Ubigeo.NomDist = reader["NomDist"].ToString();
Ubigeo.NomUbigeo = reader["NomUbigeo"].ToString();
Ubigeolist.Add(Ubigeo);
}
reader.Close();
reader.Dispose();
return(Ubigeolist);
}
public List <UbigeoBE> SeleccionaProvincia(string IdDepartament)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Selecciona_Provincias");
db.AddInParameter(dbCommand, "@pIdDepartament", DbType.String, IdDepartament);
IDataReader reader = db.ExecuteReader(dbCommand);
List <UbigeoBE> Ubigeolist = new List <UbigeoBE>();
UbigeoBE Ubigeo;
while (reader.Read())
{
Ubigeo = new UbigeoBE();
Ubigeo.IdProvincie = reader["IdProvincie"].ToString();
Ubigeo.NomProv = reader["NomProv"].ToString();
Ubigeolist.Add(Ubigeo);
}
reader.Close();
reader.Dispose();
return(Ubigeolist);
}
public UbigeoBE SeleccionaDescripcionDistrito(string IdDepartament, string IdProvincie, string DescUbigeo)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Selecciona_DescripcionDistrito");
db.AddInParameter(dbCommand, "@pIdDepartament", DbType.String, IdDepartament);
db.AddInParameter(dbCommand, "@pIdProvincie", DbType.String, IdProvincie);
db.AddInParameter(dbCommand, "@pDescUbigeo", DbType.String, DescUbigeo);
IDataReader reader = db.ExecuteReader(dbCommand);
UbigeoBE Ubigeo = null;
while (reader.Read())
{
Ubigeo = new UbigeoBE();
Ubigeo.IdDistrict = reader["IdDistrict"].ToString();
Ubigeo.NomDist = reader["NomDist"].ToString();
}
reader.Close();
reader.Dispose();
return(Ubigeo);
}
public void Update_Ubigeo_Precio(UbigeoBE objUbigeoBE)
{
String cadena;
String sql = "Ubigeo_Update_Precio";
SqlParameter[] arrParameters = new SqlParameter[4];
try
{
cadena = Tool.GetCadenaConexion();
using (SqlConnection conn = new SqlConnection(cadena))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
arrParameters[0] = new SqlParameter("@coddpto", objUbigeoBE.CodDpto);
arrParameters[1] = new SqlParameter("@codprov", objUbigeoBE.CodProv);
arrParameters[2] = new SqlParameter("@coddist", objUbigeoBE.CodDist);
arrParameters[3] = new SqlParameter("@precio", objUbigeoBE.Nombre);
for (int i = 0; i < arrParameters.Length; i++)
{
cmd.Parameters.Add(arrParameters[i]);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception)
{
throw;
}
}
public DataSet ProcesarUbigeo(UbigeoBE BE)
{
DataSet dsResult;
try
{
cmd = db.GetStoredProcCommand("Ubigeo_Mnt");
db.AddInParameter(cmd, "OPCION", DbType.Int32, BE.OPCION);
db.AddInParameter(cmd, "USUARIO", DbType.String, BE.USUARIO);
db.AddInParameter(cmd, "IdUbigeo", DbType.String, BE.IdUbigeo);
db.AddInParameter(cmd, "ubiDepartamento", DbType.String, BE.ubiDepartamento);
db.AddInParameter(cmd, "ubiProvincia", DbType.String, BE.ubiProvincia);
db.AddInParameter(cmd, "ubiDistrito", DbType.String, BE.ubiDistrito);
db.AddInParameter(cmd, "ubiNombre", DbType.String, BE.ubiNombre);
db.AddInParameter(cmd, "ubiAux", DbType.String, BE.ubiAux);
db.AddInParameter(cmd, "ubiEstado", DbType.Boolean, BE.ubiEstado);
dsResult = db.ExecuteDataSet(cmd);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(dsResult);
}
public DataSet ProcesarUbigeo(UbigeoBE BE)
{
return(UbigeoDA.ProcesarUbigeo(BE));
}
private void Aceptar1()
{
_Be = (UbigeoBE)gvUbigeo.GetRow(gvUbigeo.FocusedRowHandle);
this.DialogResult = DialogResult.OK;
}
