public int RegisterEmployee(string empName, string empGender, string empDOB, string empAddress, string empCity, 
        string empPhoneNumber, string empEmailAddress, int empType, string empDateOfJoin, 
        string empDateOfLeave, int empBank, string empAccountNumber)
    {
        RegisterEmployeeBO objRegisterEmployeeBO = new RegisterEmployeeBO();
        objRegisterEmployeeBO.empName = empName;
        objRegisterEmployeeBO.empGender = empGender;
        objRegisterEmployeeBO.empDOB = empDOB;
        objRegisterEmployeeBO.empAddress = empAddress;
        objRegisterEmployeeBO.empPhoneNumber = empPhoneNumber;
        objRegisterEmployeeBO.empEmailAddress = empEmailAddress;
        objRegisterEmployeeBO.empType = empType;
        objRegisterEmployeeBO.empDateOfJoin = empDateOfJoin;
        objRegisterEmployeeBO.empDateOfLeave = empDateOfLeave;
        objRegisterEmployeeBO.empBank = empBank;
        objRegisterEmployeeBO.empAccountNumber = empAccountNumber;

        RegisterEmployeeDL objRegisterEmployeeDL = new RegisterEmployeeDL();
        return objRegisterEmployeeDL.RegisterEmployee(objRegisterEmployeeBO);
    }
    public int RegisterEmployee(string empName, string empGender, string empDOB, string empAddress, string empCity,
                                string empPhoneNumber, string empEmailAddress, int empType, string empDateOfJoin,
                                string empDateOfLeave, int empBank, string empAccountNumber)
    {
        RegisterEmployeeBO objRegisterEmployeeBO = new RegisterEmployeeBO();

        objRegisterEmployeeBO.empName          = empName;
        objRegisterEmployeeBO.empGender        = empGender;
        objRegisterEmployeeBO.empDOB           = empDOB;
        objRegisterEmployeeBO.empAddress       = empAddress;
        objRegisterEmployeeBO.empPhoneNumber   = empPhoneNumber;
        objRegisterEmployeeBO.empEmailAddress  = empEmailAddress;
        objRegisterEmployeeBO.empType          = empType;
        objRegisterEmployeeBO.empDateOfJoin    = empDateOfJoin;
        objRegisterEmployeeBO.empDateOfLeave   = empDateOfLeave;
        objRegisterEmployeeBO.empBank          = empBank;
        objRegisterEmployeeBO.empAccountNumber = empAccountNumber;

        RegisterEmployeeDL objRegisterEmployeeDL = new RegisterEmployeeDL();

        return(objRegisterEmployeeDL.RegisterEmployee(objRegisterEmployeeBO));
    }
    public int RegisterEmployee(RegisterEmployeeBO objRegisterEmployeeBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd = new SqlCommand("spRegisterEmployee", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@empName", objRegisterEmployeeBO.empName);
        cmd.Parameters.Add("@empGender", objRegisterEmployeeBO.empGender);
        cmd.Parameters.Add("@empDOB", objRegisterEmployeeBO.empDOB);
        cmd.Parameters.Add("@empAddress", objRegisterEmployeeBO.empAddress);
        cmd.Parameters.Add("@empPhoneNumber", objRegisterEmployeeBO.empPhoneNumber);
        cmd.Parameters.Add("@empEmailAddress", objRegisterEmployeeBO.empEmailAddress);
        cmd.Parameters.Add("@empType", objRegisterEmployeeBO.empType);
        cmd.Parameters.Add("@empDateOfJoin", objRegisterEmployeeBO.empDateOfJoin);
        cmd.Parameters.Add("@empDateOfLeave", objRegisterEmployeeBO.empDateOfLeave);
        cmd.Parameters.Add("@empBank", objRegisterEmployeeBO.empBank);
        cmd.Parameters.Add("@empAccountNumber", objRegisterEmployeeBO.empAccountNumber);

        conn.Open();
        int id = Convert.ToInt32(cmd.ExecuteScalar());
        conn.Close();
        return id;
    }
Exemplo n.º 4
0
    public int RegisterEmployee(RegisterEmployeeBO objRegisterEmployeeBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand    cmd  = new SqlCommand("spRegisterEmployee", conn);

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@empName", objRegisterEmployeeBO.empName);
        cmd.Parameters.Add("@empGender", objRegisterEmployeeBO.empGender);
        cmd.Parameters.Add("@empDOB", objRegisterEmployeeBO.empDOB);
        cmd.Parameters.Add("@empAddress", objRegisterEmployeeBO.empAddress);
        cmd.Parameters.Add("@empPhoneNumber", objRegisterEmployeeBO.empPhoneNumber);
        cmd.Parameters.Add("@empEmailAddress", objRegisterEmployeeBO.empEmailAddress);
        cmd.Parameters.Add("@empType", objRegisterEmployeeBO.empType);
        cmd.Parameters.Add("@empDateOfJoin", objRegisterEmployeeBO.empDateOfJoin);
        cmd.Parameters.Add("@empDateOfLeave", objRegisterEmployeeBO.empDateOfLeave);
        cmd.Parameters.Add("@empBank", objRegisterEmployeeBO.empBank);
        cmd.Parameters.Add("@empAccountNumber", objRegisterEmployeeBO.empAccountNumber);

        conn.Open();
        int id = Convert.ToInt32(cmd.ExecuteScalar());

        conn.Close();
        return(id);
    }