public List <UBIGEO_EL> GetAllUBIGEO(UBIGEO_EL U)
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand com = new SqlCommand("spGet_UBIGEO", con))
{
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@co_ubigeo", SqlDbType.Char, 8).Value = U.co_ubigeo;
com.Parameters.Add("@flag", SqlDbType.Char, 1).Value = U.flag;
List <UBIGEO_EL> list = new List <UBIGEO_EL>();
using (IDataReader dataReader = com.ExecuteReader())
{
while (dataReader.Read())
{
UBIGEO_EL obj = new UBIGEO_EL();
if (dataReader["co_ubigeo"] != DBNull.Value)
{
obj.co_ubigeo = (string)dataReader["co_ubigeo"];
}
if (dataReader["de_ubigeo"] != DBNull.Value)
{
obj.de_ubigeo = (string)dataReader["de_ubigeo"];
}
list.Add(obj);
}
}
return(list);
}
}
}
public JsonResult CargaComboUbigeo(UBIGEO_EL Datos)
{
try
{
string postdata = JsonConvert.SerializeObject(Datos);
var lista = JsonConvert.DeserializeObject <List <UBIGEO_EL> >(Utilitario.Accion.Conect_WEBAPI("UBIGEO/ObtenerUbigeo", "POST", postdata));
return(Json(lista, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { ListaMATERIA_PRIMA = "" }, JsonRequestBehavior.AllowGet));
}
}
public List <UBIGEO_EL> GetAllUBIGEO(UBIGEO_EL U)
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand com = new SqlCommand("spGet_UBIGEO", con))
{
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@vCodDpto", SqlDbType.Int).Value = U.vCodDpto;
com.Parameters.Add("@vCodProv", SqlDbType.Int).Value = U.vCodProv;
com.Parameters.Add("@vCodDist", SqlDbType.Int).Value = U.vCodDist;
List <UBIGEO_EL> list = new List <UBIGEO_EL>();
using (IDataReader dataReader = com.ExecuteReader())
{
while (dataReader.Read())
{
UBIGEO_EL obj = new UBIGEO_EL();
if (dataReader["vCodDpto"] != DBNull.Value)
{
obj.vCodDpto = (string)dataReader["vCodDpto"];
}
if (dataReader["vCodProv"] != DBNull.Value)
{
obj.vCodProv = (string)dataReader["vCodProv"];
}
if (dataReader["vCodDist"] != DBNull.Value)
{
obj.vCodDist = (string)dataReader["vCodDist"];
}
if (dataReader["vNombre"] != DBNull.Value)
{
obj.vNombre = (string)dataReader["vNombre"];
}
list.Add(obj);
}
}
return(list);
}
}
}
//================================================================
// UBIGEO =========================================
public List <UBIGEO_EL> GetAllUBIGEO(UBIGEO_EL Ubigeo)
{
return(UBIGEO_DA.Accion.GetAllUBIGEO(Ubigeo));
}
public IEnumerable <UBIGEO_EL> ObtenerUbigeo(UBIGEO_EL value)
{
return(UBIGEO_DA.Accion.GetAllUBIGEO(value));
}
