Advertisement
Guest User

Untitled

a guest
Oct 12th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.21 KB | None | 0 0
  1. SqlConnection miConexion = new SqlConnection("data source = snare.arvixe.com; initial catalog=*****; user id=*****; password=*****");
  2. public int Login(string user, string password, int idEmpresa)
  3. {
  4. try
  5. {
  6. if (miConexion.State == ConnectionState.Closed)
  7. {
  8. miConexion.Open();
  9. }
  10. 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);
  11. comando.ExecuteNonQuery();
  12. DataSet ds = new DataSet();
  13. SqlDataAdapter da = new SqlDataAdapter(comando);
  14. da.Fill(ds, "CrmCustomers");
  15. da.Fill(ds, "CrmCustomersEmails");
  16. //utilizado para representar una fila de la tabla q necesitas en este caso usuario
  17. DataRow DR;
  18. DR = ds.Tables["CrmCustomers"].Rows[0];
  19. DR = ds.Tables["CrmCustomersEmails"].Rows[0];
  20. if ((user == DR["Email"].ToString()) && (password == DR["Clave"].ToString()) && (idEmpresa.ToString() == DR["idEmpresa"].ToString()))
  21. {
  22. SqlDataReader reader = comando.ExecuteReader();
  23. if (reader.Read())
  24. {
  25. //LlaveEmp, es en CrmCustomers id, en CrmCustomersEmails ID_Customers, y Para generar Recibos es cuales
  26. LlaveEmpCualesRecibos = Guid.Parse((reader["id"].ToString()));
  27. llaveEmpFormatoString = (reader["id"].ToString());
  28. LlaveRazonEstado = (reader["llaveRazon"].ToString());
  29. LlamveEmpEstado = (reader["llaveEmp"].ToString());
  30. }
  31. miConexion.Close();
  32. return 1;
  33. }
  34. else
  35. {
  36. miConexion.Close();
  37. return 2;
  38. }
  39. }
  40. #pragma warning disable CS0168 // The variable 'ex' is declared but never used
  41. catch (Exception ex)
  42. #pragma warning restore CS0168 // The variable 'ex' is declared but never used
  43. {
  44. miConexion.Close();
  45. return 3;
  46. }
  47. }
  48.  
  49. <?xml version="1.0" encoding="utf-8"?>
  50. <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="PortalCliente.PortalCliente" android:versionCode="1" android:versionName="1.0" android:installLocation="auto">
  51. <uses-sdk android:minSdkVersion="16" />
  52. <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
  53. <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
  54. <uses-permission android:name="android.permission.ACCESS_WIFI_STATE" />
  55. <uses-permission android:name="android.permission.BIND_TELECOM_CONNECTION_SERVICE" />
  56. <uses-permission android:name="android.permission.INTERNET" />
  57. <application android:label="PP- Portal Proveedor"></application>
  58. </manifest>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement