Пример #1
0
        public bool RemoveEmployeeArea(string adLoginID, int subAreaID)
        {
            List<System.Data.SqlClient.SqlParameter> parameters = new List<System.Data.SqlClient.SqlParameter>();
            string storedProcedure = "delEmployeeArea";
            int rowsAffected = 0;

            FinalBuild.DataAccess ado = new FinalBuild.DataAccess(System.Configuration.ConfigurationManager.ConnectionStrings["PersonnelContext"].ConnectionString);
            parameters.Add(new System.Data.SqlClient.SqlParameter("@ADLoginID", adLoginID));
            parameters.Add(new System.Data.SqlClient.SqlParameter("@SubAreaID", subAreaID));
            rowsAffected = ado.ExecuteSQL(storedProcedure, parameters.ToArray());

            return (rowsAffected > 0);
        }