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");
}
}
}
