OCRD IOCRD.FP_BUSCAR_OCRD(OCRD ObjOCRD, string Compania, string Key) { IBOCRD OCRDB = null; try { string error; if (!this.Validar(Key, Compania, out error)) { throw new Exception(error); } if (ObjOCRD == null) { throw new Exception("ObjOCRD vacio"); } if (ObjOCRD.LicTradNum == null || ObjOCRD.LicTradNum.Trim() == "") { throw new Exception("LicTradNum vacio"); } if (ObjOCRD.Tipo == null || ObjOCRD.Tipo.Trim() == "") { throw new Exception("Tipo vacio"); } OCRDB = new BOCRD(ModVariables.getCompanyConnection(Compania)); return(OCRDB.FP_BUSCAR_OCRD(ObjOCRD)); } catch (Exception ex) { throw ex; } finally { OCRDB = null; } }
OCRD IBOCRD.FP_BUSCAR_OCRD(OCRD ObjOCRD) { IQOCRD objOCRDD = null; try { objOCRDD = new DataOCRD(this._CadenaConeccion); return(objOCRDD.FP_BUSCAR_OCRD(ObjOCRD)); } catch (Exception ex) { throw; } finally { objOCRDD = null; } }
List <OCRD> IQOCRD.FP_Listar_OCRD(OCRD ObjOCRD) { List <OCRD> objResult = null; try { using (SqlConnection cnn = new SqlConnection(_strCadenaConexion)) { cnn.Open(); using (SqlCommand cmd = new SqlCommand("SBO_SP_LGS_BUS_LIS_Proveedor", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Tipo", ObjOCRD.Tipo); using (SqlDataReader dr = cmd.ExecuteReader()) { objResult = new List <OCRD>(); while (dr.Read()) { OCRD item = new OCRD(); item.CardCode = dr.GetString(dr.GetOrdinal("CardCode")); item.CardName = dr.GetString(dr.GetOrdinal("CardName")); item.Address = dr.GetString(dr.GetOrdinal("Address")); item.Notes = dr.GetString(dr.GetOrdinal("Notes")); item.LicTradNum = dr.GetString(dr.GetOrdinal("LicTradNum")); item.City = dr.GetString(dr.GetOrdinal("City")); item.County = dr.GetString(dr.GetOrdinal("County")); item.Country = dr.GetString(dr.GetOrdinal("Country")); item.MailCity = dr.GetString(dr.GetOrdinal("MailCity")); item.MailCounty = dr.GetString(dr.GetOrdinal("MailCounty")); item.MailCountr = dr.GetString(dr.GetOrdinal("MailCountr")); item.E_Mail = dr.GetString(dr.GetOrdinal("E_Mail")); objResult.Add(item); } } return(objResult); } } } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { string hash = Request.QueryString["hash"].ToString(); byte[] bytesToBeDecrypted = UrlBase64.Decode(hash); byte[] passwordBytesDec = Encoding.UTF8.GetBytes(ConfigurationManager.AppSettings["Pass"].ToString()); passwordBytesDec = SHA256.Create().ComputeHash(passwordBytesDec); byte[] bytesDecrypted = AES_Decrypt(bytesToBeDecrypted, passwordBytesDec); string IDCliente = Encoding.UTF8.GetString(bytesDecrypted); //DataSet DatadataSet = new DataSet(); //SeccionMySql objSecpromo = new SeccionMySql(); //string customer_id = string.Empty; //string NumCliente = string.Empty; Session["hash"] = hash; //objSecpromo.Logineshop = Request.QueryString["ww"].ToString(); //DatadataSet = objSecpromo.SeccionID(); //DataTable myDataTable = DatadataSet.Tables[0]; //foreach (DataRow ColumSeccion in myDataTable.Rows) //{ string customer_id = IDCliente; EXIMSAPDataContext dbsap = new EXIMSAPDataContext(); OCRD cliente = (from a in dbsap.OCRD where a.CardCode == IDCliente select a).FirstOrDefault(); //} if (customer_id != "0" && customer_id != "") { cargaDatos(IDCliente); lblSeccion.Text = "Si"; lblNombreAdmin.Text = IDCliente + " - " + cliente.CardName; } else { lblSeccion.Text = "No"; } } } catch (Exception ex) { Response.Redirect("Seccion.aspx"); } finally { if (lblSeccion.Text == "No" || lblSeccion.Text.Length == 0) { Response.Redirect("Seccion.aspx"); } } }