Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Data.SqlClient;
- using System.Configuration;
- using System.Web.UI.WebControls;
- /// <summary>
- /// Summary description for AccountDetails
- /// </summary>
- public class AccountDetails
- {
- string _connStr = ConfigurationManager.ConnectionStrings["CreateAccount"].ConnectionString;
- private string _UserName;
- private string _Password;
- private string _Dob;
- private string _Email;
- private string _Gender;
- public AccountDetails()
- {
- }
- //overloaded class constructor with 4 parameters
- public AccountDetails(string p_UserName, string p_Password, string p_Dob, string p_Gender, string p_Email)
- {
- this.UserName = p_UserName;
- this.Password = p_Password;
- this.Dob = p_Dob;
- this.Gender = p_Gender;
- this.Email = p_Email;
- }
- public int CreateAccount()
- {
- string msg = null;
- int result = 0;
- string queryStr = "INSERT INTO Accountdetails(Username,Password,Dob,Gender,Email)"
- + "values (@UserName,@Password,@Dob , @Gender, @Email)";
- SqlConnection conn = new SqlConnection(_connStr);
- SqlCommand cmd = new SqlCommand(queryStr, conn);
- cmd.Parameters.AddWithValue("@UserName", this.UserName);
- cmd.Parameters.AddWithValue("@Password", this.Password);
- cmd.Parameters.AddWithValue("@Dob", this.Dob);
- cmd.Parameters.AddWithValue("@Gender", this.Gender);
- cmd.Parameters.AddWithValue("@Email", this.Email);
- conn.Open();
- result += cmd.ExecuteNonQuery(); // Returns no. of rows affected. Must be > 0
- conn.Close();
- return result;
- }
- //public class properties, accessing from outside the class is possible
- public string UserName
- {
- get { return _UserName; }
- set { _UserName = value; }
- }
- public string Password
- {
- get { return _Password; }
- set { _Password = value; }
- }
- public string Dob
- {
- get { return _Dob; }
- set { _Dob = value; }
- }
- public string Gender
- {
- get { return _Gender; }
- set { _Gender = value; }
- }
- public string Email
- {
- get { return _Email; }
- set { _Email = value; }
- }
- }
- this is the code im using
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement