//Login Function// public bool LoginUser() { conn = DBConnection.GetConnection(); SqlCommand comm = new SqlCommand("SELECT name FROM users WHERE username='******' and password='******'", conn); SqlDataReader rdr = comm.ExecuteReader(); if (rdr.Read() == true) { StringManip s1 = new StringManip(); string ab = rdr.GetString(0); username = s1.StrSplit(ab); return true; } else return false; }
//Override Savedata Method public override bool SaveData() { StringManip s1 = new StringManip(); name = s1.StrConcat(first_name,last_name); CheckAge a1 = new CheckAge(); try { a1.Check(Convert.ToInt32(age)); conn = DBConnection.GetConnection(); SqlCommand comm = new SqlCommand("INSERT INTO users VALUES('" + name + "','" + gender + "','" + dob + "','" + address + "','" + city + "','" + pin + "','" + phone + "','" + email + "','" + usertype + "','" + username + "','" + password + "'," + Convert.ToInt32(age) + ")", conn); int confirm = comm.ExecuteNonQuery(); if (confirm > 0) return true; else return false; } catch (AgeException age1) { error = age1.Errormsg; return false; } }