private bool isRegulated() { if (username.Trim().Length == 0) { MessageBox.Show("Username is empty!"); return false; } if (password.Trim().Length == 0 || repPassword.Trim().Length == 0) { MessageBox.Show("One of the password fields is empty!"); return false; } if (!password.Equals(repPassword)) { MessageBox.Show("Passwords do not match."); return false; } username = username.Trim(); using (OracleConnection conn = new OracleConnection(FormLogin.connString)) // using avtomatski ja zatvora otvorenata konekcija { conn.Open(); // mozhebi bi bilo podobro da se realizira so funkcija na nivo na baza string query = "SELECT COUNT(*) FROM Tipster WHERE UPPER(username) LIKE '" + username.ToUpper() + "'"; OracleCommand commCheck = new OracleCommand(query, conn); commCheck.CommandType = CommandType.Text; Object o = commCheck.ExecuteScalar(); int numRows = Int32.Parse(o.ToString()); if (numRows != 0) { MessageBox.Show("Already exists tipster with that username."); conn.Clone(); // za sekoj slucaj return false; } } return true; }
private void GetCommonData() { List<HejriCommonDate> hejriCommonDateList = new List<HejriCommonDate>(); OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OracleCommand com = new OracleCommand("VW_HEJRA_DATES_FIND_ALL", conn); try { conn.Open(); com.CommandType = System.Data.CommandType.StoredProcedure; OracleParameter parameter = new OracleParameter(); parameter.Direction = System.Data.ParameterDirection.InputOutput; parameter.OracleDbType = OracleDbType.RefCursor; com.Parameters.Add(parameter); OracleDataReader reader = com.ExecuteReader(); while (reader.Read()) { HejriCommonDate hejriCommonDate = new HejriCommonDate(); hejriCommonDate = HejriCommonDateHelper(reader); if (hejriCommonDate != null) hejriCommonDateList.Add(hejriCommonDate); } } catch (Exception ex) { } finally { conn.Close(); conn.Clone(); com.Clone(); } list = hejriCommonDateList; }