public bool InsertCategory(CatagoryInfo obj)
 {
     SqlDBdataAccess da = new SqlDBdataAccess();
     SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Category] ([Category_Name])" + "values(@CategoryName)");
     SqlParameter p = new SqlParameter("@CategoryName", SqlDbType.VarChar, 50);
     p.Value = obj.CatagoryName;
     cmd.Parameters.Add(p);
     cmd.Connection.Open();
     int val = cmd.ExecuteNonQuery();
     cmd.Connection.Close();
     return val > 0;
 }
        List<CatagoryInfo> GetData(SqlCommand cmd)
        {
            cmd.Connection.Open();
            SqlDataReader reader = cmd.ExecuteReader();

            List<CatagoryInfo> list = new List<CatagoryInfo>();
            using (reader)
            {
                while (reader.Read())
                {
                    CatagoryInfo ob = new CatagoryInfo();
                    ob.Id = reader.GetInt32(0);
                    ob.CatagoryName = reader.GetString(1);
                    list.Add(ob);
                }
                reader.Close();
            }
            cmd.Connection.Close();
            return list;
        }