public int InsertREPRESENTANTE(REPRESENTANTE_EL R)
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand com = new SqlCommand("spInsertREPRESENTANTE", con))
{
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@iIdProveedor", SqlDbType.Int).Value = R.iIdProveedor;
com.Parameters.Add("@vNombreRepresentante", SqlDbType.VarChar).Value = R.vNombreRepresentante;
com.Parameters.Add("@vApellidoPaternoRepresentante", SqlDbType.VarChar).Value = R.vApellidoPaternoRepresentante;
com.Parameters.Add("@vApellidoMaternoRepresentante", SqlDbType.VarChar).Value = R.vApellidoMaternoRepresentante;
com.Parameters.Add("@cDNI", SqlDbType.VarChar).Value = R.cDNI;
com.Parameters.Add("@vCelular", SqlDbType.VarChar).Value = R.vCelular;
com.Parameters.Add("@iTipoRepresentante", SqlDbType.Int).Value = R.iTipoRepresentante;
com.Parameters.Add("@iUsuarioCrea", SqlDbType.Int).Value = R.iUsuarioCrea;
return(com.ExecuteNonQuery());
}
}
}
public int UpdateREPRESENTANTE(REPRESENTANTE_EL R)
{
return(REPRESENTANTE_DA.Accion.UpdateREPRESENTANTE(R));
}
public int InsertREPRESENTANTE(REPRESENTANTE_EL R)
{
return(REPRESENTANTE_DA.Accion.InsertREPRESENTANTE(R));
}
//================================================================
// REPRESENTANTE ==================================================
public List <REPRESENTANTE_EL> GetAllREPRESENTANTE(REPRESENTANTE_EL R)
{
return(REPRESENTANTE_DA.Accion.GetAllREPRESENTANTE(R));
}
public List <REPRESENTANTE_EL> GetAllREPRESENTANTE(REPRESENTANTE_EL R)
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand com = new SqlCommand("spGet_REPRESENTANTE", con))
{
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@iIdRepresentante", SqlDbType.Int).Value = R.iIdRepresentante;
List <REPRESENTANTE_EL> list = new List <REPRESENTANTE_EL>();
using (IDataReader dataReader = com.ExecuteReader())
{
while (dataReader.Read())
{
REPRESENTANTE_EL obj = new REPRESENTANTE_EL();
if (dataReader["iIdRepresentante"] != DBNull.Value)
{
obj.iIdRepresentante = (int)dataReader["iIdRepresentante"];
}
if (dataReader["iIdProveedor"] != DBNull.Value)
{
obj.iIdProveedor = (int)dataReader["iIdProveedor"];
}
if (dataReader["vNombreRepresentante"] != DBNull.Value)
{
obj.vNombreRepresentante = (string)dataReader["vNombreRepresentante"];
}
if (dataReader["vApellidoPaternoRepresentante"] != DBNull.Value)
{
obj.vApellidoPaternoRepresentante = (string)dataReader["vApellidoPaternoRepresentante"];
}
if (dataReader["vApellidoMaternoRepresentante"] != DBNull.Value)
{
obj.vApellidoMaternoRepresentante = (string)dataReader["vApellidoMaternoRepresentante"];
}
if (dataReader["cDNI"] != DBNull.Value)
{
obj.cDNI = (string)dataReader["cDNI"];
}
if (dataReader["vCelular"] != DBNull.Value)
{
obj.vCelular = (string)dataReader["vCelular"];
}
if (dataReader["iTipoRepresentante"] != DBNull.Value)
{
obj.iTipoRepresentante = (int)dataReader["iTipoRepresentante"];
}
if (dataReader["iUsuarioCrea"] != DBNull.Value)
{
obj.iUsuarioCrea = (int)dataReader["iUsuarioCrea"];
}
if (dataReader["dFechaCrea"] != DBNull.Value)
{
obj.dFechaCrea = (DateTime)dataReader["dFechaCrea"];
}
if (dataReader["iUsuarioMod"] != DBNull.Value)
{
obj.iUsuarioMod = (int)dataReader["iUsuarioMod"];
}
if (dataReader["dFechaMod"] != DBNull.Value)
{
obj.dFechaMod = (DateTime)dataReader["dFechaMod"];
}
list.Add(obj);
}
}
return(list);
}
}
}
public int Put(int id, REPRESENTANTE_EL value)
{
return(REPRESENTANTE_DA.Accion.UpdateREPRESENTANTE(value));
}
public int POST(REPRESENTANTE_EL value)
{
return(REPRESENTANTE_DA.Accion.InsertREPRESENTANTE(value));
}
