Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlConnection miConexion = new SqlConnection("data source = snare.arvixe.com; initial catalog=*****; user id=*****; password=*****");
- public int Login(string user, string password, int idEmpresa)
- {
- try
- {
- if (miConexion.State == ConnectionState.Closed)
- {
- miConexion.Open();
- }
- SqlCommand comando = new SqlCommand("select e.Email, e.Llave_Razon, c.llaveRazon, c.id, c.Nombre,c.Nombre1,c.Apellido1 , c.Apellido2, c.Clave, c.idEmpresa,c.llaveEmp from CrmCustomersEmails as e inner join CrmCustomers as c on e.Customer_ID = c.id where e.Email = '" + user + "'and c.Clave = '" + password + "'and idEmpresa = '" + idEmpresa + "'", miConexion);
- comando.ExecuteNonQuery();
- DataSet ds = new DataSet();
- SqlDataAdapter da = new SqlDataAdapter(comando);
- da.Fill(ds, "CrmCustomers");
- da.Fill(ds, "CrmCustomersEmails");
- //utilizado para representar una fila de la tabla q necesitas en este caso usuario
- DataRow DR;
- DR = ds.Tables["CrmCustomers"].Rows[0];
- DR = ds.Tables["CrmCustomersEmails"].Rows[0];
- if ((user == DR["Email"].ToString()) && (password == DR["Clave"].ToString()) && (idEmpresa.ToString() == DR["idEmpresa"].ToString()))
- {
- SqlDataReader reader = comando.ExecuteReader();
- if (reader.Read())
- {
- //LlaveEmp, es en CrmCustomers id, en CrmCustomersEmails ID_Customers, y Para generar Recibos es cuales
- LlaveEmpCualesRecibos = Guid.Parse((reader["id"].ToString()));
- llaveEmpFormatoString = (reader["id"].ToString());
- LlaveRazonEstado = (reader["llaveRazon"].ToString());
- LlamveEmpEstado = (reader["llaveEmp"].ToString());
- }
- miConexion.Close();
- return 1;
- }
- else
- {
- miConexion.Close();
- return 2;
- }
- }
- #pragma warning disable CS0168 // The variable 'ex' is declared but never used
- catch (Exception ex)
- #pragma warning restore CS0168 // The variable 'ex' is declared but never used
- {
- miConexion.Close();
- return 3;
- }
- }
- <?xml version="1.0" encoding="utf-8"?>
- <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="PortalCliente.PortalCliente" android:versionCode="1" android:versionName="1.0" android:installLocation="auto">
- <uses-sdk android:minSdkVersion="16" />
- <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
- <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
- <uses-permission android:name="android.permission.ACCESS_WIFI_STATE" />
- <uses-permission android:name="android.permission.BIND_TELECOM_CONNECTION_SERVICE" />
- <uses-permission android:name="android.permission.INTERNET" />
- <application android:label="PP- Portal Proveedor"></application>
- </manifest>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement