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