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