//---------------- // PerImagen //---------------- public BE_ResGenerico InsPerImagen(BE_ReqPerPhoto Request) { BE_ResGenerico Item = new BE_ResGenerico(); long Resultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Ins_PerImagen]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nPerTipImagen", Request.nPerTipImagen); SqlParameter pImg = new SqlParameter("iPerImaFoto", SqlDbType.Image); pImg.Value = Request.iPerImaFoto ; cm.Parameters.Add(pImg); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return Item; }
//Obtener Photo x cPercodigo public DataTable Get_PerImagen(BE_ReqPerPhoto Request) { //Recuperando registros DataTable dt = new DataTable(); DA_Persona Obj = new DA_Persona(); return Obj.Get_PerImagen(Request); }
//Buscar Photo public DataTable Get_PerImagen(BE_ReqPerPhoto Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_PerImagen]"; cm.CommandType = CommandType.StoredProcedure ; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cUltimaPhoto", Request.cUltimaPhoto); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//---------------- // PerImagen //---------------- public BE_ResGenerico InsPerImagen(BE_ReqPerPhoto Request) { BE_ResGenerico Item = new BE_ResGenerico(); DA_Persona Obj = new DA_Persona(); Item = Obj.InsPerImagen(Request); return Item; }