public bool Insert(RegistrationInfo obj) { HomeoPathFramework da = new HomeoPathFramework(); SqlCommand cmd = da.GetCommand("insert into [dbo].[User_Doctor] ([User_Name],[User_Password])" + "values(@Name,@Password)"); SqlParameter p = new SqlParameter("@Name", SqlDbType.VarChar, 50); p.Value = obj.UserName; SqlParameter p1 = new SqlParameter("@Password", SqlDbType.VarChar, 50); p1.Value = obj.Password; cmd.Parameters.Add(p); cmd.Parameters.Add(p1); cmd.Connection.Open(); int val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return val > 0; }
RegistrationInfo GetData(SqlCommand cmd) { cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); RegistrationInfo ob = new RegistrationInfo(); using (reader) { while (reader.Read()) { ob.Id = reader.GetInt32(0); ob.UserName = reader.GetString(1); ob.Password = reader.GetString(2); } reader.Close(); } cmd.Connection.Close(); return ob; }