Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ConexionController con = new ConexionController();
- cTripleDES decry = new cTripleDES();
- SqlConnection miConexion =new SqlConnection( "data source = snare.arvixe.com; initial catalog=logins; user id=usrLogins; password=Madera@2015");
- public int Login(string user, string password)
- {
- try
- {
- if (miConexion.State == ConnectionState.Closed)
- {
- miConexion.Open();
- }
- SqlCommand comando = new SqlCommand("select email, clave from CrmCustomers where email = '" + user + "'and clave = '" + password + "' ", miConexion);
- comando.ExecuteNonQuery();
- DataSet ds = new DataSet();
- SqlDataAdapter da = new SqlDataAdapter(comando);
- da.Fill(ds, "CrmCustomers");
- DataRow DR;
- DR = ds.Tables["CrmCustomers"].Rows[0];
- if ((user == DR["email"].ToString()) && (password == DR["clave"].ToString()))
- {
- miConexion.Close();
- return 1;
- }
- else
- {
- miConexion.Close();
- return 2;
- }
- }
- catch (Exception ex)
- {
- miConexion.Close();
- return 3;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement