bal

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using Test_1.DAL;

namespace Test_1.BAL
{
    public class BLL_info
    {
        public static string getName
        {
            get;
            set;
        }
        public static string getAge
        {
            get;
            set;
        }
        public static string getGender
        {
            get;
            set;
        }
        public static string getProfession
        {
            get;
            set;
        }

        public static void insert_into_std()
        {
           
            SqlParameter[] prm = new SqlParameter[4];
            prm[0] = new SqlParameter("@name", getName);
            prm[1] = new SqlParameter("@age", getAge);
            prm[2] = new SqlParameter("@gender", getGender);
            prm[3] = new SqlParameter("@profession", getProfession);

            dll.executeQuery("Insert_Into_Std_info", prm);

        }

        public static void insert_into_srv()
        {
            SqlParameter[] prm = new SqlParameter[4];
            prm[0] = new SqlParameter("@name", getName);
            prm[1] = new SqlParameter("@age", getAge);
            prm[2] = new SqlParameter("@gender", getGender);
            prm[3] = new SqlParameter("@profession", getProfession);

            dll.executeQuery("Insert_Into_Srv_info", prm);
        }

        public static void insert_into_bsn()
        {
            SqlParameter[] prm = new SqlParameter[4];
            prm[0] = new SqlParameter("@name", getName);
            prm[1] = new SqlParameter("@age", getAge);
            prm[2] = new SqlParameter("@gender", getGender);
            prm[3] = new SqlParameter("@profession", getProfession);

            dll.executeQuery("Insert_Into_Bsn_info", prm);
        }

        public static DataSet Std_info_Bind()
        {
           return dll.bind_Grid("Show_in_grid_Std_nfo");
        }

        public static DataSet Srv_info_Bind()
        {
           return dll.bind_Grid("Show_in_grid_Srv_nfo");
        }

        public static DataSet Bsn_info_Bind()
        {
           return dll.bind_Grid("Show_in_grid_Bsn_nfo");
        }
    }
}